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);
}
}
