/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
SaleOrderRule rule = new SaleOrderRule();
gridView1.GridControl.DataSource = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1));
gridView1.GridControl.Show();
}
/// <summary>
/// 删除
/// </summary>
public override void EntityDelete()
{
SaleOrderRule rule = new SaleOrderRule();
SaleOrder entity = EntityGet();
rule.RDelete(entity);
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
SaleOrderRule rule = new SaleOrderRule();
DataTable dt = rule.RShow2(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("FormStatusName", "'' FormStatusName").Replace("FaHuoStatusName", "'' FaHuoStatusName"));
//SaleOrderStatusProc.ProcColorStatusName(dt);
ProFaHuoStatusName(dt);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
//string sql = "SELECT COUNT( ID) FROM UV1_Sale_SaleOrderDts WHERE 1=1";
//sql += HTDataConditionStr + " GROUP BY ID";
//DataTable dtSO = SysUtils.Fill(sql);
//if (dtSO.Rows.Count > 0)
//{
// lbCount.Text = "销售合同数：" + dtSO.Rows[0][0].ToString();
//}
//else
//{
// lbCount.Text = "销售合同数：0";
//}
//if (ProductParamSet.GetIntValueByID(5418) == (int)YesOrNo.Yes)//更新回签标志
//{
// sql = "UPDATE Sale_SaleOrder SET HQFlag=1 WHERE FormNo IN (SELECT ISNULL(FileProt2,'') FROM Data_WinListAttachFile WHERE FileProt1=" + SysString.ToDBString(this.Text) + ")";
// SysUtils.ExecuteNonQuery(sql);
//}
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
SaleOrderRule rule = new SaleOrderRule();
DataTable dt = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("FormStatusName", "'' FormStatusName"));
SaleOrderStatusProc.ProcColorStatusName(dt);
ProcDataSourceQty(dt);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
string sql = "SELECT distinct ID FROM UV1_Sale_SaleOrderDts WHERE 1=1";
sql += HTDataConditionStr;
dt = SysUtils.Fill(sql);
lbCount.Text = "销售合同数：" + dt.Rows.Count.ToString();
}
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (e.Column.FieldName == "HKFlag")
{
int RowHandle = e.RowHandle;
if (SysConvert.ToString(gridView1.GetRowCellValue(e.RowHandle, "HKString")) == "不需要" || SysConvert.ToString(gridView1.GetRowCellValue(e.RowHandle, "HKString")) == "")
{
btnQuery_Click(null, null);
gridView1.FocusedRowHandle = RowHandle;
return;
}
int ID = SysConvert.ToInt32(gridView1.GetFocusedRowCellValue("ID"));
int HKFlag = SysConvert.ToInt32(gridView1.GetFocusedRowCellValue("HKFlag"));
SaleOrder entity = new SaleOrder();
entity.ID = ID;
entity.SelectByID();
entity.HKFlag = HKFlag;
entity.HKDate = DateTime.Now;
SaleOrderRule rule = new SaleOrderRule();
rule.RUpdate(entity);
btnQuery_Click(null, null);
gridView1.FocusedRowHandle = RowHandle;
}
if (e.Column.FieldName == "BGJFlag")
{
int RowHandle = e.RowHandle;
if (SysConvert.ToString(gridView1.GetRowCellValue(e.RowHandle, "BGJString")) == "不需要" || SysConvert.ToString(gridView1.GetRowCellValue(e.RowHandle, "BGJString")) == "")
{
btnQuery_Click(null, null);
gridView1.FocusedRowHandle = RowHandle;
return;
}
int ID = SysConvert.ToInt32(gridView1.GetFocusedRowCellValue("ID"));
int BGJFlag = SysConvert.ToInt32(gridView1.GetFocusedRowCellValue("BGJFlag"));
SaleOrder entity = new SaleOrder();
entity.ID = ID;
entity.SelectByID();
entity.BGJFlag = BGJFlag;
entity.BGJDate = DateTime.Now;
SaleOrderRule rule = new SaleOrderRule();
rule.RUpdate(entity);
btnQuery_Click(null, null);
gridView1.FocusedRowHandle = RowHandle;
}
}
/// <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_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;
FabricProcess entity = new FabricProcess(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(5809))) //加工单有仓库单据不允许修改
{
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 WO_FabricProcess 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.ProcessTypeID)//2：织造;1：染整;3：印花;4：其它
{
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 (p_Type == (int)ConfirmFlag.已提交)
{
sql = "SELECT DtsSO,ItemCode,ColorNum,ColorName,DtsSO,CPItemCode FROM WO_FabricProcessDts WHERE MainID=" + p_FormID;
DataTable dtDts = sqlTrans.Fill(sql);
if (tempSaleProcedureID == (int)EnumSaleProcedure.织胚加工单)//织造加工单
{
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);
}
}
else
{
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);
}
}
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
