private void CreateROAdjustItem(GatherSettlementInfo entity, string solist) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("InsertConsignSettleGatherRO_Adjust"); using (DynamicQuerySqlBuilder builder = new DynamicQuerySqlBuilder(command.CommandText, command, null, "b.SONumber DESC")) { if (entity.VendorInfo.SysNo.HasValue) { builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ship.MerchantSysNo", DbType.Int32, "@VendorSysNo", QueryConditionOperatorType.Equal, entity.VendorInfo.SysNo); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "main.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, entity.CompanyCode); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "s.ReferenceType", DbType.AnsiStringFixedLength, "@ReferenceType", QueryConditionOperatorType.IsNull, DBNull.Value); } command.CommandText = builder.BuildQuerySql(); string strSQL3 = string.Empty; // ##OrderDate3## if (entity.CreateDateFrom.HasValue) { strSQL3 += " AND main.CreateTime>'" + entity.CreateDateFrom.Value.ToShortDateString() + "'"; } if (entity.CreateDateTo.HasValue) { strSQL3 += " AND main.CreateTime<'" + entity.CreateDateTo.Value.AddDays(1).ToShortDateString() + "'"; } command.CommandText = command.CommandText.Replace("##OrderDate3##", strSQL3); } command.CommandText = command.CommandText.Replace("#SONumber#", solist) .Replace("#StoreCompanyCode#", "'" + entity.CompanyCode + "'") .Replace("#CompanyCode#", "'" + entity.CompanyCode + "'") .Replace("#InUser#", "'" + entity.CreateUserName + "'") .Replace("#SettlementSysNo#", entity.SysNo.Value.ToString()); command.ExecuteNonQuery(); }
public int CreateStorePageHeader(StorePageHeader info) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("CreateStorePageHeader"); command.SetParameterValue(info); return(command.ExecuteNonQuery()); }
public void SetMultiLanguageBizEntity(MultiLanguageBizEntity entity) { CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("SetMultiLanguageTemplate"); string tableName = entity.MappingTable; string pkcriteria = string.Format(" SysNo={0} AND LanguageCode='{1}'", entity.SysNo, entity.LanguageCode.Replace("'", "''")); string insertColumns = string.Empty; string insertValues = string.Empty; string updateColumns = string.Empty; insertColumns = " LanguageCode,SysNo,"; insertValues = " @LanguageCode,@SysNo,"; cmd.AddInputParameter("@LanguageCode", System.Data.DbType.AnsiStringFixedLength); cmd.SetParameterValue("@LanguageCode", entity.LanguageCode); cmd.AddInputParameter("@SysNo", System.Data.DbType.AnsiStringFixedLength); cmd.SetParameterValue("@SysNo", entity.SysNo); foreach (PropertyItem propItem in entity.PropertyItemList) { insertColumns += " " + propItem.Field + ","; insertValues += " @" + propItem.Field + ","; updateColumns += string.Format(" {0}=@{0},", propItem.Field); cmd.AddInputParameter("@" + propItem.Field, System.Data.DbType.AnsiStringFixedLength); cmd.SetParameterValue("@" + propItem.Field, propItem.Value); } insertColumns = insertColumns.TrimEnd(','); insertValues = insertValues.TrimEnd(','); updateColumns = updateColumns.TrimEnd(','); cmd.CommandText = cmd.CommandText.Replace("#tableName", tableName).Replace("#pkcriteria", pkcriteria).Replace("#insertColumns", insertColumns).Replace("#insertValues", insertValues).Replace("#updateColumns", updateColumns); cmd.ExecuteNonQuery(); }
public void DeleteStorePageInfo(int SysNo) { CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("BatchDeleteStorePageInfo"); dataCommand.SetParameterValue("@SysNo", SysNo); dataCommand.ExecuteNonQuery(); }
public void SetCommissionRuleStatus(string sysnos, CommissionRuleStatus commissionRuleStatus) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("SetCommissionRuleStatus"); command.SetParameterValue("@Status", commissionRuleStatus); command.CommandText = command.CommandText.Replace("#sysnos#", sysnos); command.ExecuteNonQuery(); }
public static void RemoveSpiteCustomers(string IDStr) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("RemoveSpiteCustomers"); command.CommandText = command.CommandText.Replace("#RemoveIDStr#", IDStr); command.AddInputParameter("@CompanyCode", System.Data.DbType.StringFixedLength, CompanyCode); command.ExecuteNonQuery(); }
/// <summary> /// 取消拆分,将母单和子单的收款信息都作废 /// </summary> /// <param name="master">母单</param> /// <param name="subList">子单列表</param> public void AbandonSplitForSO(SOBaseInfo master, List <SOBaseInfo> subList) { CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("AbandonSplitSOIncomeForSO"); cmd.CommandText = cmd.CommandText.Replace("@SoSysNoList@", subList.ToListString("SysNo")); cmd.AddInputParameter("@MasterSoSysNo", DbType.AnsiStringFixedLength, master.SysNo); cmd.ExecuteNonQuery(); }
/// <summary> /// 更新收款单状态为已处理,用于收款单自动确认时更新母单的收款状态为已处理 /// </summary> /// <param name="entityList">收款单系统编号列表</param> /// <returns>此次更新的收款单列表</returns> public void UpdateToProcessedStatus(List <SOIncomeInfo> entityList) { CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("UpdateToProcessedStatus"); dataCommand.CommandText.Replace("#SysNo#", entityList.ToListString("SysNo")); dataCommand.ExecuteNonQuery(); }
public void CheckStorePageInfo(int SysNo, int Status) { CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("CheckStorePageInfo"); dataCommand.SetParameterValue("@SysNo", SysNo); dataCommand.SetParameterValue("@Status", Status); dataCommand.ExecuteNonQuery(); }
public static bool MakeOpered(int SoSysNo) { List <SOEntity> result = new List <SOEntity>(); CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("MakeOpered"); command.AddInputParameter("@SOSysNo", DbType.Int32, SoSysNo); return(command.ExecuteNonQuery() > 0); }
public void SendVatSSB(string xmlMsg) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("SendVatSSB"); command.SetParameterValue("@Msg", xmlMsg); command.ExecuteNonQuery(); }
public static void AddSpiteUsers() { // DataCommand command = DataCommandManager.GetDataCommand("AddRejectionUsers"); CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("AddSpiteUsers"); command.AddInputParameter("@CompanyCode", System.Data.DbType.StringFixedLength, CompanyCode); command.ExecuteNonQuery(); }
/// <summary> /// 删除配送方式-产品 /// </summary> /// <param name="sysNoList"></param> /// <returns></returns> public void VoidShipTypeProduct(List <int?> sysNoList) { if (sysNoList != null && sysNoList.Count > 0) { CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ShipTypeProduct_Void"); cmd.CommandText = cmd.CommandText.Replace("@SysNo", String.Join(",", sysNoList)); cmd.ExecuteNonQuery(); } }
public static void RemoveRejectionUser(int CustomerSysNo) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("RemoveRejectionUser"); command.AddInputParameter("@RemoveID", System.Data.DbType.Int32, CustomerSysNo); command.AddInputParameter("@CompanyCode", System.Data.DbType.StringFixedLength, CompanyCode); command.ExecuteNonQuery(); }
public static void AddRejectionUsers2(string ReceiveAddress) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("AddRejectionUsers2"); command.AddInputParameter("@ReceiveAddress", System.Data.DbType.String, ReceiveAddress); command.AddInputParameter("@CompanyCode", System.Data.DbType.StringFixedLength, CompanyCode); command.ExecuteNonQuery(); }
public static QueryResponseDTO <bool> DeletePostHistoryInfo(PostDTO dto) { QueryResponseDTO <bool> response = new QueryResponseDTO <bool>(); response.ResultEntity = false; CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("RemovePostHistoryInfo"); using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder( dataCommand.CommandText, dataCommand, dto.PagingInfo, "ID ASC")) { if (null != dto) { if (!string.IsNullOrEmpty(dto.PostID)) { sqlBuilder.ConditionConstructor .AddCondition(QueryConditionRelationType.AND, "PostID", DbType.AnsiString, "@PostID", QueryConditionOperatorType.Equal, dto.PostID); } if (dto.PostCost > 0) { sqlBuilder.ConditionConstructor .AddCondition(QueryConditionRelationType.AND, "PostCost", DbType.Int32, "@PostCost", QueryConditionOperatorType.LessThanOrEqual, dto.PostCost); } if (dto.PostSpeed > 0) { sqlBuilder.ConditionConstructor .AddCondition(QueryConditionRelationType.AND, "PostSpeed", DbType.Int32, "@PostSpeed", QueryConditionOperatorType.MoreThanOrEqual, dto.PostSpeed); } if (dto.PostStart > 0) { sqlBuilder.ConditionConstructor .AddCondition(QueryConditionRelationType.AND, "PostStart", DbType.Int32, "@PostStart", QueryConditionOperatorType.LessThanOrEqual, dto.PostStart); } } //QueryData dataCommand.CommandText = sqlBuilder.BuildQuerySql(); var updateRows = dataCommand.ExecuteNonQuery(); if (updateRows > 0) { response.ResultEntity = true; response.Code = ResponseStaticModel.Code.OK; response.Message = ResponseStaticModel.Message.OK; } else { response.ResultEntity = false; response.Code = ResponseStaticModel.Code.FAILED; response.Message = ResponseStaticModel.Message.FAILED; } } return(response); }
public void UpdateMarkException(string duplicateSOSysNo, int productSysNo, string soSysNos) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("SO_Update_MarkException"); command.CommandText = command.CommandText.Replace("#SOSysNos#", soSysNos); command.SetParameterValue("@DuplicateSOSysNo", duplicateSOSysNo); command.SetParameterValue("@ProductSysNo", productSysNo); command.ExecuteNonQuery(); }
public static void RemoveOccupyStockUser(string CustomerSysNo) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("RemoveOccupyStockUser"); // command.AddInputParameter("@RemoveID", System.Data.DbType.String, CustomerSysNo); command.ReplaceParameterValue("@RemoveID", CustomerSysNo); command.ReplaceParameterValue("@CompanyCode", CompanyCode); command.ExecuteNonQuery(); }
/// <summary> /// 删除配送方式-地区-价格 /// </summary> /// <param name="sysNoList"></param> /// <param name="merchantSysNo"></param> /// <returns></returns> public static bool VoidShipTypeAreaPrice(List <int> sysNoList, int merchantSysNo) { if (sysNoList != null && sysNoList.Count > 0) { CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("ShipTypeAreaPrice_Void"); cmd.CommandText = cmd.CommandText.Replace("@SysNo", String.Join(",", sysNoList)); cmd.CommandText = cmd.CommandText.Replace("@MerchantSysNo", merchantSysNo.ToString()); return(cmd.ExecuteNonQuery() > 0); } return(false); }
public void InsertHistory(SOComplaintReplyInfo info) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("InsertComplainHistory"); command.AddInputParameter("@SysNo", DbType.Int32, info.ComplainSysNo); command.AddInputParameter("@HistoryContent", DbType.String, info.HistoryContent); command.AddInputParameter("@CreateUserSysNo", DbType.Int32, ServiceContext.Current.UserSysNo); command.AddInputParameter("@ReplyContent", DbType.String, info.ReplyContent); command.AddInputParameter("@Status", DbType.Int32, info.Status); command.AddInputParameter("@ReplySourceType", DbType.String, info.ReplyType); command.ExecuteNonQuery(); }
public static void UpdateMarkException(string DuplicateSOSysNo, int ProductSysNo, string soSysNos) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("UpdateMarkException"); command.CommandText = command.CommandText.Replace("#SOSysNos#", soSysNos); command.AddInputParameter("@DuplicateSOSysNo", System.Data.DbType.String, DuplicateSOSysNo); command.AddInputParameter("@ProductSysNo", System.Data.DbType.Int32, ProductSysNo); command.ExecuteNonQuery(); }
private void CreateGatherItem(GatherSettlementInfo entity, string solist) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("InsertConsignSettleGatherItems"); using (DynamicQuerySqlBuilder builder = new DynamicQuerySqlBuilder(command.CommandText, command, null, "b.SONumber DESC")) { if (entity.VendorInfo.SysNo.HasValue) { builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ship.MerchantSysNo", DbType.Int32, "@VendorSysNo", QueryConditionOperatorType.Equal, entity.VendorInfo.SysNo.Value); } builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "s.ReferenceType", DbType.AnsiStringFixedLength, "@ReferenceType", QueryConditionOperatorType.IsNull, DBNull.Value); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "main.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, entity.CompanyCode); command.CommandText = builder.BuildQuerySql(); string strSQl1 = string.Empty, strSQl2 = string.Empty; // ##OrderDate1## ##OrderDate2## if (!string.IsNullOrEmpty(entity.ReferenceSysNo)) { strSQl1 += " AND main.SONumber =" + entity.ReferenceSysNo.ToString() + " "; strSQl2 += " AND main.SysNo = " + entity.ReferenceSysNo.ToString() + " "; } if (entity.CreateDateFrom.HasValue) { strSQl1 += " AND main.OrderDate>'" + entity.CreateDateFrom.Value.ToShortDateString() + "'"; strSQl2 += " AND main.CreateTime>'" + entity.CreateDateFrom.Value.ToShortDateString() + "'"; } if (entity.CreateDateTo.HasValue) { strSQl1 += " AND main.OrderDate<'" + entity.CreateDateTo.Value.AddDays(1).ToShortDateString() + "'"; strSQl2 += " AND main.CreateTime<'" + entity.CreateDateTo.Value.AddDays(1).ToShortDateString() + "'"; } if (entity.SourceStockInfo.SysNo.HasValue) { strSQl1 += " AND main.WarehouseNumber=" + entity.SourceStockInfo.SysNo.Value.ToString() + " "; strSQl2 += " AND register.LocationWarehouse=" + entity.SourceStockInfo.SysNo.Value.ToString() + " "; } else { throw new BizException("未选择仓库,不能进行该操作!"); } command.CommandText = command.CommandText.Replace("##OrderDate1##", strSQl1).Replace("##OrderDate2##", strSQl2); } command.CommandText = command.CommandText.Replace("#SONumber#", solist) .Replace("#StoreCompanyCode#", "'" + entity.CompanyCode + "'") .Replace("#CompanyCode#", "'" + entity.CompanyCode + "'") .Replace("#InUser#", "'" + entity.CreateUserName + "'") .Replace("#SettlementSysNo#", entity.SysNo.Value.ToString()); command.ExecuteNonQuery(); }
public static int InsertByCategory(string c1) { CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryPMMPIEntityInfoByCategory"); dataCommand.AddInputParameter("@Category1SysNo", DbType.Int32); dataCommand.AddInputParameter("@Category2SysNo", DbType.Int32); dataCommand.SetParameterValue("@Category1SysNo", c1); dataCommand.SetParameterValue("@Category2SysNo", 0); dataCommand.CommandText = dataCommand.CommandText.Replace("#TempCondition#", " AND Category1SysNo=@Category1SysNo "); dataCommand.CommandTimeout = 60000; return(dataCommand.ExecuteNonQuery()); }
public static int Insert(string PMSysNo) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("QueryPMMPIEntityInfoByAllPM"); command.AddInputParameter("@Category1SysNo", DbType.Int32); command.AddInputParameter("@Category2SysNo", DbType.Int32); command.SetParameterValue("@Category1SysNo", 0); command.SetParameterValue("@Category2SysNo", 0); command.CommandText = command.CommandText.Replace("#PMSysNoList#", PMSysNo); command.CommandTimeout = 60000; return(command.ExecuteNonQuery()); }
/// <summary> /// 删除InvoiceItems /// </summary> /// <param name="invoNoList"></param> public virtual void DeleteInvoItems(List <string> invoNoList) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("DeleteAPInvoItem"); using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder( command.CommandText, command, null, "InvoiceNo")) { sqlBuilder.ConditionConstructor.AddInCondition(QueryConditionRelationType.AND , "InvoiceNo" , DbType.String , invoNoList); command.CommandText = sqlBuilder.BuildQuerySql(); command.ExecuteNonQuery(); } }
public static void AddOccupyStockUsers(int Catalog, string Content) { // DataCommand command = DataCommandManager.GetDataCommand("AddRejectionUsers"); CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("AddOccupyStockUsers"); command.AddInputParameter("@Content", System.Data.DbType.String, Content); command.AddInputParameter("@Catalog", System.Data.DbType.Int32, Catalog); command.AddInputParameter("@CompanyCode", System.Data.DbType.StringFixedLength, CompanyCode); // command.SetParameterValue("@CustomerSysNo", CustomerSysNo); // command.SetParameterValue("@Catalog", Catalog); // command.SetParameterValue("@Column_Name", ColumnName); command.ExecuteNonQuery(); }
public static void AddSinglePhoneNumber(string PhoneNumber, int DuType) { // DataCommand command = DataCommandManager.GetDataCommand("AddRejectionUsers"); CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("AddSinglePhoneNumber"); command.AddInputParameter("@PhoneNumber", System.Data.DbType.String, PhoneNumber); command.AddInputParameter("@DuType", System.Data.DbType.Int32, DuType); command.AddInputParameter("@CompanyCode", System.Data.DbType.StringFixedLength, CompanyCode); // command.SetParameterValue("@CustomerSysNo", CustomerSysNo); // command.SetParameterValue("@Catalog", Catalog); // command.SetParameterValue("@Column_Name", ColumnName); command.ExecuteNonQuery(); }
/// <summary> /// 新建InvoiceItems /// </summary> /// <param name="entitylist"></param> /// <param name="docNo"></param> public virtual void InsertInvoItem(List <APInvoiceInvoiceItemInfo> entitylist, int docNo) { if (entitylist != null && entitylist.Count > 0) { StringBuilder sqlBuilder = new StringBuilder(); string sqlHeader = @"INSERT INTO [OverseaInvoiceReceiptManagement].[dbo].[APInvoice_Invo_Item] ([DocNo] ,[InvoiceNo] ,[InvoiceDate] ,[InvoiceCurrency] ,[InvoiceAmt] ,[InvoiceNetAmt] ,[InvoiceTaxAmt] ,[Status] ,[InUser] ,[InDate] )" ; sqlBuilder.Append(sqlHeader); int countFlag = 0; foreach (APInvoiceInvoiceItemInfo entity in entitylist) { sqlBuilder.Append("\r\nSELECT "); sqlBuilder.Append(docNo.ToString()); AppendText(sqlBuilder, entity.InvoiceNo); AppendText(sqlBuilder, entity.InvoiceDate); AppendNumeric(sqlBuilder, entity.InvoiceCurrency); AppendNumeric(sqlBuilder, entity.InvoiceAmt); AppendNumeric(sqlBuilder, entity.InvoiceNetAmt); AppendNumeric(sqlBuilder, entity.InvoiceTaxAmt); AppendText(sqlBuilder, "D"); AppendText(sqlBuilder, ""); AppendText(sqlBuilder, DateTime.Now); if (++countFlag != entitylist.Count) { sqlBuilder.Append(" UNION ALL"); } } CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("InsertAPInvoItem"); command.CommandType = CommandType.Text; command.CommandText = sqlBuilder.ToString(); command.ExecuteNonQuery(); } }
public void UpdateMarkFPStatus(string soSysNos, int isFPSO, string fpReason, bool isMarkRed) { CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("SO_Update_MarkFPStatus"); command.CommandText = command.CommandText.Replace("#SOSysNos#", soSysNos); command.SetParameterValue("@IsFPSO", isFPSO); command.SetParameterValue("@FPReason", fpReason); if (isMarkRed) { command.SetParameterValue("@FPExtend", "RED"); } else { command.SetParameterValue("@FPExtend", DBNull.Value); } command.ExecuteNonQuery(); }
public virtual object SplitSOPointLog(int customerSysNo, BizEntity.SO.SOBaseInfo master, List <BizEntity.SO.SOBaseInfo> subSoList) { object o = null; //先给obtain表添加原来母单消费的积分 //然后重新记录子订单消费的积分信息 CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("Invoice.AddNewPointForSplitSO"); cmd.AddInputParameter("@CustomerSysno", DbType.Int32, customerSysNo); cmd.AddInputParameter("@Point", DbType.Int32, master.PointPay); cmd.AddInputParameter("@ObtainType", DbType.Int32, AdjustPointType.UpdateSO); cmd.AddInputParameter("@Memo", DbType.String, ResouceManager.GetMessageString("Customer.CustomerPointsAddRequest", "SplitSOPointLogMemo_Obtain")); cmd.SetParameterValueAsCurrentUserSysNo("@InUser"); cmd.AddInputParameter("@SoSysNo", DbType.Int32, master.SysNo); cmd.AddInputParameter("@CompanyCode", DbType.AnsiStringFixedLength, master.CompanyCode); cmd.AddOutParameter("@returnCode", DbType.Int32, 0); cmd.CommandTimeout = 120; cmd.ExecuteNonQuery(); object obj = cmd.GetParameterValue("@returnCode"); if (Convert.ToString(obj) != "1000099") { return(obj); } else { //然后重新记录子订单消费的积分信息 foreach (BizEntity.SO.SOBaseInfo subentity in subSoList) { CustomDataCommand cmdSub = DataCommandManager.CreateCustomDataCommandFromConfig("Invoice.ConsumePointForSplitSO"); cmdSub.AddInputParameter("@CustomerSysno", DbType.Int32, master.CustomerSysNo); cmdSub.AddInputParameter("@Point", DbType.Int32, subentity.PointPay); cmdSub.AddInputParameter("@ConsumeType", DbType.Int32, AdjustPointType.CreateOrder); cmdSub.AddInputParameter("@Memo", DbType.String, ResouceManager.GetMessageString("Customer.CustomerPointsAddRequest", "SplitSOPointLogMemo_Consume")); cmdSub.SetParameterValueAsCurrentUserSysNo("@InUser"); cmdSub.AddInputParameter("@SoSysNo", DbType.Int32, subentity.SysNo); cmdSub.AddInputParameter("@CompanyCode", DbType.AnsiStringFixedLength, master.CompanyCode); cmdSub.AddOutParameter("@returnCode", DbType.Int32, 0); cmdSub.CommandTimeout = 120; cmdSub.ExecuteNonQuery(); o = cmdSub.GetParameterValue("@returnCode"); } return(o); } }