/// <summary>
/// 获取二级库存使用表对象 删除使用
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private OrdSecondAyrlnvUseModel GetOrdSecondAyrlnvUseModelToDel(DataRow dr)
{
OrdSecondAyrlnvUseModel model = new OrdSecondAyrlnvUseModel();
//二级库存使用表ID
model.Id = dr["ID"].ToString();
return(model);
}
/// <summary>
/// 获取发货流程 使用列表
/// </summary>
/// <returns></returns>
private List <OrdSecondAyrlnvUseModel> GetListOrdSecondAyrlnvUseModelToAudi()
{
if (ListOrdSecondAyrlnvUseModel != null)
{
ListOrdSecondAyrlnvUseModel.Clear();
}
decimal total_Num = 0;
DataTable dttemp = NoSend_OrdInvoiceFromItemDt.DefaultView.ToTable();
dttemp.DefaultView.RowFilter = "Sel='1'";
DataTable dt = dttemp.DefaultView.ToTable();
dt = RefreshDt(dt);
foreach (DataRow dr in dt.Rows)
{
string strSel = dr["Sel"].ToString();
if (strSel.Equals("1"))
{
OrdSecondAyrlnvUseModel model = GetOrdSecondAyrlnvUseModelToAudi(dr);
total_Num += model.Fact_Sum;
ListOrdSecondAyrlnvUseModel.Add(model);
}
}
//采购单对象
ordPurchaseModel = null;
ordPurchaseModel = new OrdPurchaseModel();
ordPurchaseModel.Buyer_Id = CurrentUser.UserOrg.Id; //买方ID
ordPurchaseModel.Type = "2"; //采购单类型：发货流程
ordPurchaseModel.Purchase_Date = DateTime.Now.ToString(); //采购日期
ordPurchaseModel.Total_Sum = total_Num; //采购单金额
ordPurchaseModel.State = "4"; //采购单状态：发送状态
//订单对象
ordOrderModel = null;
ordOrderModel = new OrdOrderModel();
ordOrderModel.Buyer_Id = CurrentUser.UserOrg.Id; //买方ID
ordOrderModel.Buyer_Name = CurrentUser.UserOrg.Name; //买方名称
ordOrderModel.Buyer_Name_Abbr = CurrentUser.UserOrg.Abbr; //买方简称
ordOrderModel.State = "5"; //订单状态：完成
ordOrderModel.Type = "2"; //订单 ：发货类型
ordOrderModel.Purchase_Date = ordPurchaseModel.Purchase_Date; //采购日期
ordOrderModel.Quicksend_Level = "1"; //紧急程度 1为“普通”
return(ListOrdSecondAyrlnvUseModel);
}
/// <summary>
/// 获取二级库存使用单对象列表
/// </summary>
/// <returns></returns>
private List <OrdSecondAyrlnvUseModel> GetListOrdSecondAyrlnvUseModelToAudi()
{
ListOrdSecondAyrlnvUseModel.Clear();
decimal total_Num = 0;
DataTable dttemp = ConsumeCommDt.DefaultView.ToTable();
dttemp.DefaultView.RowFilter = "Sel='1'";
DataTable dt = dttemp.DefaultView.ToTable();
dt = RefreshDt(dt);
foreach (DataRow dr in dt.Rows)
{
string strSel = dr["Sel"].ToString();
if (strSel.Equals("1"))
{
OrdSecondAyrlnvUseModel model = GetOrdSecondAyrlnvUseModelToAudi(dr);
total_Num += model.Fact_Sum;
ListOrdSecondAyrlnvUseModel.Add(model);
}
}
ordPurchaseModel = null;
ordPurchaseModel = new OrdPurchaseModel();
ordPurchaseModel.Buyer_Id = CurrentUser.UserOrg.Id;
ordPurchaseModel.Type = "3";
ordPurchaseModel.Purchase_Date = DateTime.Now.ToShortDateString();
ordPurchaseModel.Total_Sum = total_Num;
ordPurchaseModel.State = "4";//采购单状态 发送状态
ordOrderModel = null;
ordOrderModel = new OrdOrderModel();
ordOrderModel.Buyer_Id = CurrentUser.UserOrg.Id;
ordOrderModel.Buyer_Name = CurrentUser.UserOrg.Name;
ordOrderModel.Buyer_Name_Abbr = CurrentUser.UserOrg.Abbr;
//ordOrderModel.Total_Sum = total_Num;
//ordOrderModel.Over_Sum = total_Num;
ordOrderModel.State = "5";
ordOrderModel.Type = "3";//备货类型
ordOrderModel.Purchase_Date = ordPurchaseModel.Purchase_Date;
ordOrderModel.Quicksend_Level = "1";
return(ListOrdSecondAyrlnvUseModel);
}
/// <summary>
/// 修改二级库存表状态 （状态：0 禁用 1 正常）
/// </summary>
/// <param name="HitCommID"></param>
/// <returns></returns>
public void ModifyOrdSecondAyplnvState(OrdSecondAyrlnvUseModel model, string State, LogedInUser logedinUser, DbTransaction transaction)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"Update HC_ORD_SECOND_AYRLNV
Set SYNC_STATE='0',STATE='{0}',MODIFY_USER_ID='{1}',MODIFY_USER_NAME='{2}',MODIFY_DATE='{3}'
Where ID='{4}'", State, logedinUser.UserInfo.Id, logedinUser.UserInfo.Name, DateTime.Now.ToString(), model.SecondId);
try
{
base.DbFacade.SQLExecuteNonQuery(strSql.ToString(), transaction);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取二级库存使用单对象列表 删除使用
/// </summary>
/// <returns></returns>
private List <OrdSecondAyrlnvUseModel> GetListOrdSecondAyrlnvUseModelByToDel()
{
ListOrdSecondAyrlnvUseModel.Clear();
DataTable dt = ConsumeCommDt.DefaultView.ToTable();
foreach (DataRow dr in dt.Rows)
{
string strSel = dr["Sel"].ToString();
if (strSel.Equals("1"))
{
OrdSecondAyrlnvUseModel model = GetOrdSecondAyrlnvUseModelToDel(dr);
ListOrdSecondAyrlnvUseModel.Add(model);
}
}
return(ListOrdSecondAyrlnvUseModel);
}
/// <summary>
/// 获取二级库存使用单对象列表
/// </summary>
/// <returns></returns>
private List <OrdSecondAyrlnvUseModel> GetListOrdSecondAyrlnvUseModel()
{
ListOrdSecondAyrlnvUseModel.Clear();
DataTable dt = OrdSecondAyplnvDt.DefaultView.ToTable();
foreach (DataRow dr in dt.Rows)
{
string strSel = dr["Sel"].ToString();
if (strSel.Equals("1"))
{
string strError = string.Empty;
OrdSecondAyrlnvUseModel model = GetOrdSecondAyrlnvUseModel(dr);
ListOrdSecondAyrlnvUseModel.Add(model);
}
}
return(ListOrdSecondAyrlnvUseModel);
}
/// <summary>
/// 获取二级库存使用单对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private OrdSecondAyrlnvUseModel GetOrdSecondAyrlnvUseModel(DataRow dr)
{
OrdSecondAyrlnvUseModel model = new OrdSecondAyrlnvUseModel();
//二级库存ID
model.SecondId = dr["ID"].ToString();
model.Data_Product_Id = dr["DATA_PRODUCT_ID"].ToString();
model.Project_Id = dr["PROJECT_ID"].ToString();
model.Project_Product_Id = dr["PROJECT_PROD_ID"].ToString();
model.Goods_No = dr["GOODS_NO"].ToString();
model.Barcode = dr["BARCODE"].ToString();
if (string.IsNullOrEmpty(model.Barcode))
{
model.Barcode = " ";
}
if (!dr["PBNO"].ToString().Equals("-"))
{
model.Pbno = dr["PBNO"].ToString();
}
model.Send_Batch_No = dr["SEND_BATCH_NO"].ToString();
model.Instore_Batch_No = dr["INSTORE_BATCH_NO"].ToString();
model.Store_Room_Id = dr["STORE_ROOM_ID"].ToString();
model.Store_Room_Name = dr["STORE_ROOM_NAME"].ToString();
model.Arrive_Date = dr["CREATE_DATE"].ToString();
model.Price = dr["PRICE"].ToString();
model.Fact_Amount = Convert.ToInt16(dr["FACT_AMOUNT"].ToString());
model.Fact_Sum = Convert.ToDecimal(model.Fact_Amount) * Convert.ToDecimal(model.Price);
model.Status = "1";//使用标记
model.Buyer_Id = this.CurrentUser.UserOrg.Id;
model.Sender_Id = dr["SENDER_ID"].ToString();
model.Descriptions = "";
//库存数量
model.Stock_Num = Convert.ToDecimal(dr["NUM"].ToString());
return(model);
}
/// <summary>
/// 获取二级库存使用单对象 用于操作 采购单表、采购明细表、订单表、订单明细表
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private OrdSecondAyrlnvUseModel GetOrdSecondAyrlnvUseModelToAudi(DataRow dr)
{
OrdSecondAyrlnvUseModel model = new OrdSecondAyrlnvUseModel();
//model.Id = dr["ID"].ToString();
model.Data_Product_Id = dr["DATA_PRODUCT_ID"].ToString();
model.Project_Id = dr["PROJECT_ID"].ToString();
model.Project_Product_Id = dr["PROJECT_PRODUCT_ID"].ToString();
model.Common_Name = dr["COMMON_NAME"].ToString();
model.Product_Name = dr["PRODUCT_NAME"].ToString();
model.Product_Code = dr["PRODUCT_CODE"].ToString();
model.Goods_No = dr["GOODS_NO"].ToString();
model.Spec_Id = dr["SPEC_ID"].ToString();
model.Model_Id = dr["MODEL_ID"].ToString();
model.Spec = dr["SPEC"].ToString();
model.Model = dr["MODEL"].ToString();
model.Brand = dr["BRAND"].ToString();
model.Batch_No = dr["BATCH_NO"].ToString();
model.Saler_Id = dr["SALER_ID"].ToString();
model.Saler_Name = dr["SALER_NAME"].ToString();
model.Saler_Name_Abbr = dr["SALER_NAME_ABBR"].ToString();
model.Sender_Id = dr["SENDER_ID"].ToString();
model.Sender_Name = dr["SENDER_NAME"].ToString();
model.Sender_Name_Abbr = dr["SENDER_NAME_ABBR"].ToString();
model.Manu_Id = dr["MANU_ID"].ToString();
model.Manu_Name = dr["MANU_NAME"].ToString();
model.Manu_Name_Abbr = dr["MANU_NAME_ABBR"].ToString();
model.Barcode = dr["BARCODE"].ToString();
model.Arrive_Date = DateTime.Now.ToShortDateString(); //dr["CREATE_DATE"].ToString();
model.Price = dr["PRICE"].ToString(); //单价
//实际到货数量
model.Fact_Amount = Convert.ToDecimal(dr["OVERAMOUNT"].ToString());
//实际到货金额
model.Fact_Sum = Convert.ToDecimal(model.Fact_Amount) * Convert.ToDecimal(model.Price);
//基础计量单位
model.Base_Measure = dr["BASE_MEASURE"].ToString();
//基础单位规格
model.Base_Measure_Spec = dr["BASE_MEASURE_SPEC"].ToString();
//基础单位包装材质
model.Base_Measure_Mate = dr["BASE_MEASURE_MATER"].ToString();
//配送计量单位
model.Send_Measure = dr["SEND_MEASURE"].ToString();
//配送转换率
model.Send_Measure_Ex = dr["SEND_MEASURE_EX"].ToString();
//卖方发货人ID
model.Send_Operator_Id = dr["Send_Operator_Id"].ToString();
model.Send_Operator_Name = dr["Send_Operator_Name"].ToString();
model.Send_Operate_Date = dr["Send_Operate_Date"].ToString();
//买方ID
model.Buyer_Id = CurrentUser.UserOrg.Id;
model.Buyer_Name = CurrentUser.UserOrg.Name;
model.Buyer_Name_Abbr = CurrentUser.UserOrg.Abbr;
if (!dr["PBNO"].ToString().Equals("-"))
{
model.Pbno = dr["PBNO"].ToString();
}
model.Send_Batch_No = dr["SEND_BATCH_NO"].ToString();
model.Instore_Batch_No = dr["INSTORE_BATCH_NO"].ToString();
model.Start_Sender_Flag = dr["StartFlag"].ToString() == "1" ? true : false;
model.Over_Sender_Flag = dr["EndFlag"].ToString() == "1" ? true : false;
//状态
//model.Status = dr["STATUS"].ToString();
//库房ID
model.Store_Room_Id = dr["STORE_ROOM_ID"].ToString();
model.Store_Room_Name = dr["STORE_ROOM_NAME"].ToString();
return(model);
}
