public bool ModifyDrawBill(MDrawBill mBill)
        {
            StringBuilder strSQLText = new StringBuilder();
            strSQLText.Append("update DrawBill set ");
            OracleParameter[] param = 
            {
new OracleParameter("PKID", OracleType.Int32),
new OracleParameter("StationId", OracleType.VarChar),
new OracleParameter("BillBegin", OracleType.VarChar),
new OracleParameter("BillEnd", OracleType.VarChar),
new OracleParameter("SumCount", OracleType.Int32),
new OracleParameter("DrawDate", OracleType.DateTime),
new OracleParameter("IsConfirm", OracleType.Int32),
new OracleParameter("AppUser", OracleType.NVarChar),
new OracleParameter("CheckUser", OracleType.NVarChar),
new OracleParameter("Memo", OracleType.NVarChar)
            };
            //@@lwd 20110803
            param[0].Value = mBill.PKID;
            if (mBill.StationId != null)
            {
                strSQLText.Append("StationId=:StationId,");
                param[1].Value = mBill.StationId;                
            }
            if (mBill.BillBegin != null)
            {
                strSQLText.Append("BillBegin=:BillBegin,");
                param[2].Value = mBill.BillBegin;
            }
            if (mBill.BillEnd != null)
            {
                strSQLText.Append("BillEnd=:BillEnd,");
                param[3].Value = mBill.BillEnd;
            }
            if (mBill.SumCount != null)
            {
                strSQLText.Append("SumCount=:SumCount,");
                param[4].Value = mBill.SumCount;
            }
            if (mBill.DrawDate != null)
            {
                strSQLText.Append("DrawDate=:DrawDate,");
                param[5].Value = mBill.DrawDate;             
            }
            if (mBill.IsConfirm != null)
            {
                strSQLText.Append("IsConfirm=:IsConfirm,");
                param[6].Value = mBill.IsConfirm;
            }
            if (mBill.AppUser != null)
            {
                strSQLText.Append("AppUser=:AppUser,");
                param[7].Value = mBill.AppUser;
            }
            if (mBill.CheckUser != null)
            {
                strSQLText.Append("CheckUser=:CheckUser,");
                param[8].Value = mBill.CheckUser;
            }
            if (mBill.Memo != null)
            {
                strSQLText.Append("Memo=:Memo,");
                param[9].Value = mBill.Memo;
            }
            if (strSQLText.ToString().EndsWith(","))
            {
                strSQLText = strSQLText.Remove(strSQLText.ToString().Length - 1, 1);            }
            strSQLText.Append(" where PKID=:PKID ");
            return OracleHelper.ExecuteNonQuery(OracleHelper.Connection_String, CommandType.Text, strSQLText.ToString(), param) > 0;//提示“RA-01036: 非法的变量名/编号”        }