/// <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); }