/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
SaleOrderRule rule = new SaleOrderRule();
DataTable dt = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("FormStatusName", "'' FormStatusName").Replace("ReceiveAmount", "0.0 ReceiveAmount"));
SaleOrderStatusProc.ProcColorStatusName(dt);
ProcDataSourceQty(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>
/// 设置状态
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void btnSaveHandleStatus_Click(object sender, EventArgs e)
{
try
{
if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.权限0))
{
this.ShowMessage("你没有此操作权限");
return;
}
this.BaseFocusLabel.Focus();
for (int i = 0; i < gridView1.RowCount; i++)
{
int DtsID = SysConvert.ToInt32(gridView1.GetRowCellValue(i, "DtsID"));
string HandleStatus = SysConvert.ToString(gridView1.GetRowCellValue(i, "HandleStatus"));
DateTime HandleStatusDate = SysConvert.ToDateTime(gridView1.GetRowCellValue(i, "HandleStatusDate"));
string sql = "Update WO_FabricProcessDts set HandleStatus=" + SysString.ToDBString(HandleStatus);
if (HandleStatusDate != SystemConfiguration.DateTimeDefaultValue)
{
sql += " , HandleStatusDate=" + SysString.ToDBString(HandleStatusDate);
}
sql += " where ID=" + DtsID;
SysUtils.ExecuteNonQuery(sql);
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
Design entity = (Design)p_BE;
DesignCtl control = new DesignCtl(sqlTrans);
//entity.ID=(int)EntityIDTable.GetID((long)SysEntity.WO_Design,sqlTrans);
string sql = string.Empty;
sql = " SELECT Code FROM WO_Design WHERE 1=1";
sql += " AND Code=" + SysString.ToDBString(entity.Code);
DataTable dt = new DataTable();
dt = SysUtils.Fill(sql);
if (dt.Rows.Count != 0)
{
throw new Exception("该单号已存在，请重新输入！");
}
else
{
control.AddNew(entity);
//sql = " UPDATE Enum_FormNoControl SET CurSort=CurSort+1 WHERE ID=" + (int)FormNoControlEnum.生产工艺单号;//更新CurSort
SysUtils.ExecuteNonQuery(sql);
}
}
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, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
OperateQuote entity = (OperateQuote)p_BE;
OperateQuoteCtl control = new OperateQuoteCtl(sqlTrans);
string sql = "SELECT Code FROM Sale_OperateQuote WHERE Code=" + SysString.ToDBString(entity.Code);
if (sqlTrans.Fill(sql).Rows.Count != 0)
{
throw new Exception("报价单号已经存在，请重新生成");
}
//entity.ID=(int)EntityIDTable.GetID((long)SysEntity.Sale_OperateQuote,sqlTrans);
control.AddNew(entity);
//sql = " UPDATE Enum_FormNoControl SET CurSort=CurSort+1 WHERE ID=" + (int)FormNoControlEnum.客户报价单号;//更新CurSort
SysUtils.ExecuteNonQuery(sql);
}
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, IDBTransAccess sqlTrans)
{
try
{
this.CheckCorrect(p_BE);
CWDuiZhang entity = (CWDuiZhang)p_BE;
CWDuiZhangCtl control = new CWDuiZhangCtl(sqlTrans);
string sql = "SELECT Code FROM CaiWu_CWDuiZhang WHERE Code=" + SysString.ToDBString(entity.Code) + " AND DZTypeID=" + SysString.ToDBString(entity.DZTypeID);
if (sqlTrans.Fill(sql).Rows.Count != 0)
{
throw new Exception("该单号已经存在，请双击重新生成");
}
//entity.ID = (int)EntityIDTable.GetID((long)SysEntity.CaiWu_CWDuiZhang, sqlTrans);
control.AddNew(entity);
if (entity.DZTypeID == 1)
{
//sql = " UPDATE Enum_FormNoControl SET CurSort=CurSort+1 WHERE ID=" + (int)FormNoControlEnum.进项对账单号;//更新CurSort
}
else if (entity.DZTypeID == 2)
{
//sql = " UPDATE Enum_FormNoControl SET CurSort=CurSort+1 WHERE ID=" + (int)FormNoControlEnum.销项对账单号;//更新CurSort
}
SysUtils.ExecuteNonQuery(sql);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
///保存换算
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void btnSaveColor_Click(object sender, EventArgs e)
{
try
{
this.BaseFocusLabel.Focus();
for (int i = 0; i < gridView1.RowCount; i++)
{
int p_ID = SysConvert.ToInt32(gridView1.GetRowCellValue(i, "PackID"));
string sql = "Update WH_IOFormDtsPack set GrossQty=" + SysString.ToDBString(SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "GrossQty"))); //毛米长
sql += ",GrossWeight=" + SysString.ToDBString(SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "GrossWeight"))); //毛重
sql += ",NetWeight=" + SysString.ToDBString(SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "NetWeight"))); //净重
// sql += ",Description=" + SysString.ToDBString(SysConvert.ToString(gridView1.GetRowCellValue(i, "Description")));//描述
// sql += ",Destination=" + SysString.ToDBString(SysConvert.ToString(gridView1.GetRowCellValue(i, "Destination")));//目的地
sql += " where ID=" + p_ID;
SysUtils.ExecuteNonQuery(sql);
}
this.ShowInfoMessage("保存成功");
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 撤单操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCancelCancelOrder_Click(object sender, EventArgs e)
{
try
{
if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.权限3))
{
this.ShowMessage("没有此权限，请联系管理员");
return;
}
if (SysConvert.ToInt32(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "CancelFlag")) == 0)
{
this.ShowMessage("此订单未撤单，不能取消！");
return;
}
string FormNo = SysConvert.ToString(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "FormNo"));
string sql = "UPDATE Sale_SaleOrder SET CancelFlag =0";
sql += ",CancelReason =''";
sql += " WHERE FormNo=" + SysString.ToDBString(FormNo);
SysUtils.ExecuteNonQuery(sql);
btnQuery_Click(null, null);
ProcessGrid.GridViewFocus(gridView1, new string[1] {
"FormNo"
}, new string[1] {
FormNo
});
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 处理库存件数
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnProcData_Click(object sender, EventArgs e)
{
try
{
string sql = string.Empty;
DataTable p_dt = (DataTable)gridView1.GridControl.DataSource;
foreach (DataRow dr in p_dt.Rows)
{
sql = "SELECT ID FROM WH_PackBox WHERE 1=1";
sql += " AND WHID=" + SysString.ToDBString(SysConvert.ToString(dr["WHID"]));
sql += " AND ItemCode=" + SysString.ToDBString(SysConvert.ToString(dr["ItemCode"]));
sql += " AND ColorNum=" + SysString.ToDBString(SysConvert.ToString(dr["ColorNum"]));
sql += " AND ColorName=" + SysString.ToDBString(SysConvert.ToString(dr["ColorName"]));
sql += " AND SectionID=" + SysString.ToDBString(SysConvert.ToString(dr["SectionID"]));
sql += " AND BoxStatusID=" + SysString.ToDBString((int)EnumBoxStatus.入库);
sql += " AND ISNULL(Qty,0)>0";
int pieceQty = SysUtils.Fill(sql).Rows.Count;
sql = "UPDATE WH_Storge SET PieceQty=" + pieceQty.ToString() + " WHERE ID=" + dr["ID"].ToString();
SysUtils.ExecuteNonQuery(sql);
}
this.ShowInfoMessage("处理完成");
this.BindGrid();
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 修改采购合同站别
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLoad_Click(object sender, EventArgs e)
{
try
{
if (SysConvert.ToString(drpOrderStatus.EditValue) == "")
{
return;
}
if (chkOrderStatusFlag.Checked)
{
string sql = "UPDATE Buy_ItemBuyForm SET StatusFlag=1";
sql += ",StatusName=" + SysString.ToDBString(SysConvert.ToString(drpOrderStatus.EditValue));
sql += " WHERE ID=" + SysString.ToDBString(m_ID);
SysUtils.ExecuteNonQuery(sql);
}
else
{
string sql = "UPDATE Buy_ItemBuyForm SET StatusFlag=0";
sql += ",StatusName=''";
sql += " WHERE ID=" + SysString.ToDBString(m_ID);
SysUtils.ExecuteNonQuery(sql);
}
this.Close();
}
catch (Exception E)
{
}
}
/// <summary>
/// 修改销售合同站别
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLoad_Click(object sender, EventArgs e)
{
try
{
if (SysConvert.ToString(drpOPID1.EditValue) == "")
{
return;
}
string sql = "UPDATE WH_IOForm SET RecordOPID1=" + SysString.ToDBString(SysConvert.ToString(drpOPID1.EditValue));
sql += ", RecordOPID2=" + SysString.ToDBString(SysConvert.ToString(drpOPID2.EditValue));
sql += " WHERE ID=" + SysString.ToDBString(m_ID);
SysUtils.ExecuteNonQuery(sql);
this.ShowInfoMessage("设置成功！");
this.Close();
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 审核拒绝
/// </summary>
/// <param name="p_TableName">表名</param>
/// <param name="p_IDField">ID字段名</param>
/// <param name="p_IDValue">ID值</param>
private static void HTAuditCancel(string p_TableName, string p_IDField, string p_IDValue)
{
int status = (int)ConfirmFlag.审核拒绝;//状态修改为审核拒绝
string sql = "UPDATE " + p_TableName + " SET SubmitFlag=" + SysString.ToDBString(status) + " WHERE " + p_IDField + "=" + SysString.ToDBString(p_IDValue);
SysUtils.ExecuteNonQuery(sql);
}
public void btnSaveStatus_Click(object sender, EventArgs e)
{
try
{
if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.权限0))
{
this.ShowMessage("你没有此操作权限");
return;
}
this.BaseFocusLabel.Focus();
for (int i = 0; i < gridView1.RowCount; i++)
{
int ID = SysConvert.ToInt32(gridView1.GetRowCellValue(i, "ID"));
string PostFee = SysConvert.ToString(gridView1.GetRowCellValue(i, "PostFee"));
string sql = "Update UV1_Attn_GoodsPost set PostFee=" + SysString.ToDBString(PostFee);
sql += " where ID=" + ID;
SysUtils.ExecuteNonQuery(sql);
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 勾选完成标志
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void chkFinishedFlag_CheckedChanged(object sender, EventArgs e)
{
try
{
if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.权限0))
{
this.ShowMessage("你没有此操作权限");
return;
}
this.BaseFocusLabel.Focus();
if (SysConvert.ToInt32(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "SubmitFlag")) == 0)
{
this.ShowMessage("此单据未提交,不能勾选完成！");
return;
}
string sql = "Update Sale_SampleSaleDts set FinishedFlag =" + SysConvert.ToInt32(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "FinishedFlag"));
sql += " Where ID = " + SysConvert.ToInt32(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "DtsID"));
SysUtils.ExecuteNonQuery(sql);
MessageBox.Show("修改成功！");
BindGrid();
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void btnPicDelete_Click(object sender, EventArgs e)
{
try
{
if (HTDataID == 0)
{
this.ShowMessage("请先保存客户主数据");
return;
}
if (SysConvert.ToInt32(drpPicNum.EditValue) == 0)
{
this.ShowMessage("请选择删除的图片");
drpPicNum.Focus();
return;
}
string sql = "DELETE Data_VendorFile WHERE MainID=" + HTDataID;
sql += " AND Seq=" + SysConvert.ToInt32(drpPicNum.EditValue);
SysUtils.ExecuteNonQuery(sql);
BindPic();
this.ShowInfoMessage("图片删除成功");
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
public void btnSaveStatus_Click(object sender, EventArgs e)
{
try
{
this.BaseFocusLabel.Focus();
int DtsID = 0;
string Status = string.Empty;
string sql = string.Empty;
int Num = 0;
SampleDtsRule rule = new SampleDtsRule();
SampleDts entityDts = new SampleDts();
for (int i = 0; i < gridView1.RowCount; i++)
{
DtsID = SysConvert.ToInt32(gridView1.GetRowCellValue(i, "DtsID"));
Status = SysConvert.ToString(gridView1.GetRowCellValue(i, "EventStatus"));
sql = "Update Dev_SampleDts set EventStatus=" + SysString.ToDBString(Status);
if (entityDts.EventStatus != Status)
{
sql += " where ID=" + DtsID;
SysUtils.ExecuteNonQuery(sql);
Num++;
}
}
if (Num > 0)
{
this.ShowInfoMessage(Num.ToString() + "条状态更新成功");
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void SetCapFlag(int p_Flag)
{
string sql = "UPDATE Sale_SaleOrderDts SET CapFlag=" + p_Flag;
sql += " WHERE MainID IN (SELECT ID FROM Sale_SaleOrder WHERE FormNo=" + SysString.ToDBString(txtHTDtsHTNo.Text.Trim()) + ")";
sql += " AND ItemCode=" + SysString.ToDBString(txtHTItemCode.Text.Trim());
SysUtils.ExecuteNonQuery(sql);
}
/// <summary>
/// 修改销售合同站别
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLoad_Click(object sender, EventArgs e)
{
try
{
if (m_ID == 0 || m_DtsID == 0)
{
this.ShowMessage("单据有误，请查看");
return;
}
if (SysConvert.ToString(txtOldSinglePrice.Text.Trim()) == string.Empty)
{
this.ShowMessage("旧单价为空，请检查");
return;
}
if (SysConvert.ToString(txtNewSinglePrice.Text.Trim()) == string.Empty)
{
this.ShowMessage("新单价为空，请检查");
return;
}
if (SysConvert.ToString(txtOldSinglePrice.Text.Trim()) == SysConvert.ToString(txtNewSinglePrice.Text.Trim()))
{
this.ShowMessage("新旧单价相同，请检查");
return;
}
IOForm entity = new IOForm();
entity.ID = m_ID;
entity.SelectByID();
IOFormDts entityDts = new IOFormDts();
entityDts.ID = m_DtsID;
entityDts.SelectByID();
UpdateWHSinglePriceRule rule = new UpdateWHSinglePriceRule();
UpdateWHSinglePrice entityWH = new UpdateWHSinglePrice();
entityWH.FormNo = entity.FormNo;
entityWH.DtsID = entityDts.ID;
entityWH.ItemCode = entityDts.ItemCode;
entityWH.ColorNum = entityDts.ColorNum;
entityWH.ColorName = entityDts.ColorName;
entityWH.NewSinglePrice = SysConvert.ToDecimal(txtNewSinglePrice.Text.Trim());
entityWH.OldSinglePrice = SysConvert.ToDecimal(txtOldSinglePrice.Text.Trim());
entityWH.UpdateDate = DateTime.Now;
entityWH.UpdateOPName = FParamConfig.LoginName;
rule.RAdd(entityWH);
string sql = "UPDATE WH_IOFormDts SET SinglePrice=" + SysString.ToDBString(SysConvert.ToDecimal(txtNewSinglePrice.Text.Trim()));
sql += ",Amount=ISNULL(DYPrice,0)+ISNULL(Qty,0)*" + SysString.ToDBString(SysConvert.ToDecimal(txtNewSinglePrice.Text.Trim()));
sql += " WHERE ID=" + SysString.ToDBString(m_DtsID);
SysUtils.ExecuteNonQuery(sql);
this.ShowInfoMessage("修改成功");
this.Close();
}
catch (Exception E)
{
}
}
/// <summary>
/// 删除文件
/// </summary>
/// <returns></returns>
public static void DeleteFileByDataID(int winListID, int headtype, int subtype, int dataid)
{
if (winListID != 0 && dataid != 0)
{
string sql = "DELETE FROM Data_WinListAttachFile WHERE 1=1 ";
sql += " AND WinListID=" + SysString.ToDBString(winListID);
sql += " AND HeadType=" + SysString.ToDBString(headtype);
sql += " AND SubType=" + SysString.ToDBString(subtype);
sql += " AND HTDataID=" + SysString.ToDBString(dataid);
SysUtils.ExecuteNonQuery(sql);
}
}
/// <summary>
/// ³·µ¥
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLoad_Click(object sender, EventArgs e)
{
try
{
string sql = "UPDATE Sale_SaleOrder SET CancelFlag =1";
sql += ",CancelReason =" + SysString.ToDBString(txtCancelOrderDes.Text.Trim());
sql += " WHERE FormNo=" + SysString.ToDBString(m_OrdeFormNo);
SysUtils.ExecuteNonQuery(sql);
this.Close();
}
catch (Exception E)
{
}
}
/// <summary>
/// 修改内销订单的物流公司，物流单号
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLoad_Click(object sender, EventArgs e)
{
try
{
string sql = "UPDATE Sale_SaleOrder SET WLVendorID=" + SysString.ToDBString(SysConvert.ToString(drpWLVendorID.EditValue));
sql += ",WLFormNo=" + SysString.ToDBString(txtWLFormNo.Text.Trim());
sql += " WHERE ID=" + SysString.ToDBString(m_ID);
SysUtils.ExecuteNonQuery(sql);
this.Close();
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 取消收藏
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnToGBDetail_Click(object sender, EventArgs e)
{
try
{
this.BaseFocusLabel.Focus();
int ID = SysConvert.ToInt32(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ID"));
string sql = "UPDATE Sale_FavItemGB SET CancelFlag=1 WHERE ID=" + SysString.ToDBString(ID);
SysUtils.ExecuteNonQuery(sql);
BindGrid();
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
string sql = " Exec USP2_IOStorge " + SysString.ToDBString(FParamConfig.LoginID);
sql += "," + SysString.ToDBString(SysConvert.ToString(txtWriteDateS.DateTime.Date));
sql += "," + SysString.ToDBString(SysConvert.ToString(txtWriteDateE.DateTime.Date));
sql += "," + SysString.ToDBString(HTDataConditionStr);
//SystemConfiguration.DBTimeOut = 60;
SysUtils.ExecuteNonQuery(sql);
//sql = " Select * from WH_QWHJS where 1=1 ";
//if (this.txtQBatch.Text.Trim() != "")
//{
// sql += " AND Batch LIKE " + SysString.ToDBString("%" + this.txtQBatch.Text.Trim() + "%");
//}
//if (this.txtQVendorBatch.Text.Trim() != "")
//{
// sql += " AND VendorBatch LIKE" + SysString.ToDBString("%" + this.txtQVendorBatch.Text.Trim() + "%");
//}
//if (this.txtQColorName.Text.Trim() != "")
//{
// sql += " AND ColorName LIKE" + SysString.ToDBString("%" + this.txtQColorName.Text.Trim() + "%");
//}
//if (this.txtQColorNum.Text.Trim() != "")
//{
// sql += " AND ColorNum LIKE" + SysString.ToDBString("%" + this.txtQColorNum.Text.Trim() + "%");
//}
//if (this.txtQJarNum.Text.Trim() != "")
//{
// sql += " AND JarNum LIKE" + SysString.ToDBString("%" + this.txtQJarNum.Text.Trim() + "%");
//}
//if (txtQItemStd.Text.Trim() != string.Empty)
//{
// sql += " AND ItemStd LIKE " + SysString.ToDBString("%" + txtQItemStd.Text.Trim() + "%");
//}
//sql += " AND OPID = " + SysString.ToDBString(FParamConfig.LoginID);
int tempDBTimeOut = SystemConfiguration.DBTimeOut;
SystemConfiguration.DBTimeOut = 600;//10分钟
DataTable dt = SysUtils.Fill(sql);
SystemConfiguration.DBTimeOut = tempDBTimeOut;
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 修改挂板状态
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdate_Click_1(object sender, EventArgs e)
{
try
{
if (txtGBCode.Text.Trim() == "")
{
this.ShowMessage("请扫描挂板条码");
txtGBCode.Focus();
return;
}
if (SysConvert.ToInt32(drpGBStatusID.EditValue) == 0)
{
this.ShowMessage("请选择修改后的挂板状态");
drpGBStatusID.Focus();
return;
}
if (SysConvert.ToInt32(drpGBStatusID2.EditValue) == 0)
{
this.ShowMessage("请选择修改前的挂板状态");
drpGBStatusID2.Focus();
return;
}
if (SysConvert.ToInt32(drpGBStatusID.EditValue) == SysConvert.ToInt32(drpGBStatusID2.EditValue))
{
this.ShowMessage("修改前与修改后挂板状态相同，请重新选择修改后挂板状态");
drpGBStatusID.Focus();
return;
}
ItemGBUPHisRule rule = new ItemGBUPHisRule();
ItemGBUPHis entity = GetEntity();
rule.RAdd(entity);
string sql = "UPDATE Data_ItemGB SET GBStatusID=" + SysString.ToDBString(entity.GBStatusIDE);
sql += " WHERE GBCode=" + SysString.ToDBString(txtGBCode.Text.Trim());
SysUtils.ExecuteNonQuery(sql);
Bind();
txtGBCode.Text = "";
drpGBStatusID.EditValue = 0;
drpGBStatusID2.EditValue = 0;
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 提交
/// </summary>
/// <param name="p_TableName">表名</param>
/// <param name="p_IDField">ID字段名</param>
/// <param name="p_IDValue">ID值</param>
private void HTSubmit(string p_TableName, string p_IDField, string p_IDValue)
{
int status = -1;
if (this.AuditFlag) //需要审核
{
status = (int)ConfirmFlag.已提交; //状态修改为提交
}
else//不需要审核
{
status = (int)ConfirmFlag.审核通过;//状态修改为审核通过
}
string sql = "UPDATE " + p_TableName + " SET SubmitFlag=" + SysString.ToDBString(status) + " WHERE " + p_IDField + "=" + SysString.ToDBString(p_IDValue);
SysUtils.ExecuteNonQuery(sql);
}
/// <summary>
/// 修改销售合同站别
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLoad_Click(object sender, EventArgs e)
{
try
{
if (m_FormNo == "")
{
this.ShowMessage("出库单号为空，请检查");
return;
}
if (SysConvert.ToString(drpOldVendor.EditValue) == string.Empty)
{
this.ShowMessage("旧客户抬头没有选择，请检查");
return;
}
if (SysConvert.ToString(drpNewVendor.EditValue) == string.Empty)
{
this.ShowMessage("新客户抬头没有选择，请检查");
return;
}
if (SysConvert.ToString(drpNewVendor.EditValue) == SysConvert.ToString(drpOldVendor.EditValue))
{
this.ShowMessage("新旧客户抬头相同，请检查");
return;
}
UpdateWHVendorRule rule = new UpdateWHVendorRule();
UpdateWHVendor entity = new UpdateWHVendor();
entity.FormNo = m_FormNo;
entity.OldVendor = m_VendorID;
entity.NewVendor = SysConvert.ToString(drpNewVendor.EditValue);
entity.FormDate = DateTime.Now;
entity.UpdateOPName = FParamConfig.LoginName;
rule.RAdd(entity);
string sql = "UPDATE WH_IOForm SET VendorID=" + SysString.ToDBString(drpNewVendor.EditValue.ToString());
sql += " WHERE FormNo=" + SysString.ToDBString(m_FormNo);
SysUtils.ExecuteNonQuery(sql);
this.ShowInfoMessage("修改成功");
}
catch (Exception E)
{
}
}
private void btnDelete_Click_1(object sender, EventArgs e)
{
if (HTDataID == 0)
{
this.ShowMessage("请保存产品后删除！");
return;
}
if (MessageBox.Show("您真的要删除吗？", "删除提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes)
{
this.BaseFocusLabel.Focus();
int ID = SysConvert.ToInt32(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "DtsID"));
if (ID > 0)
{
string sql = "DELETE Data_ItemGB WHERE ID=" + SysString.ToDBString(ID);
SysUtils.ExecuteNonQuery(sql);
this.ShowInfoMessage("删除成功！");
BindGrid();
}
}
}
/// <summary>
/// 执行SQL语句
/// </summary>
/// <param name="p_Sql"></param>
/// <param name="obj"></param>
private void PicExecuteNonQuery(string p_Sql, object[,] obj)
{
switch (UCDBConnIndex)
{
case 1:
SysUtils.ExecuteNonQuery(p_Sql, obj);
break;
case 2:
SysUtilsSecond.ExecuteNonQuery(p_Sql, obj);
break;
case 3:
SysUtilsThird.ExecuteNonQuery(p_Sql, obj);
break;
case 4:
SysUtilsFourth.ExecuteNonQuery(p_Sql, obj);
break;
}
}
private void btnCancelSend_Click(object sender, EventArgs e)
{
try
{
if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.权限2))
{
this.ShowMessage("没有此权限，请联系管理员");
return;
}
string sql = "SELECT * FROM SMS_MSGMain WHERE DID=" + SysString.ToDBString(HTDataID);
sql += " AND MSGSourceID=" + SysString.ToDBString((int)EnumMSGSource.快递单);
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count == 0)
{
this.ShowMessage("信息还未发送！");
return;
}
sql = "SELECT * FROM SMS_MSGMain WHERE DID=" + SysString.ToDBString(HTDataID);
sql += " AND MSGSourceID=" + SysString.ToDBString((int)EnumMSGSource.快递单);
sql += " AND ISNULL(SendFlag,0)=1";
dt = SysUtils.Fill(sql);
if (dt.Rows.Count > 0)
{
this.ShowMessage("信息已发送给客户，取消无效！");
return;
}
sql = "DELETE SMS_MSGMain WHERE DID=" + SysString.ToDBString(HTDataID);
sql += " AND MSGSourceID=" + SysString.ToDBString((int)EnumMSGSource.快递单);
SysUtils.ExecuteNonQuery(sql);
this.ShowMessage("取消成功！");
lbSendShow.Text = "未发送";
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 修改销售合同站别
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLoad_Click(object sender, EventArgs e)
{
try
{
if (SysConvert.ToInt32(drpOrderStep.EditValue) == 0)
{
return;
}
string sql = "UPDATE Sale_SaleOrder SET OrderPreStepID=" + SysString.ToDBString(m_OrderStepID);
sql += ",OrderStepID=" + SysString.ToDBString(SysConvert.ToInt32(drpOrderStep.EditValue));
sql += " WHERE ID=" + SysString.ToDBString(m_ID);
SysUtils.ExecuteNonQuery(sql);
sql = "UPDATE Sale_SaleOrderDts SET OrderPreStepID=" + SysString.ToDBString(m_OrderStepID);
sql += ",OrderStepID=" + SysString.ToDBString(SysConvert.ToInt32(drpOrderStep.EditValue));
sql += " WHERE MainID=" + SysString.ToDBString(m_ID);
SysUtils.ExecuteNonQuery(sql);
this.Close();
}
catch (Exception E)
{
}
}
/// <summary>
///保存分色
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void btnSaveColor_Click(object sender, EventArgs e)
{
try
{
this.BaseFocusLabel.Focus();
for (int i = 0; i < gridView2.RowCount; i++)
{
int p_ID = SysConvert.ToInt32(gridView2.GetRowCellValue(i, "ID"));
string sql = "Update WH_PackBox set SplitColor=" + SysString.ToDBString(SysConvert.ToString(gridView2.GetRowCellValue(i, "SplitColor")));
sql += ",MiddleDiff=" + SysString.ToDBString(SysConvert.ToString(gridView2.GetRowCellValue(i, "MiddleDiff")));
sql += ",HeadTailDiff=" + SysString.ToDBString(SysConvert.ToString(gridView2.GetRowCellValue(i, "HeadTailDiff")));
sql += ",ReHandle=" + SysString.ToDBString(SysConvert.ToString(gridView2.GetRowCellValue(i, "ReHandle")));
sql += " where ID=" + p_ID;
SysUtils.ExecuteNonQuery(sql);
}
this.ShowInfoMessage("保存成功");
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
