/// <summary>
/// 修改发货单明细表状态 （状态：1 未确认 2 已确认 3 作废）
/// </summary>
/// <param name="model"></param>
/// <param name="State"></param>
/// <param name="logedinUser"></param>
/// <param name="transaction"></param>
public void ModifyOrdInvoiceFromItemState(OrdInvoiceFromItemModel model, string State, LogedInUser logedinUser, DbTransaction transaction)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"Update HC_ORD_INVOICE_FROM_ITEM
Set SYNC_STATE='0',
STATE='{0}',
OVER_AMOUNT={1},
OVER_SUM={2},
MODIFY_USER_ID='{3}',
MODIFY_USER_NAME='{4}',
MODIFY_DATE='{5}'",
State, model.Over_Amount, model.Over_Sum, logedinUser.UserInfo.Id, logedinUser.UserInfo.Name, DateTime.Now.ToShortDateString());
if (!string.IsNullOrEmpty(model.Instore_Batch_No))
{
strSql.AppendFormat(",INSTORE_BATCH_NO='{0}'", model.Instore_Batch_No);
}
strSql.AppendFormat(" Where ID='{0}'", model.Id);
try
{
base.DbFacade.SQLExecuteNonQuery(strSql.ToString(), transaction);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取发货单明细对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private OrdInvoiceFromItemModel GetOrdInvoiceFromItemModel(DataRow dr)
{
OrdInvoiceFromItemModel model = new OrdInvoiceFromItemModel();
model.Id = dr["ID"].ToString();
//model.Data_Product_Id = dr["DATA_PRODUCT_ID"].ToString();
model.Instore_Batch_No = dr["INSTORE_BATCH_NO"].ToString();
model.Price = dr["PRICE"].ToString();
model.Over_Amount = dr["OVERAMOUNT"].ToString();
model.Over_Sum = Convert.ToDecimal(model.Over_Amount) * Convert.ToDecimal(model.Price);
return(model);
}
/// <summary>
/// 获取发货单明细对象列表
/// </summary>
/// <returns></returns>
private List <OrdInvoiceFromItemModel> GetListOrdInvoiceFromItemModel()
{
ListOrdInvoiceFromItemModel.Clear();
DataTable Dt = NoSend_OrdInvoiceFromItemDt.DefaultView.ToTable();
foreach (DataRow dr in Dt.Rows)
{
string strSel = dr["Sel"].ToString();
if (strSel.Equals("1"))
{
OrdInvoiceFromItemModel model = GetOrdInvoiceFromItemModel(dr);
ListOrdInvoiceFromItemModel.Add(model);
}
}
return(ListOrdInvoiceFromItemModel);
}
