/// <summary>
/// 保存采购单主表
/// </summary>
/// <param name="model"></param>
/// <param name="logedinUser"></param>
/// <param name="transaction"></param>
public void SaveOrdPurchaseModel(OrdPurchaseModel model, LogedInUser logedinUser, DbTransaction transaction)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"Insert Into HC_ORD_PURCHASE
(
ID,
BUYER_ID,
CODE,
TYPE,
TOTAL_SUM,
PURCHASE_DATE,
CREATE_USER_ID,
CREATE_USER_NAME,
STATE,
AUDIT_USER_ID,
AUDIT_USER_NAME,
AUDIT_DATE,
MODIFY_USER_ID,
MODIFY_USER_NAME,
MODIFY_DATE,
QUICKSEND_LEVEL,
CREATE_DATE,
SYNC_STATE
)");
strSql.Append(" Values (");
strSql.AppendFormat("{0},", model.Id);
strSql.AppendFormat("{0},", model.Buyer_Id);
strSql.AppendFormat("'{0}',", model.Code);
strSql.AppendFormat("'{0}',", model.Type);
strSql.AppendFormat("{0},", model.Total_Sum);
strSql.AppendFormat("'{0}',", model.Purchase_Date);
strSql.AppendFormat("'{0}',", logedinUser.UserInfo.Id);
strSql.AppendFormat("'{0}',", logedinUser.UserInfo.Name);
strSql.AppendFormat("'{0}',", model.State);
strSql.AppendFormat("'{0}',", logedinUser.UserInfo.Id);
strSql.AppendFormat("'{0}',", logedinUser.UserInfo.Name);
strSql.AppendFormat("'{0}',", DateTime.Now.ToString());
strSql.AppendFormat("'{0}',", logedinUser.UserInfo.Id);
strSql.AppendFormat("'{0}',", logedinUser.UserInfo.Name);
strSql.AppendFormat("'{0}',", DateTime.Now.ToString());
strSql.Append("'1',");
strSql.AppendFormat("'{0}',", DateTime.Now.ToString());
strSql.Append("'0'");
strSql.Append(")");
try
{
base.DbFacade.SQLExecuteNonQuery(strSql.ToString(), transaction);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 【发货流程】 操作表有（采购单、采购单明细、订单表、订单明细、备货表、到货表、订单结果表、日志）
/// </summary>
/// <param name="Listmodel"></param>
/// <param name="ordPurchaseModel"></param>
/// <param name="logedinUser"></param>
public void OrdInvoiceFrom(List <OrdSecondAyrlnvUseModel> Listmodel, OrdPurchaseModel ordPurchaseModel, OrdOrderModel ordOrderModel, LogedInUser logedinUser)
{
try
{
dao.OrdInvoiceFrom(Listmodel, ordPurchaseModel, ordOrderModel, logedinUser);
}
catch (Exception ex)
{
throw ex;
}
}
/// <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>
/// 页面加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void UseOddAudiForm_Load(object sender, EventArgs e)
{
CurrentUser = base.CurrentUser;
//绑定表格中下拉框（库房）
InitGrid_Cmb();
//绑定库存商品列表数据集
DataBindAyplnv();
//绑定消耗商品列表数据集
DataBindConsume();
ListOrdSecondAyrlnvUseModel = new List <OrdSecondAyrlnvUseModel>();
ordPurchaseModel = new OrdPurchaseModel();
ordOrderModel = new OrdOrderModel();
}
