/// <summary>
/// 加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void btnLoad_Click(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改)
{
frmLoadOrder frm = new frmLoadOrder();
frm.CheckFlag2 = 1;
frm.ShowDialog();
string str = string.Empty;
if (frm.OrderID != null && frm.OrderID.Length != 0)
{
//SetGridView1();// 防止一个采购单出现两个合同的数据
for (int i = 0; i < frm.OrderID.Length; i++)
{
if (str != string.Empty)
{
str += ",";
}
str += SysConvert.ToString(frm.OrderID[i]);
}
setItemNews2(str);
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public override void btnLoad_Click(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改)
{
frmLoadOrder frm = new frmLoadOrder();
frm.Double = true;
string sql = string.Empty;
sql += " AND DtsID NOT IN (SELECT LoadID FROM UV1_Sale_ProductionNoticeDts)";
frm.NoLoadCondition = sql;
frm.ShowDialog();
string str = string.Empty;
if (frm.OrderID != null && frm.OrderID.Length != 0)
{
for (int i = 0; i < frm.OrderID.Length; i++)
{
if (str != string.Empty)
{
str += ",";
}
str += SysConvert.ToString(frm.OrderID[i]);
}
setItemNews(str);
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 加载销售合同 加载坯布订单
/// </summary>
private void WHLoadSaleOrderFormPB()
{
if (SysConvert.ToString(drpVendorID.EditValue) == "")
{
this.ShowMessage("请选择单位");
drpVendorID.Focus();
return;
}
frmLoadOrder frm = new frmLoadOrder();
frm.VendorID = SysConvert.ToString(drpVendorID.EditValue);
string sql = string.Empty;
frm.NoLoadCondition = sql;
frm.ExtraCondition = " and FAid = 1 ";//加载坯布的订单
frm.ShowDialog();
string str = string.Empty;
if (frm.OrderID != null && frm.OrderID.Length != 0)
{
for (int i = 0; i < frm.OrderID.Length; i++)
{
if (str != string.Empty)
{
str += ",";
}
str += SysConvert.ToString(frm.OrderID[i]);
}
WHLoadSaleOrderFormSetWHPB(str);
}
}
private void txtSO_DoubleClick(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改)
{
frmLoadOrder frm = new frmLoadOrder();
string sql = string.Empty;
sql += " AND FormNo NOT IN(SELECT SO FROM Sale_SaleOrderJS WHERE 1=1 ";
sql += ")";
sql += " AND ISNULL(OrderStepID,0)=8";
sql += " AND SubmitFlag=1";
frm.NoLoadCondition = sql;
frm.ShowDialog();
string str = string.Empty;
if (frm.OrderID != null && frm.OrderID.Length != 0)
{
for (int i = 0; i < frm.OrderID.Length; i++)
{
if (str != string.Empty)
{
str += ",";
}
str += SysConvert.ToString(frm.OrderID[i]);
}
setItemNews(str);
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void btnLoad2_Click(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改)
{
if (SysConvert.ToString(drpVendorID.EditValue) == "")
{
this.ShowMessage("请选择往来单位");
drpVendorID.Focus();
return;
}
if (SysConvert.ToInt32(drpKPType.EditValue) != (int)EnumKPType.预开票)
{
this.ShowMessage("开票类型请选择预开票");
drpKPType.Focus();
return;
}
if (SysConvert.ToInt32(drpDZType.EditValue) == (int)EnumDZType.销售)
{
frmLoadOrder frm = new frmLoadOrder();
frm.CheckFlag2 = 1;
frm.VendorID = SysConvert.ToString(drpVendorID.EditValue);
frm.ShowDialog();
string str = string.Empty;
if (frm.OrderID != null && frm.OrderID.Length != 0)
{
//SetGridView1();// 防止一个采购单出现两个合同的数据
for (int i = 0; i < frm.OrderID.Length; i++)
{
if (str != string.Empty)
{
str += ",";
}
str += SysConvert.ToString(frm.OrderID[i]);
}
setItemNews2(str);
}
}
if (SysConvert.ToInt32(drpDZType.EditValue) == (int)EnumDZType.采购)
{
WHLoadItemBuyForm();
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public override void btnLoad_Click(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改)
{
frmLoadOrder frm = new frmLoadOrder();
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(702)))//染整加工单支持加载多订单
{
frm.Double = true;
}
string sql = string.Empty;
sql += " AND FormNo+ItemCode+ColorNum+ColorName NOT IN(SELECT ISNULL(OrderFormNo+ItemCode+ColorNum+ColorName,'') OrderFormNo FROM UV1_WO_FabricProcessDts";
if (saveNoLoadCheckDayNum != 0)
{
sql += " WHERE FormDate BETWEEN " + SysString.ToDBString(DateTime.Now.AddDays(0 - saveNoLoadCheckDayNum).ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(DateTime.Now.ToString("yyyy-MM-dd"));
}
sql += " and ProcessTypeID =" + (int)EnumProcessType.染纱加工单 + " )";//染整
//sql += ")";
frm.NoLoadCondition = sql;
frm.CheckFlag = 1;
frm.ShowDialog();
string str = string.Empty;
if (frm.OrderID != null && frm.OrderID.Length != 0)
{
//SetGridView1();// 防止一个采购单出现两个合同的数据
for (int i = 0; i < frm.OrderID.Length; i++)
{
if (str != string.Empty)
{
str += ",";
}
str += SysConvert.ToString(frm.OrderID[i]);
}
setItemNews(str);
gridViewRowChanged1(gridView1);
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLoadSO_Click(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改)
{
frmLoadOrder frm = new frmLoadOrder();
string sql = string.Empty;
//sql += " AND FormNo+ItemCode+ColorNum+ColorName NOT IN(SELECT ISNULL(OrderFormNo+ItemCode+ColorNum+ColorName,'') OrderFormNo FROM UV1_WO_FabricProcessDts";
sql += " AND FormNo NOT IN(SELECT ISNULL(DtsSO,'') DtsSO FROM UV1_WO_FabricProcessDts";
if (saveNoLoadCheckDayNum != 0)
{
sql += " WHERE FormDate BETWEEN " + SysString.ToDBString(DateTime.Now.AddDays(0 - saveNoLoadCheckDayNum).ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(DateTime.Now.ToString("yyyy-MM-dd"));
}
sql += " and ProcessTypeID = 2 )";//织造类型
frm.NoLoadCondition = sql;
frm.CheckFlag = 1;
frm.ShowDialog();
string str = string.Empty;
if (frm.OrderID != null && frm.OrderID.Length != 0)
{
//SetGridView1();// 防止一个采购单出现两个合同的数据
for (int i = 0; i < frm.OrderID.Length; i++)
{
if (str != string.Empty)
{
str += ",";
}
str += SysConvert.ToString(frm.OrderID[i]);
}
setItemNews(str);
gridViewRowChanged1(gridView1);
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLoadSO_Click(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改)
{
//if (SysConvert.ToString(drpVendorID.EditValue) == "")
//{
// this.ShowMessage("请选择客户");
// drpVendorID.Focus();
// return;
//}
frmLoadOrder frm = new frmLoadOrder();
frm.VendorID = SysConvert.ToString(drpVendorID.EditValue);
frm.NoLoadCondition = " and DtsID not in (select isnull(LoadDtsID,0) from WO_TowelProductionPlanDts )";
frm.CheckFlag = 1;
frm.ExtraCondition = " and ProductTypeID = 1";//加载毛巾订单
frm.ShowDialog();
string str = string.Empty;
if (frm.OrderID != null && frm.OrderID.Length != 0)
{
//SetGridView1();// 防止一个采购单出现两个合同的数据
for (int i = 0; i < frm.OrderID.Length; i++)
{
if (str != string.Empty)
{
str += ",";
}
str += SysConvert.ToString(frm.OrderID[i]);
}
setItemNews(str);
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public override void btnLoad_Click(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改)
{
frmLoadOrder frm = new frmLoadOrder();
string sql = string.Empty;
//sql += " AND FormNo+ItemCode+ColorNum+ColorName NOT IN(SELECT ISNULL(OrderFormNo+ItemCode+ColorNum+ColorName,'') OrderFormNo FROM UV1_Buy_ItemBuyFormDts";
//if (saveNoLoadCheckDayNum != 0)
//{
// sql += " WHERE FormDate BETWEEN " + SysString.ToDBString(DateTime.Now.AddDays(0 - saveNoLoadCheckDayNum).ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(DateTime.Now.ToString("yyyy-MM-dd"));
//}
//sql += ")";
sql += " AND OrderStepID=" + SysString.ToDBString((int)EnumOrderStep.新单);
frm.NoLoadCondition = sql;
frm.ExtraCondition = " and ProductTypeID = 1 ";//类型是毛巾的订单
frm.CheckFlag = 1;
frm.ShowDialog();
string str = string.Empty;
if (frm.OrderID != null && frm.OrderID.Length != 0)
{
SetGridView1();// 防止一个采购单出现两个合同的数据
for (int i = 0; i < frm.OrderID.Length; i++)
{
if (str != string.Empty)
{
str += ",";
}
str += SysConvert.ToString(frm.OrderID[i]);
}
setItemNews(str);
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void LoadSaleOrder()
{
frmLoadOrder frm = new frmLoadOrder();
frm.ShowDialog();
string str = string.Empty;
if (frm.OrderID != null && frm.OrderID.Length != 0)
{
for (int i = 0; i < frm.OrderID.Length; i++)
{
if (str != string.Empty)
{
str += ",";
}
str += SysConvert.ToString(frm.OrderID[i]);
}
setItemNews(str);
}
}
/// <summary>
/// 加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public override void btnLoad_Click(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改)
{
if (SysConvert.ToString(drpVendorID.EditValue) == "")
{
this.ShowMessage("请选择单位");
drpVendorID.Focus();
return;
}
frmLoadOrder frm = new frmLoadOrder();
frm.VendorID = SysConvert.ToString(drpVendorID.EditValue);
frm.ShowDialog();
string str = string.Empty;
if (frm.OrderID != null && frm.OrderID.Length != 0)
{
//SetGridView1();// 防止一个采购单出现两个合同的数据
for (int i = 0; i < frm.OrderID.Length; i++)
{
if (str != string.Empty)
{
str += ",";
}
str += SysConvert.ToString(frm.OrderID[i]);
}
setItemNews(str);
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 合同检索
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnHTSearch_Click(object sender, EventArgs e)
{
try
{
if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.新增))
{
this.ShowMessage("你没有此操作权限");
return;
}
if (HTDataID == 0)
{
this.ShowMessage("请定位主记录");
return;
}
if (HTDataSubmitFlag != (int)YesOrNo.Yes)
{
this.ShowMessage("单据未提交，不能操作");
return;
}
if (SysConvert.ToInt32(drpRecPayType.EditValue) == (int)EnumRecPayType.收款)//加载销售合同
{
frmLoadOrder frm = new frmLoadOrder();
string sql = string.Empty;
frm.NoLoadCondition = sql;
frm.VendorID = SysConvert.ToString(drpVendorID.EditValue);
frm.ShowDialog();
string str = string.Empty;
if (frm.OrderID != null && frm.OrderID.Length != 0)
{
for (int i = 0; i < frm.OrderID.Length; i++)
{
if (str != string.Empty)
{
str += ",";
}
str += SysConvert.ToString(frm.OrderID[i]);
break;//只加载一个合同号
}
setItemNewsSaleHT(str);
}
}
else if (SysConvert.ToInt32(drpRecPayType.EditValue) == (int)EnumRecPayType.付款)//加载采购合同
{
frmLoadItemBuy frm = new frmLoadItemBuy();
frm.VendorID = SysConvert.ToString(drpVendorID.EditValue);
string sql = string.Empty;
frm.NoLoadCondition = sql;
frm.ShowDialog();
string str = string.Empty;
if (frm.ItemBuyID != null && frm.ItemBuyID.Length != 0)
{
for (int i = 0; i < frm.ItemBuyID.Length; i++)
{
if (str != string.Empty)
{
str += ",";
}
str += SysConvert.ToString(frm.ItemBuyID[i]);
break;//只加载一个合同号
}
setItemNewsBuyHT(str);
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
