/// <summary>
/// 納品区分更新
/// </summary>
/// <param name="companyId"></param>
/// <param name="db"></param>
/// <param name="customerId"></param>
/// <param name="ipAdress"></param>
/// <param name="userId"></param>
public static void UpdDeliverDivision(gUpdDeliverDivisionKbn kbn,
string companyId,
string groupId,
long Id,
int recNo,
ExMySQLData db,
int deliverDivisionId,
string pg_nm,
int update_person_id,
string ipAdress,
string userId)
{
StringBuilder sb;
try
{
sb = new StringBuilder();
sb.Length = 0;
switch (kbn)
{
case gUpdDeliverDivisionKbn.Order:
sb.Append("UPDATE T_ORDER_D " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(pg_nm,
update_person_id,
ipAdress,
userId,
0));
sb.Append(" ,DELIVER_DIVISION_ID = " + deliverDivisionId.ToString() + Environment.NewLine);
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND GROUP_ID = " + groupId + Environment.NewLine);
sb.Append(" AND ORDER_ID = " + Id + Environment.NewLine);
sb.Append(" AND REC_NO = " + recNo + Environment.NewLine);
break;
case gUpdDeliverDivisionKbn.Purchase:
sb.Append("UPDATE T_PURCHASE_ORDER_D " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(pg_nm,
update_person_id,
ipAdress,
userId,
0));
sb.Append(" ,DELIVER_DIVISION_ID = " + deliverDivisionId.ToString() + Environment.NewLine);
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND GROUP_ID = " + groupId + Environment.NewLine);
sb.Append(" AND PURCHASE_ORDER_ID = " + Id + Environment.NewLine);
sb.Append(" AND REC_NO = " + recNo + Environment.NewLine);
break;
}
db.ExecuteSQL(sb.ToString(), false);
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdDeliverDivision", ex);
throw;
}
}
/// <summary>
/// 納品区分更新
/// </summary>
/// <param name="companyId"></param>
/// <param name="db"></param>
/// <param name="customerId"></param>
/// <param name="ipAdress"></param>
/// <param name="userId"></param>
public static void UpdDeliverDivision(gUpdDeliverDivisionKbn kbn,
string companyId,
string groupId,
long Id,
int recNo,
ExMySQLData db,
int deliverDivisionId,
string pg_nm,
int update_person_id,
string ipAdress,
string userId)
{
StringBuilder sb;
try
{
sb = new StringBuilder();
sb.Length = 0;
switch (kbn)
{
case gUpdDeliverDivisionKbn.Order:
sb.Append("UPDATE T_ORDER_D " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(pg_nm,
update_person_id,
ipAdress,
userId,
0));
sb.Append(" ,DELIVER_DIVISION_ID = " + deliverDivisionId.ToString() + Environment.NewLine);
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND GROUP_ID = " + groupId + Environment.NewLine);
sb.Append(" AND ORDER_ID = " + Id + Environment.NewLine);
sb.Append(" AND REC_NO = " + recNo + Environment.NewLine);
break;
case gUpdDeliverDivisionKbn.Purchase:
sb.Append("UPDATE T_PURCHASE_ORDER_D " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(pg_nm,
update_person_id,
ipAdress,
userId,
0));
sb.Append(" ,DELIVER_DIVISION_ID = " + deliverDivisionId.ToString() + Environment.NewLine);
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND GROUP_ID = " + groupId + Environment.NewLine);
sb.Append(" AND PURCHASE_ORDER_ID = " + Id + Environment.NewLine);
sb.Append(" AND REC_NO = " + recNo + Environment.NewLine);
break;
}
db.ExecuteSQL(sb.ToString(), false);
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdDeliverDivision", ex);
throw;
}
}