/// <summary>
/// 删除位
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDeleteBit_Click(object sender, EventArgs e)
{
try
{
if (txtSBit.Text.Trim() == "")
{
this.ShowMessage("请选择要删除的记录");
return;
}
if (DialogResult.Yes != this.ShowConfirmMessage("确定要删除本记录？"))
{
return;
}
SBitRule rule = new SBitRule();
SBit entity = new SBit();
entity.MainID = HTDataID;
entity.WHID = txtWHID.Text.Trim();
entity.SectionID = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "SectionID").ToString();
entity.SBitID = txtSBit.Text.Trim();
//entity.OldSBitID = txtSBit.Text.Trim();
rule.RDelete(entity);
FCommon.AddDBLog(this.Text, "位删除", "ID:" + entity.SBitID, "");
string tempwhid = entity.WHID;
BindGridSBit();
ProcessGrid.GridViewFocus(gridView1, new string[1] {
"SectionID"
}, new string[1] {
entity.WHID
});
ProcessGrid.GridViewFocus(gridView3, new string[1] {
"SBitID"
}, new string[1] {
entity.SectionID
});
// GridViewFocus(gridView3,new string[1]{"SBitID"},new string[1]{entity.SBitID});
// Common.AddDBLog(this.Text,OPType.删除,"ID:"+entity.OldSBitID.ToString(),"位");
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 窗体加载
/// </summary>
private void frmVendorQuery_Load(object sender, System.EventArgs e)
{
try
{
ProcessGrid.BindGridColumn(gridView1, this.FormID); //绑定列
ProcessGrid.SetGridColumnUI(gridView1, this.FormListAID, this.FormListBID); //设置列UI
ProcessGrid.SetGridReadOnly(gridView1, true);
GetCondition();
BindGrid();
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
ProcessGrid.BindGridColumn(gridView1, this.FormID); //绑定列
ProcessGrid.SetGridColumnUI(gridView1, FormListAID, FormListBID); //设置列UI
Common.BindDZType(drpDZType, true);
Common.BindOP(drpSaleOPID, true);
this.HTDataTableName = "Finance_InvoiceOperation";
this.HTDataDts = gridView1;
this.HTCheckDataField = new string[] { "ItemCode" };//数据明细校验必须录入字段
new VendorProc(drpVendorID);
this.ToolBarItemAdd(28, ToolButtonName.btnLoad.ToString(), "加载", false, btnLoad_Click);
drpDZType.Enabled = false;
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
ItemBuyFormRule rule = new ItemBuyFormRule();
DataTable dt = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("FormStatusName", "'' FormStatusName"));
ItemBuyStatusProc.ProcColorStatusName(dt);
ProcDataSourceQty(dt);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
string sql = "SELECT distinct ID FROM UV1_Buy_ItemBuyFormDts WHERE 1=1";
sql += HTDataConditionStr;
dt = SysUtils.Fill(sql);
lbCount.Text = "采购单数：" + dt.Rows.Count.ToString();
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
ProcessGrid.BindGridColumn(gridView1, this.FormID);
ProcessGrid.SetGridColumnUI(gridView1, this.FormListAID, this.FormListBID);
txtQMakeDateS.DateTime = SysConvert.ToDateTime(DateTime.Now.Year.ToString() + "-01-01");
txtQMakeDateE.DateTime = DateTime.Now.Date;
Common.BindOP(drpSaleOPID, true);
this.HTDataTableName = "Finance_InvoiceOperation";
this.HTDataList = gridView1;
BindVendor();
new VendorProc(drpQVendorID);
btnQuery_Click(null, null);
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
CheckOperationDtsRule rule = new CheckOperationDtsRule();
DataTable dt = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag").Replace("DZFlagStr", "'' DZFlagStr").Replace("DZRemark", "'' DZRemark").Replace("NoDZQty", "0.00 NoDZQty").Replace("InvoiceFlagStr", "'' InvoiceFlagStr").Replace("InvoiceRemark", "'' InvoiceRemark"));
if (m_FormList == 3)
{
HTDataConditionStr = HTDataConditionStr.Replace("InvoiceFlag", "InvoiceDelFlag");
string sql = "SELECT 0 SelectFlag,ID,DtsID,MainID,Seq,DLOADID,DLOADSEQ,DLOADDtsID,DLOADNO,DCheckQty,DCheckSinglePrice,DCheckAmount,DtsRemark,FormNM,WHFormNo,WHFormDate,SUM(Qty) Qty,SinglePrice,SUM(Amount) Amount,ItemCode,ItemName,ItemStd,ItemModel,GoodsCode,ColorNum,ColorName,DtsOrderFormNo,SUM(PieceQty) PieceQty,DCheckDYPrice,DYPrice,Unit,FormDZFlag,TZAmount,InvoiceFlag,FAmount1,FAmount2,FAmount3,FAmount4 FROM UV2_Finance_CheckOperationDts2 WHERE 1=1 " + HTDataConditionStr + "GROUP BY MainID,Seq,DLOADID,DLOADSEQ,DLOADDtsID,DLOADNO,DCheckQty,DCheckSinglePrice,DCheckAmount,DtsRemark,FormNM,WHFormNo,WHFormDate,SinglePrice,ItemCode,ItemName,ItemStd,ItemModel,GoodsCode,ColorNum,ColorName,DtsOrderFormNo,DCheckDYPrice,DYPrice,Unit,FormDZFlag,TZAmount,InvoiceFlag,FAmount1,FAmount2,FAmount3,FAmount4,ID,DtsID";
dt = new DataTable();
dt = SysUtils.Fill(sql);
}
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
ProcessGrid.BindGridColumn(gridView1, this.FormID);
ProcessGrid.SetGridColumnUI(gridView1, this.FormListAID, this.FormListBID);
Common.BindVendor(drpQVendorID, new int[] { (int)EnumVendorType.客户 }, true);
new VendorProc(drpQVendorID);
Common.BindVendor(drpVendorID, new int[] { (int)EnumVendorType.客户 }, true);
new VendorProc(drpVendorID);
Common.BindVendor(drpShopID, new int[] { (int)EnumVendorType.工厂 }, true);
new VendorProc(drpShopID);
Common.BindDOP(drpShopOPName, true);
txtQMakeDateS.DateTime = SysConvert.ToDateTime(DateTime.Now.Year.ToString() + "-01-01");
txtQMakeDateE.DateTime = DateTime.Now;
this.HTDataTableName = "Att_ProductCheck";//
this.HTDataList = gridView1;
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
this.HTDataTableName = "WO_Fabric";
new ItemProcLookUp(drpItemCode, txtItemName, txtItemStd, txtItemModel, new int[] { (int)EnumItemType.面料 }, true, true);
this.BaseToolBar.Visible = false;
Common.BindVendor(drpVendorID, new int[] { (int)EnumVendorType.客户, (int)EnumVendorType.全部 }, true); //客户
ProcessGrid.BindGridColumn(gridView1, this.FormID); //绑定列
ProcessGrid.SetGridColumnUI(gridView1, this.FormListAID, this.FormListBID); //设置UI列
this.gridViewBaseRowChangedA1 += new gridViewBaseRowChangedA(gridViewRowChanged1); //绑定GridView1事件
gridViewBindEventA1(gridView1);
Common.BindFastReportList(drpReportItem, FormID, this.FormListAID);
//
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
ProcessGrid.BindGridColumn(gridView1, this.FormID); //绑定列
ProcessGrid.SetGridColumnUI(gridView1, FormListAID, FormListBID); //设置列UI
// Common.BindOP(drpSaleOPID, true);
this.HTDataTableName = "Sale_FHForm";
this.HTDataList = gridView1;
// Common.BindVendor(drpQVendorID, new int[] { (int)EnumVendorType.客户 }, true);
txtQInDateS.DateTime = DateTime.Now.AddMonths(-1).Date;
txtQInDateE.DateTime = DateTime.Now;
// drpQVendorID.EditValue = m_VendorID;
if (m_NoLoadCondition != string.Empty)//如果有未加载语句则显示查询类型
{
drpQueryType.Visible = true;
}
btnQuery_Click(null, null);
}
/// <summary>
/// 锁定库存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLockStorge_Click(object sender, EventArgs e)
{
try
{
if (!FCommon.RightCheck(this.FormID, this.FormListAID, this.FormListBID, RightSub.新增))
{
this.ShowMessage("你没有此操作权限");
return;
}
if (saveStorgeID == 0)
{
this.ShowMessage("请先查询要操作的记录");
return;
}
if (SysConvert.ToFloat(txtLockQty.Text.Trim()) > SysConvert.ToFloat(txtLeftQty.Text.Trim()))
{
this.ShowMessage("锁定数量大于当前可使用数量，不能实现库存锁定");
return;
}
if (!NewCheckCorrect())
{
return;
}
//if (!CheckCorrectLock())
//{
// return;
//}
StorgeLockRule rule = new StorgeLockRule();
StorgeLock entity = this.GetEntity();
rule.RLock(entity, true);
string tempwhid = saveItemWHID;
string tempitemcode = saveItemCode;
string tempStorgeID = saveStorgeID.ToString();
BindGrid();
ProcessGrid.GridViewFocus(gridView1, new string[1] {
"ID"
}, new string[1] {
tempStorgeID
});
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
ProcessGrid.BindGridColumn(gridView1, this.FormID);
ProcessGrid.SetGridColumnUI(gridView1, this.FormListAID, this.FormListBID);
Common.BindVendor(drpVendorID, new int[] { (int)EnumVendorType.工厂 }, true);
new VendorProc(drpVendorID);
Common.BindVendor(drpShopID, new int[] { (int)EnumVendorType.客户 }, true);
new VendorProc(drpShopID);
//Common.BindEnumUnit(txtUnit, true);
Common.BindCLS(txtUnit, "Data_Item", "ItemUnitFab", true);
Common.BindOP(drpCheckOPID, true);
this.HTDataTableName = "Att_ProductCheck";
this.HTDataDts = gridView1;
this.HTCheckDataField = new string[] { "ItemCode" };//数据明细校验必须录入字段
this.ToolBarItemAdd(28, ToolButtonName.btnLoad.ToString(), "加载", false, btnLoad_Click);
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
FabricProcessRule rule = new FabricProcessRule();
DataTable dt = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("FormStatusName", "'' FormStatusName"));
ItemBuyStatusProc.ProcColorStatusName(dt);
ProcDataSourceQty(dt);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
string sql = "SELECT distinct ID FROM UV1_WO_FabricProcessDts WHERE 1=1";
sql += HTDataConditionStr;
dt = SysUtils.Fill(sql);
lbCount.Text = "加工单数：" + dt.Rows.Count.ToString();
ProcessGrid.SetGridEdit(gridView1, new string[] { "HandleStatus", "HandleStatusDate" }, true);
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
IOFormRule rule = new IOFormRule();
DataTable dt = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag").Replace("DZFlagStr", "'' DZFlagStr").Replace("DZRemark", "'' DZRemark").Replace("NoDZQty", "0.00 NoDZQty").Replace("InvoiceFlagStr", "'' InvoiceFlagStr").Replace("InvoiceRemark", "'' InvoiceRemark"));
if (m_DZFlag == 1)
{
SetDZGridView(dt);
}
if (m_InvoiceFlag == 1)
{
SetInvoiceGridView(dt);
}
SetWHQty(dt);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
this.HTDataTableName = "Buy_AccesoryCompact";
this.HTDataList = gridView1;
txtQCompactDateS.DateTime = DateTime.Now.AddDays(0 - ParamConfig.QueryDayNum);
txtQCompactDateE.DateTime = DateTime.Now.Date;
Common.BindVendor(drpQVendorID, new int[] { (int)EnumVendorType.工厂 }, true);//客户
Common.BindOPID(drpQSaleOPID, true);
//new ItemProcLookUp(drpQItemCode, new int[] { (int)EnumItemType.辅料 }, true, true);
HTDataList.OptionsBehavior.ShowEditorOnMouseUp = false;
ProcessGrid.SetGridEdit(HTDataList, "SelectFlag", true);
}
/// <summary>
/// 绑定明细数据
/// </summary>
/// <param name="p_StrongRefresh">强制刷新标志，如果工艺流程改变则强制刷新，已保存的会自动清空</param>
void BindGrid2(bool p_StrongRefresh)
{
ItemGYFlowItemDtsRule rule = new ItemGYFlowItemDtsRule();
DataTable dt = rule.RShow(" AND 1=0", ProcessGrid.GetQueryField(gridView2));//查询结果格式
bool findFlag = false;
if (gridView1.FocusedRowHandle >= 0)
{
if (saveDtGYItemDts[gridView1.FocusedRowHandle] != null)
{
dt = saveDtGYItemDts[gridView1.FocusedRowHandle];
findFlag = true;
}
}
if (p_StrongRefresh || !findFlag)//强制刷新或没有数据表值
{
string conditionStr = string.Empty;
conditionStr = " AND MainID=" + SysConvert.ToInt32(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ID")) + " ORDER BY Seq";
dt = rule.RShow(conditionStr, ProcessGrid.GetQueryField(gridView2));
if (dt.Rows.Count == 0)//如果为空，绑定初始定义值
{
string sql = "SELECT Name FROM Data_ItemBaseGYTypeDts WHERE 1=1 AND MainID=" + SysConvert.ToInt32(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ItemGYTypeID")) + " ORDER BY Code";
DataTable dtBaseInfo = SysUtils.Fill(sql);
int i = 1;
foreach (DataRow drBaseInfo in dtBaseInfo.Rows)
{
DataRow dr = dt.NewRow();
dr["Seq"] = i++;
dr["GYItemName"] = drBaseInfo["Name"].ToString();
dt.Rows.Add(dr);
}
}
if (gridView1.FocusedRowHandle >= 0)
{
saveDtGYItemDts[gridView1.FocusedRowHandle] = dt;
}
}
gridView2.GridControl.DataSource = dt;
gridView2.GridControl.Show();
}
/// <summary>
/// 窗体加载
/// </summary>
private void frmLoadItem_Load(object sender, System.EventArgs e)
{
try
{
ProcessTreeList.BindTreeColumn(treeList1, this.FormID); //绑定列
ProcessTreeList.SetTreeColumnUI(treeList1); //设置列UI
ProcessGrid.BindGridColumn(gridView1, this.FormID); //绑定列
ProcessGrid.SetGridColumnUI(gridView1, FormListAID, FormListBID); //设置列UI
BindTreeList();
BindGrid();
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 绑定数据明细
/// </summary>
public override void BindGridDts()
{
CheckOperationDtsRule rule = new CheckOperationDtsRule();
DataTable dtDts = new DataTable();
if (IsMerge == 1)
{
string sql = "SELECT MainID,Seq,DLOADID,DLOADSEQ,DLOADDtsID,DLOADNO,DCheckQty,DCheckSinglePrice,DCheckAmount,DtsRemark,FormNM,WHFormNo,WHFormDate,SUM(Qty) Qty,SinglePrice,SUM(Amount) Amount,ItemCode,ItemName,ItemStd,ItemModel,GoodsCode,ColorNum,ColorName,DtsOrderFormNo,SUM(PieceQty) PieceQty,DCheckDYPrice,DYPrice,Unit,FormDZFlag,TZAmount,InvoiceFlag,FAmount1,FAmount2,FAmount3,FAmount4 FROM UV2_Finance_CheckOperationDts2 WHERE 1=1 " + " AND MainID=" + HTDataID + "GROUP BY MainID,Seq,DLOADID,DLOADSEQ,DLOADDtsID,DLOADNO,DCheckQty,DCheckSinglePrice,DCheckAmount,DtsRemark,FormNM,WHFormNo,WHFormDate,SinglePrice,ItemCode,ItemName,ItemStd,ItemModel,GoodsCode,ColorNum,ColorName,DtsOrderFormNo,DCheckDYPrice,DYPrice,Unit,FormDZFlag,TZAmount,InvoiceFlag,FAmount1,FAmount2,FAmount3,FAmount4";
dtDts = SysUtils.Fill(sql);
}
else
{
dtDts = rule.RShow(" AND MainID=" + HTDataID + " ORDER BY Seq", ProcessGrid.GetQueryField(gridView1));
}
SetWHQty(dtDts);
gridView1.GridControl.DataSource = dtDts;
gridView1.GridControl.Show();
}
/// <summary>
/// 通用窗体加载方法，如果不要使用，则重写，一般不要修改
/// </summary>
public virtual void IniFormLoadBefore()
{
if (HTDataDts.Columns.Count != 0)
{
ProcessGrid.BindGridColumn(_HTDataDts, this.FormID); //绑定列
ProcessGrid.SetGridColumnUI(_HTDataDts, this.FormListAID, this.FormListBID); //设置列UI
//ProcessGrid.SetGridManDefault(_HTDataDts);
}
for (int i = 0; i < _HTDataDtsAttach.Length; i++)
{
ProcessGrid.BindGridColumn(_HTDataDtsAttach[i], this.FormID); //绑定列
ProcessGrid.SetGridColumnUI(_HTDataDtsAttach[i], this.FormListAID, this.FormListBID); //设置列UI
//ProcessGrid.SetGridManDefault(_HTDataDtsAttach[i]);
}
SetToolButtonVisible();
btnQuery_Click(null, null);
}
void showDetail()
{ //Material_Import
string sqlstr = "Select M.Form_No , mat.mat_name ,M.Emp_Id ,M.Form_Date, M.Import_Date, M.Vendor_Id, p.Pay_Name";
sqlstr += " from Material_Import M , Material mat , Pay p, Status s";
sqlstr += " where M.form_no = " + Form_No.Text;
sqlstr += " and M.mat_id = mat.mat_id";
sqlstr += " and M.Pay_id = p.Pay_Id";
sqlstr += " and M.Status_id= s.Status_Id";
sqlstr += " and s.Class='Material'";
DataTable myTable = mydb.GetDataTable(sqlstr);
/*讀取登入者名稱*/
Emp_Id.Text = Session["Emp_Name"].ToString().Trim();
//日期:讀取資料
Import_Date.Text = ((DateTime)myTable.Rows[0]["import_date"]).ToString("yyyy-MM-dd");
//廠商
Vendor_Id.Text = myTable.Rows[0]["Vendor_Id"].ToString().Trim();
/*用廠商ID抓名稱*/
sqlstr = " select vendor_name from vendor where vendor_id=" + mydb.qo(Vendor_Id.Text);
Vendor_Name.Text = mydb.getSingleData(0, sqlstr);
//備註
sqlstr = " select comment from Material_Import_Detail where Form_no =" + Form_No.Text;
Comment.Text = mydb.getSingleData(0, sqlstr);
//-------------------------
//Material_Import_Detail
sqlstr = "select d.Form_No as Form_No, d.mat_id as mat_id, m.mat_name as mat_name, d.qty as qty, d.price as price, d.comment as comment ";
sqlstr += " from Material_Import_Detail d, Material M ";
sqlstr += " where d.form_no = " + Form_No.Text;
sqlstr += " and d.mat_id = m.mat_id ";
ResGrid.DataSource = mydb.GetDataTable(sqlstr);
ResGrid.DataBind();
//Verify
sqlstr = "select s.Status,v.Form_No,v.Emp_Id,v.Verify_Date,v.Comment from Verify v,Status s ";
sqlstr += " where v.Form_No = " + Form_No.Text;
sqlstr += " and v.Status_id = s.Status_Id";
sqlstr += " and s.Class ='Material'";
ProcessGrid.DataSource = mydb.GetDataTable(sqlstr);
ProcessGrid.DataBind();
}
/// <summary>
/// 修改色卡状态
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdateColorStatus_Click(object sender, EventArgs e)
{
try
{
if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.新增))
{
this.ShowMessage("没有此权限，请联系管理员");
return;
}
//1: L/D样 2：S/D样
if (this.FormListAID == 1)
{
frmUpdateColorCardStatus frm = new frmUpdateColorCardStatus();
frm.StartPosition = FormStartPosition.Manual;
frm.Location = new Point(400, 280);
frm.DtsID = SysConvert.ToInt32(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "DtsID"));
frm.ShowDialog();
btnQuery_Click(null, null);
ProcessGrid.GridViewFocus(gridView1, new string[1] {
"DtsID"
}, new string[1] {
frm.DtsID.ToString()
});
}
else if (this.FormListAID == 2)
{
frmUpdateColorCardStatusSD frm = new frmUpdateColorCardStatusSD();
frm.StartPosition = FormStartPosition.Manual;
frm.Location = new Point(400, 280);
frm.DtsID = SysConvert.ToInt32(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "DtsID"));
frm.ShowDialog();
btnQuery_Click(null, null);
ProcessGrid.GridViewFocus(gridView1, new string[1] {
"DtsID"
}, new string[1] {
frm.DtsID.ToString()
});
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
ProcessGrid.BindGridColumn(gridView1, this.FormID); //绑定列
ProcessGrid.SetGridColumnUI(gridView1, FormListAID, FormListBID); //设置列UI
Common.BindDZType(drpDZType, true);
this.HTDataTableName = "Finance_CheckOperation";
this.HTDataDts = gridView1;
this.HTCheckDataField = new string[] { "DLOADID", "ItemCode" };//数据明细校验必须录入字段
this.ToolBarItemAdd(28, ToolButtonName.btnLoad.ToString(), "加载", false, btnLoad_Click);
Common.BindOP(drpSaleOPID, true);
Common.BindCheckMethodType(drpCheckMethodType, true);
//Common.BindVendorByDZTypeID(drpVendorID, this.FormListAID, true);
//new VendorProc(drpVendorID);
DevMethod.BindVendorByDZTypeID(drpVendorID, this.FormListAID, true);//2015.4.8 CX UPDATE
//Common.BindMLType(drpMLTpe, true);
//Common.BindEnumUnit(drpUnit, true);
txtMakeDate.DateTime = DateTime.Now.Date;
Common.BindCLS(drpUnit, "Sale_SaleOrder", "Unit", true);
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
this.HTDataTableName = "Data_Item";
this.HTDataList = gridView1;
txtQMakeDateE.DateTime = DateTime.Now.Date;
txtQMakeDateS.DateTime = DateTime.Now.Date.AddDays(0 - ParamConfig.QueryDayNum);
ProcessTreeList.BindTreeColumn(treeList1, this.FormID); //绑定列
ProcessTreeList.SetTreeColumnUI(treeList1); //设置列UI
ProcessGrid.BindGridColumn(gridView1, this.FormID); //绑定列
ProcessGrid.SetGridColumnUI(gridView1, FormListAID, FormListBID); //设置列UI
ProcessGrid.SetGridEdit(gridView1, new string[] { "ItemName", "ItemCode", "ItemStd" }, true); //临时让其处于可编辑状态
Common.BindItemClass(drpQItemClass, this.FormListAID, true);
BindTreeList();
}
void showDetail()
{ //Reserve_Import
string sqlstr = "select * from Reserve_Import where form_no = " + Form_No.Text;
DataTable myTable = mydb.GetDataTable(sqlstr);
/*讀取登入者名稱*/
Emp_Id.Text = mydb.qo(Session["Emp_Name"].ToString());
//
string status = myTable.Rows[0]["Status_Id"].ToString().Trim();
for (int idx = 0; idx < StatusList.Items.Count; idx++)
{
if (status == StatusList.Items[idx].Value.Trim())
{
StatusList.SelectedIndex = idx;
}
}
//
Import_Date.Text = myTable.Rows[0]["Import_Date"].ToString();
//Import_Date_Est.Text = myTable.Rows[0]["import_date_est"].ToString();
Import_Date.Text = ((DateTime)myTable.Rows[0]["import_date"]).ToString("yyyy-MM-dd");// DateTime.Now.ToString("yyyy-MM-dd");//myTable.Rows[0]["import_date"].ToString();
//
Vendor_Id.Text = myTable.Rows[0]["Vendor_Id"].ToString().Trim();
sqlstr = " select vendor_name from vendor where vendor_id=" + mydb.qo(Vendor_Id.Text);
Vendor_Name.Text = mydb.getSingleData(0, sqlstr);
//
Comment.Text = myTable.Rows[0]["Comment"].ToString().Trim();
//-------------------------
//Material_Import_Detail
sqlstr = "select d.Form_No as Form_No, d.mat_id as mat_id, m.mat_name as mat_name, d.qty as qty, d.price as price, d.comment as comment ";
sqlstr += " from Material_Import_Detail d, Material M ";
sqlstr += " where d.form_no = " + Form_No.Text;
sqlstr += " and d.mat_id = m.mat_id ";
ResGrid.DataSource = mydb.GetDataTable(sqlstr);
ResGrid.DataBind();
//Verify
sqlstr = "select * from Verify ";
sqlstr += " where form_no = " + Form_No.Text;
ProcessGrid.DataSource = mydb.GetDataTable(sqlstr);
ProcessGrid.DataBind();
}
/// <summary>
/// 新增位
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnInsertBit_Click(object sender, EventArgs e)
{
try
{
if (!CheckCorrectBit())
{
return;
}
SBitRule rule = new SBitRule();
SBit entity = this.GetEntitySBit();
if (SysConvert.ToInt32(drpWHPosMethodID.EditValue) == 1 || SysConvert.ToInt32(drpWHPosMethodID.EditValue) == 2)
{
this.ShowMessage("物理位置不包含位无法新增");
return;
}
else
{
rule.RAdd(entity);
}
FCommon.AddDBLog(this.Text, "位新增", "ID:" + entity.SBitID, "");
BindGridSBit();
// ProcessGrid.GridViewFocus(gridView1, new string[1] { "WHID" }, new string[1] { entity.WHID });
ProcessGrid.GridViewFocus(gridView1, new string[1] {
"SectionID"
}, new string[1] {
entity.SectionID
});
ProcessGrid.GridViewFocus(gridView3, new string[1] {
"SBitID"
}, new string[1] {
entity.SBitID
});
// Common.AddDBLog(this.Text,OPType.新增,"ID:"+entity.SBitID.ToString(),"位");
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 更新位
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdateBit_Click(object sender, EventArgs e)
{
try
{
if (txtSBit.Text.Trim() == "")
{
this.ShowMessage("请选择要修改的记录");
return;
}
if (!CheckCorrectBit())
{
return;
}
SBitRule rule = new SBitRule();
SBit entity = this.GetEntitySBit();
string OLDSBitID = SysConvert.ToString(gridView3.GetFocusedRowCellValue("SBitID"));
//entity.MainID = HTDataID;
//entity.WHID = txtWHID.Text.Trim();
//entity.SectionID = txtSectionIDBit.Text.Trim();
//entity.SBitID = txtSBit.Text.Trim();
rule.RUpdate(entity, OLDSBitID);
FCommon.AddDBLog(this.Text, "位更新", "ID:" + entity.SBitID, "New ID:" + entity.SBitID);
BindGridSBit();
//ProcessGrid.GridViewFocus(gridView1, new string[1] { "WHID" }, new string[1] { entity.WHID });
ProcessGrid.GridViewFocus(gridView1, new string[1] {
"SectionID"
}, new string[1] {
entity.SectionID
});
ProcessGrid.GridViewFocus(gridView3, new string[1] {
"SBitID"
}, new string[1] {
entity.SBitID
});
// Common.AddDBLog(this.Text,OPType.更新,"ID:"+entity.OldSBitID.ToString(),"位");
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
ProcessGrid.BindGridColumn(gridView1, this.FormID); //绑定列
ProcessGrid.SetGridColumnUI(gridView1, FormListAID, FormListBID); //设置列UI
this.HTDataTableName = "Buy_ItemBuyFollow";
this.HTDataDts = gridView1;
this.HTCheckDataField = new string[] { "ProcStepID", "CheckItem" };//数据明细校验必须录入字段
Common.BindVendor(drpShopID, new int[] { (int)EnumVendorType.工厂 }, true);
Common.BindCLS(txtPackReq, "Buy_ItemBuyFollow", "PackReq", true);
new VendorProc(drpShopID);
txtOrderFormNo.ToolTip = "请双击加载采购单";
Common.BindFollow(drpFollow, true);
this.ToolBarItemAdd(28, ToolButtonName.btnLoad.ToString(), "加载", false, txtOrderFormNo_DoubleClick);
ParamSetRule psrule = new ParamSetRule();
saveNoLoadCheckDayNum = psrule.RShowIntByCode((int)ParamSetEnum.未加载数据比对天数);
}
/// <summary>
/// 通用窗体加载方法，如果不要使用，则重写，一般不要修改
/// </summary>
public virtual void IniFormLoadBefore()
{
if (_HTDataList.Columns.Count != 0)
{
ProcessGrid.BindGridColumn(_HTDataList, this.FormID); //绑定列
ProcessGrid.SetGridColumnUI(_HTDataList, this.FormListAID, this.FormListBID); //设置列UI
this.gridViewBaseRowChangedA1 += new gridViewBaseRowChangedA(gridViewRowChanged1); //绑定GridView1事件
gridViewBindEventA1(_HTDataList);
}
for (int i = 0; i < _HTDataDtsAttach.Length; i++)
{
ProcessGrid.BindGridColumn(_HTDataDtsAttach[i], this.FormID); //绑定列
ProcessGrid.SetGridColumnUI(_HTDataDtsAttach[i], this.FormListAID, this.FormListBID); //设置列UI
ProcessGrid.SetGridManDefault(_HTDataDtsAttach[i]);
}
ProcessGrid.SetGridReadOnly(_HTDataList, false);
ProcessGrid.SetGridUIListDefault(_HTDataList);
btnQuery_Click(null, null);
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
this.HTDataTableName = "Data_FlowerTypeContol";
this.HTDataDts = gridView1;
this.HTCheckDataField = new string[] { "ColorCode" }; //数据明细校验必须录入字段
ProcessGrid.BindGridColumn(gridView1, this.FormID); //绑定列
ProcessGrid.SetGridColumnUI(gridView1, this.FormListAID, this.FormListBID); //设置UI列
this.gridViewBaseRowChangedA1 += new gridViewBaseRowChangedA(gridViewRowChanged1); //绑定GridView1事件
gridViewBindEventA1(gridView1);
txtDHX.Enabled = true;
txtDMS.Enabled = true;
txtDJBBM.Enabled = true;
txtDYS.Enabled = true;
txtDML.Enabled = true;
txtDSize.Enabled = true;
txtJZ.Enabled = true;
SetTabIndex(0, groupControlMainten);
}
/// <summary>
/// 绑定结算数据
/// </summary>
public void BindGrid()
{
StorgeJSDtsRule rule = new StorgeJSDtsRule();
string conditionStr = " AND MainID=" + SysString.ToDBString(HTDataID);
if (!Common.CheckLookUpEditBlank(drpQWHID))
{
conditionStr += " AND WHID=" + SysString.ToDBString(SysConvert.ToString(drpQWHID.EditValue));
}
if (txtQItemCode.Text.Trim() != string.Empty)
{
conditionStr += " AND ItemCode=" + SysString.ToDBString(txtQItemCode.Text);
}
if (txtJHFormNo.Text.Trim() != string.Empty)
{
conditionStr += " AND JHFormNo=" + SysString.ToDBString(txtJHFormNo.Text);
}
gridView1.GridControl.DataSource = rule.RShow(conditionStr, ProcessGrid.GetQueryField(gridView1));
gridView1.GridControl.Show();
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
ProcessGrid.BindGridColumn(gridView1, this.FormID);
ProcessGrid.SetGridColumnUI(gridView1, this.FormListAID, this.FormListBID);
txtQMakeDateS.DateTime = SysConvert.ToDateTime(DateTime.Now.Year.ToString() + "-01-01");
txtQMakeDateE.DateTime = DateTime.Now;
//Common.BindVendor(drpQVendorID, new int[] { (int)EnumVendorType.工厂 }, true);
this.HTDataTableName = "Finance_RecPay";
this.HTDataList = gridView1;
Common.BindOP(drpPlanOPID, true);
if (this.FormListAID == (int)EnumVendorType.客户)
{
Common.BindVendor(drpQVendorID, new int[] { (int)EnumVendorType.客户 }, true);
}
else
{
Common.BindVendor(drpQVendorID, new int[] { (int)EnumVendorType.工厂, (int)EnumVendorType.检测机构, (int)EnumVendorType.快递公司, (int)EnumVendorType.物流公司 }, true);
}
new VendorProc(drpQVendorID);
}
