/// <summary>
/// 保存(传入事务处理)
/// </summary>
/// <param name="p_Entity"></param>
/// <param name="p_BE"></param>
/// <param name="sqlTrans"></param>
public void RSave(ItemBuyForm p_Entity, BaseEntity[] p_BE, IDBTransAccess sqlTrans)
{
try
{
string sql = "DELETE FROM Buy_ItemBuyFormDts WHERE MainID=" + p_Entity.ID.ToString();
sql += " AND ID NOT IN" + string.Format("({0})", GetIDExist(p_BE));
sqlTrans.ExecuteNonQuery(sql);//删除原单据里应该删除的明细数据，即数据库里有但是UI里已经删除的数据
for (int i = 0; i < p_BE.Length; i++)
{
ItemBuyFormDts entitydts = (ItemBuyFormDts)p_BE[i];
if (entitydts.ID != 0)//ID不为0说明数据库中已经存在
{
this.RUpdate(entitydts, sqlTrans);
}
else
{
entitydts.MainID = p_Entity.ID;
this.RAdd(entitydts, sqlTrans);
}
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 获得实体
/// </summary>
/// <returns></returns>
private ItemBuyForm EntityGet()
{
ItemBuyForm entity = new ItemBuyForm();
entity.ID = HTDataID;
return(entity);
}
/// <summary>
/// 保存资金明细
/// </summary>
/// <param name="p_BE">要新增的实体</param>
public void RSaveBuyCap(ItemBuyForm p_BEMain)
{
try
{
IDBTransAccess sqlTrans = TransSysUtils.GetDBTransAccess();
try
{
sqlTrans.OpenTrans();
this.RSaveBuyCap(p_BEMain, sqlTrans);
sqlTrans.CommitTrans();
}
catch (Exception TE)
{
sqlTrans.RollbackTrans();
throw TE;
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 删除
/// </summary>
public override void EntityDelete()
{
ItemBuyFormRule rule = new ItemBuyFormRule();
ItemBuyForm entity = EntityGet();
rule.RDelete(entity);
}
/// <summary>
/// 获得实体
/// </summary>
/// <returns></returns>
private ItemBuyForm EntityGet()
{
ItemBuyForm entity = new ItemBuyForm();
entity.ID = HTDataID;
entity.SelectByID();
entity.FormNo = txtFormNo.Text.Trim();
entity.MakeOPName = txtMakeOPName.Text.Trim();
entity.MakeDate = txtMakeDate.DateTime.Date;
entity.FormDate = txtFormDate.DateTime.Date;
entity.ReqDate = txtReqDate.DateTime.Date;
entity.OrderFormNo = txtOrderFormNo.Text.Trim();
entity.TotalQty = SysConvert.ToDecimal(txtTotalQty.Text.Trim());
entity.TotalAmount = SysConvert.ToDecimal(txtTotalAmount.Text.Trim());
entity.PayMethodFlag = SysConvert.ToInt32(drpPayMothodFlag.EditValue);
entity.Remark = SysConvert.ToString(txtRemark.Text.Trim());
entity.ShopID = SysConvert.ToString(drpVendorID.EditValue);
entity.OrderFormNo = txtOrderFormNo.Text.Trim();
entity.OrderDate = txtOrderDate.DateTime;
entity.ContractDesc = txtContractDesc.Text.Trim();
entity.SaleOPID = SysConvert.ToString(drpSaleOPID.EditValue);
entity.CGOPID = SysConvert.ToString(drpCGOPID.EditValue);
entity.FormAID = this.FormListAID;
entity.MLType = (int)EnumMLType.辅料;
return(entity);
}
/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
ItemBuyForm entity = (ItemBuyForm)p_BE;
string sql = "SELECT FormNo FROM Buy_ItemBuyForm WHERE FormNo=" + SysString.ToDBString(entity.FormNo);
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("采购单号已存在，请重新生成");
}
ItemBuyFormCtl control = new ItemBuyFormCtl(sqlTrans);
entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Buy_ItemBuyForm, sqlTrans);
control.AddNew(entity);
FormNoControlRule fnrule = new FormNoControlRule();
fnrule.RAddSort("Buy_ItemBuyForm", "FormNo", entity.FormAID, sqlTrans);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 设置
/// </summary>
public override void EntitySet()
{
ItemBuyForm entity = new ItemBuyForm();
entity.ID = HTDataID;
bool findFlag = entity.SelectByID();
HTDataFormNo = entity.FormNo;
txtFormNo.Text = entity.FormNo.ToString();
txtMakeOPName.Text = entity.MakeOPName.ToString();
txtMakeDate.DateTime = entity.MakeDate;
txtFormDate.DateTime = entity.FormDate;
txtReqDate.DateTime = entity.ReqDate;
txtTotalQty.Text = entity.TotalQty.ToString();
txtTotalAmount.Text = entity.TotalAmount.ToString();
drpPayMothodFlag.EditValue = entity.PayMethodFlag;
txtRemark.Text = entity.Remark.ToString();
drpVendorID.EditValue = entity.ShopID;
txtOrderFormNo.Text = entity.OrderFormNo.ToString();
HTDataSubmitFlag = entity.SubmitFlag;
HTDataDelFlag = entity.DelFlag;
txtContractDesc.Text = entity.ContractDesc;
txtOrderDate.DateTime = entity.OrderDate;
drpCGOPID.EditValue = entity.CGOPID;
drpSaleOPID.EditValue = entity.SaleOPID;
if (!findFlag)
{
}
BindGridDts();
BindOrderInfo();
}
/// <summary>
/// 修改
/// </summary>
/// <param name="p_BE">要修改的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RUpdate(BaseEntity p_BE, BaseEntity[] p_BE2, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
ItemBuyForm entity = (ItemBuyForm)p_BE;
ItemBuyFormCtl control = new ItemBuyFormCtl(sqlTrans);
control.Update(entity);
ItemBuyFormDtsRule rule = new ItemBuyFormDtsRule();
rule.RSave(entity, p_BE2, sqlTrans);
//string sql = "DELETE Buy_ItemBuyFormDts WHERE MainID="+SysString.ToDBString(entity.ID);
//sqlTrans.ExecuteNonQuery(sql);
//for (int i = 0; i < p_BE2.Length; i++)
//{
// ItemBuyFormDtsRule rule = new ItemBuyFormDtsRule();
// ItemBuyFormDts entityDts = (ItemBuyFormDts)p_BE2[i];
// entityDts.MainID = entity.ID;
// entityDts.Seq = i + 1;
// rule.RAdd(entityDts, sqlTrans);
//}
ItemBuyCapDtsRule capRule = new ItemBuyCapDtsRule();
capRule.RSaveBuyCap(entity, sqlTrans);//保存资金计划明细
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Delete(BaseEntity p_Entity)
{
try
{
ItemBuyForm MasterEntity = (ItemBuyForm)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//删除主表数据
string Sql = "";
Sql = "DELETE FROM Buy_ItemBuyForm WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID);
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(Sql);
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(Sql);
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBDelete), E);
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="p_BE">要删除的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RDelete(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
ItemBuyForm entity = (ItemBuyForm)p_BE;
ItemBuyFormCtl control = new ItemBuyFormCtl(sqlTrans);
control.Delete(entity);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RAdd(BaseEntity p_BE, BaseEntity[] p_BE2, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
ItemBuyForm entity = (ItemBuyForm)p_BE;
this.RAdd(entity, sqlTrans);
for (int i = 0; i < p_BE2.Length; i++)
{
ItemBuyFormDtsRule rule = new ItemBuyFormDtsRule();
ItemBuyFormDts entityDts = (ItemBuyFormDts)p_BE2[i];
entityDts.MainID = entity.ID;
entityDts.Seq = i + 1;
rule.RAdd(entityDts, sqlTrans);
}
//FormNoControlRule rulest = new FormNoControlRule();
//switch (entity.FormAID) //注意各采购窗体的配置
//{
// case 0:
// rulest.RAddSort((int)FormNoControlEnum.销售合同采购单号, sqlTrans); //采购成品面料
// break;
// case 1:
// rulest.RAddSort((int)FormNoControlEnum.坯布采购单号, sqlTrans);
// break;
// case 2:
// rulest.RAddSort((int)FormNoControlEnum.纱线采购单号, sqlTrans);
// break;
// default:
// rulest.RAddSort((int)FormNoControlEnum.销售合同采购单号, sqlTrans);
// break;
//}
ItemBuyCapDtsRule capRule = new ItemBuyCapDtsRule();
capRule.RSaveBuyCap(entity, sqlTrans);//保存资金计划明细
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 修改
/// </summary>
public override void EntityUpdate()
{
ItemBuyFormRule rule = new ItemBuyFormRule();
ItemBuyForm entity = EntityGet();
ItemBuyFormDts[] entitydts = EntityDtsGet();
decimal totalqty = 0;
decimal totalAmount = 0;
for (int i = 0; i < entitydts.Length; i++)
{
totalqty += SysConvert.ToDecimal(entitydts[i].Qty);
totalAmount += SysConvert.ToDecimal(entitydts[i].Amount);
}
entity.TotalQty = totalqty;
entity.TotalAmount = totalAmount;
entity.SubmitFlag = this.HTSubmitFlagUpdateGet();
rule.RUpdate(entity, entitydts);
}
private void frmItemBuyFormEdit_FormClosing(object sender, FormClosingEventArgs e)
{
try
{
if (HTDataID > 0)
{
ItemBuyForm entity = new ItemBuyForm();
entity.ID = HTDataID;
entity.SelectByID();
if (entity.SubmitFlag == 0)
{
if (DialogResult.Yes != ShowConfirmMessage(this.Text + Environment.NewLine + "没有提交单据,是否确认关闭窗体"))
{
e.Cancel = true;
}
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 保存资金明细(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RSaveBuyCap(ItemBuyForm p_BEMain, IDBTransAccess sqlTrans)
{
try
{
string sql = string.Empty;
sql = "SELECT * FROM Buy_ItemBuyCapDts WHERE MainID=" + p_BEMain.ID + " ORDER BY Seq";
DataTable dtOld = sqlTrans.Fill(sql);//找到原始的ID
sql = "SELECT * FROM Data_PayMethodDts WHERE MainID=" + SysConvert.ToInt32(p_BEMain.PayMethodFlag) + " ORDER BY Seq";
DataTable dtPayMethodDts = sqlTrans.Fill(sql);//付款方式明细
sql = "SELECT ItemCode,SUM(Amount) Amount FROM Buy_ItemBuyFormDts WHERE MainID=" + p_BEMain.ID + " GROUP BY ItemCode";
DataTable dtBuyDts = sqlTrans.Fill(sql);//采购单品种明细
//根据不同品种生成独立的付款明细
ItemBuyCapDts[] entityDts = new ItemBuyCapDts[dtPayMethodDts.Rows.Count * dtBuyDts.Rows.Count];//初始化资金明细实体数组
int ci = 0;
for (int i = 0; i < dtPayMethodDts.Rows.Count; i++)
{
for (int m = 0; m < dtBuyDts.Rows.Count; m++)//多个品种生成独立的资金计划
{
entityDts[ci] = new ItemBuyCapDts();
if (dtOld.Rows.Count > ci)
{
entityDts[ci].ID = SysConvert.ToInt32(dtOld.Rows[ci]["ID"]);
}
entityDts[ci].MainID = p_BEMain.ID;
entityDts[ci].Seq = ci + 1;
entityDts[ci].CapName = dtPayMethodDts.Rows[i]["Name"].ToString();//名称
entityDts[ci].PayStepTypeID = SysConvert.ToInt32(dtPayMethodDts.Rows[i]["PayStepTypeID"]);
entityDts[ci].PayPer = SysConvert.ToDecimal(dtPayMethodDts.Rows[i]["PayPer"]);
switch (SysConvert.ToInt32(dtPayMethodDts.Rows[i]["PayDateTypeInt"]))//根据付款判断日期类型类型
{
case (int)EnumPayDateType.依据合同签署日:
entityDts[ci].PayLimitDate = p_BEMain.FormDate.AddDays(SysConvert.ToInt32(dtPayMethodDts.Rows[i]["DelayDayNum"])).Date; //合同日延后多少天
break;
case (int)EnumPayDateType.依据发货日: //备注下发货日；读取默认交期；后续发货后回填实际日期
entityDts[ci].Remark = "根据发货日";
entityDts[ci].PayLimitDate = p_BEMain.ReqDate.AddDays(SysConvert.ToInt32(dtPayMethodDts.Rows[i]["DelayDayNum"])).Date;
break;
}
entityDts[ci].ItemCode = dtBuyDts.Rows[m]["ItemCode"].ToString();
entityDts[ci].PayAmount = SysConvert.ToDecimal(dtBuyDts.Rows[m]["Amount"]) * entityDts[ci].PayPer;//付款金额
ci++;
}
}
this.RSave(p_BEMain, entityDts, sqlTrans);//保存明细
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 检查将要操作的数据是否符合业务规则
/// </summary>
/// <param name="p_BE"></param>
private void CheckCorrect(BaseEntity p_BE)
{
ItemBuyForm entity = (ItemBuyForm)p_BE;
}
/// <summary>
/// 审核
/// </summary>
/// <param name="p_FormID">单据ID</param>
/// <param name="p_Type">0/1/2/3:弃审/审核</param>
public void RSubmit(int p_FormID, int p_Type, IDBTransAccess sqlTrans)
{
try
{
int p_TempType = p_Type;//处理状态
string sql = string.Empty;
ItemBuyForm entity = new ItemBuyForm(sqlTrans);
entity.ID = p_FormID;
entity.SelectByID();
if (entity.SubmitFlag == p_Type)//如果相同异常
{
throw new Exception("单据状态重复设置，请关闭程序重新打开操作");
}
if (p_Type == (int)ConfirmFlag.未提交) //撤销提交验证
{
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5609))) //采购单有仓库单据不允许修改
{
bool allowOPFlag = true;
string refuseMessage = string.Empty;
DataTable dtSOFlow;
if (allowOPFlag)
{
//仓库流程单据
sql = "SELECT TOP 1 ID,FormNo FROM UV1_WH_IOFormDts WHERE DtsSO=" + SysString.ToDBString(entity.FormNo);
dtSOFlow = SysUtils.Fill(sql);
if (dtSOFlow.Rows.Count != 0)
{
allowOPFlag = false;
refuseMessage = "此单已有仓库单据(单号):" + dtSOFlow.Rows[0]["FormNo"].ToString() + "，不允许撤销";
}
}
if (!allowOPFlag)//不允许操作
{
throw new Exception(refuseMessage);
}
}
}
sql = "UPDATE Buy_ItemBuyForm SET SubmitFlag=" + SysString.ToDBString(p_Type);
//if (p_Type == (int)ConfirmFlag.审核通过 || p_Type == (int)ConfirmFlag.审核拒绝)
//{
//sql += ",SubmitOPID=" + SysString.ToDBString(ParamConfig.LoginName) + ",SubmitTime=" + SysString.ToDBString(DateTime.Now);
//}
sql += " WHERE ID=" + p_FormID.ToString();//更新单据主表审核状态
sqlTrans.ExecuteNonQuery(sql);
int tempSaleProcedureID = 0;
switch (entity.FormAID)//1/2/3/4/5：成品，坯布，纱线，色坯，辅料
{
case 1:
tempSaleProcedureID = (int)EnumSaleProcedure.成品采购单;
break;
case 2:
tempSaleProcedureID = (int)EnumSaleProcedure.坯布采购单;
break;
case 3:
tempSaleProcedureID = (int)EnumSaleProcedure.纱线采购单;
break;
case 4:
tempSaleProcedureID = (int)EnumSaleProcedure.坯布采购单;
break;
case 5: //辅料
tempSaleProcedureID = (int)EnumSaleProcedure.辅料采购单;
break;
}
if (p_Type == (int)YesOrNo.Yes)
{
if (tempSaleProcedureID != (int)EnumSaleProcedure.坯布采购单)
{
sql = "SELECT DtsSO,ItemCode,ColorNum,ColorName FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID;
DataTable dtDts = sqlTrans.Fill(sql);
SaleOrderRule salerule = new SaleOrderRule();
foreach (DataRow dr in dtDts.Rows)
{
salerule.RUpdateStep(dr["DtsSO"].ToString(), dr["ItemCode"].ToString(), dr["ColorNum"].ToString(), dr["ColorName"].ToString(), tempSaleProcedureID, 0, 0, 0, p_Type, true, sqlTrans);
}
}
else //坯布采购加载订单时候 将订单里的 ItemCode 加载到 CPItemCode
{
sql = "SELECT DtsSO,CPItemCode,ColorNum,ColorName FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID;
DataTable dtDts = sqlTrans.Fill(sql);
SaleOrderRule salerule = new SaleOrderRule();
foreach (DataRow dr in dtDts.Rows)
{
salerule.RUpdateStep(dr["DtsSO"].ToString(), dr["CPItemCode"].ToString(), dr["ColorNum"].ToString(), dr["ColorName"].ToString(), tempSaleProcedureID, 0, 0, 0, p_Type, true, sqlTrans);
}
}
}
//#region 回填采购完成数
//if (p_Type == (int)YesOrNo.Yes)//提交
//{
// if (entity.MLType == (int)EnumMLType.纱线 || entity.MLType == (int)EnumMLType.白坯)
// {
// decimal TotalQty = 0m;
// sql = "SELECT SUM(Qty) Qty FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID;
// DataTable dtDts = sqlTrans.Fill(sql);
// if (dtDts.Rows.Count != 0)
// {
// TotalQty = SysConvert.ToDecimal(dtDts.Rows[0]["Qty"]);
// }
// sql = "SELECT ID FROM Sale_SaleOrderDts WHERE MainID=(SELECT ID FROM Sale_SaleOrder WHERE FormNo=" + SysString.ToDBString(entity.OrderFormNo) + ")";
// DataTable dtorder = sqlTrans.Fill(sql);//寻找原始订单
// if (dtorder.Rows.Count != 0)
// {
// while (TotalQty > 0m)//开始回填
// {
// for (int i = 0; i < dtorder.Rows.Count;i++ )
// {
// SaleOrderDts orderentity = new SaleOrderDts(sqlTrans);
// orderentity.ID = SysConvert.ToInt32(dtorder.Rows[i]["ID"]);
// bool findR=orderentity.SelectByID();
// if (i == dtorder.Rows.Count - 1)
// {
// switch (entity.MLType)
// {
// case (int)EnumMLType.纱线:
// orderentity.PSCGQty += TotalQty;
// TotalQty = 0;
// break;
// case (int)EnumMLType.白坯:
// orderentity.PBCGQty += TotalQty;
// TotalQty = 0;
// break;
// default:
// break;
// }
// }
// else
// {
// // decimal HTQty = DifQty <= TotalQty ? DifQty : TotalQty;
// switch (entity.MLType)
// {
// case (int)EnumMLType.纱线:
// decimal DifPSQty = orderentity.Qty - orderentity.PSCGQty;
// if (TotalQty <= DifPSQty)
// {
// orderentity.PSCGQty += TotalQty;
// TotalQty = 0;
// break;
// }
// else
// {
// if (DifPSQty > 0)
// {
// orderentity.PSCGQty += DifPSQty;
// TotalQty -= DifPSQty;
// break;
// }
// }
// break;
// case (int)EnumMLType.白坯:
// decimal DifPBQty = orderentity.Qty - orderentity.PBCGQty;
// if (TotalQty <= DifPBQty)
// {
// orderentity.PBCGQty += TotalQty;
// TotalQty = 0;
// break;
// }
// else
// {
// if (DifPBQty > 0)
// {
// orderentity.PBCGQty += DifPBQty;
// TotalQty -= DifPBQty;
// break;
// }
// }
// break;
// default:
// break;
// }
// }
// if (findR)
// {
// SaleOrderDtsRule rule = new SaleOrderDtsRule();
// rule.RUpdate(orderentity, sqlTrans);
// }
// } //For循环结尾
// } //While结尾
// }
// else
// {
// throw new Exception("数据出现异常未找到原始订单");
// }
// }
// if (entity.MLType == (int)EnumMLType.成品)
// {
// sql = "SELECT ItemCode,ColorNum,ColorName,Qty FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID;
// DataTable dtDts1 = sqlTrans.Fill(sql);
// foreach(DataRow dr in dtDts1.Rows)
// {
// sql = "SELECT DtsID FROM UV1_Sale_SaleOrderDts WHERE FormNo=" + SysString.ToDBString(entity.OrderFormNo);
// sql += " AND ItemCode=" + SysString.ToDBString(dr["ItemCode"].ToString());
// sql += " AND ColorNum=" + SysString.ToDBString(dr["ColorNum"].ToString());
// sql += " AND ColorName=" + SysString.ToDBString(dr["ColorName"].ToString());
// DataTable dtorder = sqlTrans.Fill(sql);//寻找原始订单
// if (dtorder.Rows.Count == 1)
// {
// SaleOrderDts orderentity = new SaleOrderDts(sqlTrans);
// orderentity.ID = SysConvert.ToInt32(dtorder.Rows[0]["DtsID"]);
// bool findR=orderentity.SelectByID();
// orderentity.CPCGQty += SysConvert.ToDecimal(dr["Qty"]);
// if (findR)
// {
// SaleOrderDtsRule rule = new SaleOrderDtsRule();
// rule.RUpdate(orderentity, sqlTrans);
// }
// }
// else
// {
// throw new Exception("数据出现异常未找到原始订单 订单号："+entity.FormNo);
// }
// }
// }
//}
//else //撤销提交回填数量
//{
// if (entity.MLType == (int)EnumMLType.纱线 || entity.MLType == (int)EnumMLType.白坯)
// {
// decimal TotalQty = 0m;
// sql = "SELECT SUM(Qty) Qty FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID;
// DataTable dtDts = sqlTrans.Fill(sql);
// if (dtDts.Rows.Count != 0)
// {
// TotalQty = SysConvert.ToDecimal(dtDts.Rows[0]["Qty"]);
// }
// sql = "SELECT ID FROM Sale_SaleOrderDts WHERE MainID=(SELECT ID FROM Sale_SaleOrder WHERE FormNo=" + SysString.ToDBString(entity.OrderFormNo) + ")";
// DataTable dtorder = sqlTrans.Fill(sql);//寻找原始订单
// if (dtorder.Rows.Count != 0)
// {
// while (TotalQty > 0m)//开始回填
// {
// for (int i = 0; i < dtorder.Rows.Count; i++)
// {
// SaleOrderDts orderentity = new SaleOrderDts(sqlTrans);
// orderentity.ID = SysConvert.ToInt32(dtorder.Rows[i]["ID"]);
// bool findR=orderentity.SelectByID();
// if (i == dtorder.Rows.Count - 1)
// {
// switch (entity.MLType)
// {
// case (int)EnumMLType.纱线:
// orderentity.PSCGQty -= TotalQty;
// //if (orderentity.PSCGQty < 0)
// //{
// // orderentity.PSCGQty = 0;
// //}
// TotalQty = 0;
// break;
// case (int)EnumMLType.白坯:
// orderentity.PBCGQty -= TotalQty;
// //if (orderentity.PBCGQty < 0)
// //{
// // orderentity.PBCGQty = 0;
// //}
// TotalQty = 0;
// break;
// default:
// break;
// }
// }
// else
// {
// switch (entity.MLType)
// {
// case (int)EnumMLType.纱线:
// // decimal DifPSQty = orderentity.Qty - orderentity.PSCGQty;
// if (TotalQty <= orderentity.PSCGQty)
// {
// orderentity.PSCGQty -= TotalQty;
// TotalQty = 0;
// break;
// }
// else
// {
// if (orderentity.PSCGQty > 0)
// {
// TotalQty -= orderentity.PSCGQty;
// orderentity.PSCGQty =0;
// break;
// }
// }
// break;
// case (int)EnumMLType.白坯:
// //decimal DifPBQty = orderentity.Qty - orderentity.PBCGQty;
// if (TotalQty <= orderentity.PBCGQty)
// {
// orderentity.PBCGQty -= TotalQty;
// TotalQty = 0;
// break;
// }
// else
// {
// if (orderentity.PBCGQty > 0)
// {
// TotalQty -= orderentity.PBCGQty;
// orderentity.PBCGQty= 0;
// break;
// }
// }
// break;
// default:
// break;
// }
// }
// if (findR)
// {
// SaleOrderDtsRule rule = new SaleOrderDtsRule();
// rule.RUpdate(orderentity, sqlTrans);
// }
// } //For循环结尾
// } //While结尾
// }
// else
// {
// throw new Exception("数据出现异常未找到原始订单");
// }
// }
// if (entity.MLType == (int)EnumMLType.成品)
// {
// sql = "SELECT ItemCode,ColorNum,ColorName,Qty FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID;
// DataTable dtDts1 = sqlTrans.Fill(sql);
// foreach (DataRow dr in dtDts1.Rows)
// {
// sql = "SELECT DtsID FROM UV1_Sale_SaleOrderDts WHERE FormNo=" + SysString.ToDBString(entity.OrderFormNo);
// sql += " AND ItemCode=" + SysString.ToDBString(dr["ItemCode"].ToString());
// sql += " AND ColorNum=" + SysString.ToDBString(dr["ColorNum"].ToString());
// sql += " AND ColorName=" + SysString.ToDBString(dr["ColorName"].ToString());
// DataTable dtorder = sqlTrans.Fill(sql);//寻找原始订单
// if (dtorder.Rows.Count == 1)
// {
// SaleOrderDts orderentity = new SaleOrderDts(sqlTrans);
// orderentity.ID = SysConvert.ToInt32(dtorder.Rows[0]["DtsID"]);
// bool findR= orderentity.SelectByID();
// orderentity.CPCGQty -= SysConvert.ToDecimal(dr["Qty"]);
// if (findR)
// {
// SaleOrderDtsRule rule = new SaleOrderDtsRule();
// rule.RUpdate(orderentity, sqlTrans);
// }
// }
// else
// {
// throw new Exception("数据出现异常未找到原始订单 订单号：" + entity.FormNo);
// }
// }
// }
//}
//#endregion
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int AddNew(BaseEntity p_Entity)
{
try
{
ItemBuyForm MasterEntity = (ItemBuyForm)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//新增主表数据
StringBuilder MasterField = new StringBuilder();
StringBuilder MasterValue = new StringBuilder();
MasterField.Append("INSERT INTO Buy_ItemBuyForm(");
MasterValue.Append(" VALUES(");
MasterField.Append("ID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ID) + ",");
MasterField.Append("FormNo" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.FormNo) + ",");
MasterField.Append("OrderCode" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.OrderCode) + ",");
MasterField.Append("CustomerStyleNo" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.CustomerStyleNo) + ",");
MasterField.Append("MakeOPID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MakeOPID) + ",");
MasterField.Append("MakeOPName" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MakeOPName) + ",");
MasterField.Append("MakeDate" + ",");
if (MasterEntity.MakeDate != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.MakeDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("CheckOPID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.CheckOPID) + ",");
MasterField.Append("CheckDate" + ",");
if (MasterEntity.CheckDate != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.CheckDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("SubmitFlag" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.SubmitFlag) + ",");
MasterField.Append("DelFlag" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.DelFlag) + ",");
MasterField.Append("ShopID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ShopID) + ",");
MasterField.Append("VendorID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.VendorID) + ",");
MasterField.Append("FormDate" + ",");
if (MasterEntity.FormDate != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.FormDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("ReqDate" + ",");
if (MasterEntity.ReqDate != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.ReqDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("OrderFormNo" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.OrderFormNo) + ",");
MasterField.Append("TotalQty" + ",");
if (MasterEntity.TotalQty != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.TotalQty) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("TotalAmount" + ",");
if (MasterEntity.TotalAmount != 0)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.TotalAmount) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("PayMethodID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.PayMethodID) + ",");
MasterField.Append("Remark" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Remark) + ",");
MasterField.Append("OrderDate" + ",");
if (MasterEntity.OrderDate != SystemConfiguration.DateTimeDefaultValue)
{
MasterValue.Append(SysString.ToDBString(MasterEntity.OrderDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
MasterValue.Append("null,");
}
MasterField.Append("ContractDesc" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ContractDesc) + ",");
MasterField.Append("PayMethodFlag" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.PayMethodFlag) + ",");
MasterField.Append("StatusFlag" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.StatusFlag) + ",");
MasterField.Append("StatusName" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.StatusName) + ",");
MasterField.Append("MLType" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.MLType) + ",");
MasterField.Append("FormAID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.FormAID) + ",");
MasterField.Append("FKFlag" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.FKFlag) + ",");
MasterField.Append("SaleOPID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.SaleOPID) + ",");
MasterField.Append("CGOPID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.CGOPID) + ",");
MasterField.Append("BuyTypeID" + ")");
MasterValue.Append(SysString.ToDBString(MasterEntity.BuyTypeID) + ")");
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBInsert), E);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Update(BaseEntity p_Entity)
{
try
{
ItemBuyForm MasterEntity = (ItemBuyForm)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//更新主表数据
StringBuilder UpdateBuilder = new StringBuilder();
UpdateBuilder.Append("UPDATE Buy_ItemBuyForm SET ");
UpdateBuilder.Append(" ID=" + SysString.ToDBString(MasterEntity.ID) + ",");
UpdateBuilder.Append(" FormNo=" + SysString.ToDBString(MasterEntity.FormNo) + ",");
UpdateBuilder.Append(" OrderCode=" + SysString.ToDBString(MasterEntity.OrderCode) + ",");
UpdateBuilder.Append(" CustomerStyleNo=" + SysString.ToDBString(MasterEntity.CustomerStyleNo) + ",");
UpdateBuilder.Append(" MakeOPID=" + SysString.ToDBString(MasterEntity.MakeOPID) + ",");
UpdateBuilder.Append(" MakeOPName=" + SysString.ToDBString(MasterEntity.MakeOPName) + ",");
if (MasterEntity.MakeDate != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" MakeDate=" + SysString.ToDBString(MasterEntity.MakeDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" MakeDate=null,");
}
UpdateBuilder.Append(" CheckOPID=" + SysString.ToDBString(MasterEntity.CheckOPID) + ",");
if (MasterEntity.CheckDate != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" CheckDate=" + SysString.ToDBString(MasterEntity.CheckDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" CheckDate=null,");
}
UpdateBuilder.Append(" SubmitFlag=" + SysString.ToDBString(MasterEntity.SubmitFlag) + ",");
UpdateBuilder.Append(" DelFlag=" + SysString.ToDBString(MasterEntity.DelFlag) + ",");
UpdateBuilder.Append(" ShopID=" + SysString.ToDBString(MasterEntity.ShopID) + ",");
UpdateBuilder.Append(" VendorID=" + SysString.ToDBString(MasterEntity.VendorID) + ",");
if (MasterEntity.FormDate != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" FormDate=" + SysString.ToDBString(MasterEntity.FormDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" FormDate=null,");
}
if (MasterEntity.ReqDate != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" ReqDate=" + SysString.ToDBString(MasterEntity.ReqDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" ReqDate=null,");
}
UpdateBuilder.Append(" OrderFormNo=" + SysString.ToDBString(MasterEntity.OrderFormNo) + ",");
if (MasterEntity.TotalQty != 0)
{
UpdateBuilder.Append(" TotalQty=" + SysString.ToDBString(MasterEntity.TotalQty) + ",");
}
else
{
UpdateBuilder.Append(" TotalQty=null,");
}
if (MasterEntity.TotalAmount != 0)
{
UpdateBuilder.Append(" TotalAmount=" + SysString.ToDBString(MasterEntity.TotalAmount) + ",");
}
else
{
UpdateBuilder.Append(" TotalAmount=null,");
}
UpdateBuilder.Append(" PayMethodID=" + SysString.ToDBString(MasterEntity.PayMethodID) + ",");
UpdateBuilder.Append(" Remark=" + SysString.ToDBString(MasterEntity.Remark) + ",");
if (MasterEntity.OrderDate != SystemConfiguration.DateTimeDefaultValue)
{
UpdateBuilder.Append(" OrderDate=" + SysString.ToDBString(MasterEntity.OrderDate.ToString("yyyy-MM-dd HH:mm:ss")) + ",");
}
else
{
UpdateBuilder.Append(" OrderDate=null,");
}
UpdateBuilder.Append(" ContractDesc=" + SysString.ToDBString(MasterEntity.ContractDesc) + ",");
UpdateBuilder.Append(" PayMethodFlag=" + SysString.ToDBString(MasterEntity.PayMethodFlag) + ",");
UpdateBuilder.Append(" StatusFlag=" + SysString.ToDBString(MasterEntity.StatusFlag) + ",");
UpdateBuilder.Append(" StatusName=" + SysString.ToDBString(MasterEntity.StatusName) + ",");
UpdateBuilder.Append(" MLType=" + SysString.ToDBString(MasterEntity.MLType) + ",");
UpdateBuilder.Append(" FormAID=" + SysString.ToDBString(MasterEntity.FormAID) + ",");
UpdateBuilder.Append(" FKFlag=" + SysString.ToDBString(MasterEntity.FKFlag) + ",");
UpdateBuilder.Append(" SaleOPID=" + SysString.ToDBString(MasterEntity.SaleOPID) + ",");
UpdateBuilder.Append(" CGOPID=" + SysString.ToDBString(MasterEntity.CGOPID) + ",");
UpdateBuilder.Append(" BuyTypeID=" + SysString.ToDBString(MasterEntity.BuyTypeID));
UpdateBuilder.Append(" WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID));
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(UpdateBuilder.ToString());
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(UpdateBuilder.ToString());
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBUpdate), E);
}
}
