private void pmInitGridProp()
{
System.Data.DataView dvBrow = this.dtsDataEnv.Tables[this.mstrBrowViewAlias].DefaultView;
dvBrow.Sort = "FCCODE";
this.grdBrowView.DataSource = this.dtsDataEnv.Tables[this.mstrBrowViewAlias];
for (int intCnt = 0; intCnt < this.gridView1.Columns.Count; intCnt++)
{
this.gridView1.Columns[intCnt].Visible = false;
}
int i = 0;
this.gridView1.Columns["FCCODE"].VisibleIndex = i++;
this.gridView1.Columns["FCNAME"].VisibleIndex = i++;
this.gridView1.Columns["FCCODE"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "ÃËÑÊ", "Code" });
this.gridView1.Columns["FCNAME"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "ª×èÍ", "Name" });
//this.gridView1.Columns["CSNAME"].Caption = "ª×èÍÂèÍ";
this.gridView1.Columns["FCCODE"].Width = 15;
this.pmSetSortKey("FCCODE", true);
}
private void pmInitGridProp()
{
System.Data.DataView dvBrow = this.dtsDataEnv.Tables[this.mstrBrowViewAlias].DefaultView;
dvBrow.Sort = QEMWHLocationInfo.Field.Code;
this.grdBrowView.DataSource = this.dtsDataEnv.Tables[this.mstrBrowViewAlias];
for (int intCnt = 0; intCnt < this.gridView1.Columns.Count; intCnt++)
{
this.gridView1.Columns[intCnt].Visible = false;
}
this.gridView1.Columns[QEMWHLocationInfo.Field.Code].Visible = true;
this.gridView1.Columns[QEMWHLocationInfo.Field.Name].Visible = true;
this.gridView1.Columns[QEMWHLocationInfo.Field.Name2].Visible = true;
this.gridView1.Columns[QEMWHLocationInfo.Field.Code].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "รหัสที่เก็บสินค้า", "Location Code" });
this.gridView1.Columns[QEMWHLocationInfo.Field.Name].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "ชื่อที่เก็บสินค้า", "Location Name" });
this.gridView1.Columns[QEMWHLocationInfo.Field.Name2].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "ชื่อที่เก็บสินค้าภาษา2", "Location Name2" });
this.gridView1.Columns[QEMWHLocationInfo.Field.Code].Width = 15;
this.gridView1.Columns[QEMWHLocationInfo.Field.Name2].Width = 25;
this.gridView1.Columns[QEMWHLocationInfo.Field.Code].VisibleIndex = 0;
this.gridView1.Columns[QEMWHLocationInfo.Field.Name].VisibleIndex = 1;
this.gridView1.Columns[QEMWHLocationInfo.Field.Name2].VisibleIndex = 2;
this.pmSetSortKey(QEMWHLocationInfo.Field.Code, true);
}
private void pmInitializeComponent()
{
UIHelper.UIBase.CreatePopUpToolbar(this.barMainEdit, this.barMain);
this.barMainEdit.ItemClick += new DevExpress.XtraBars.ItemClickEventHandler(this.barMainEdit_ItemClick);
this.gridView1.DoubleClick += new System.EventHandler(this.gridView1_DoubleClick);
this.KeyDown += new System.Windows.Forms.KeyEventHandler(this.dlgGetCorp_KeyDown);
this.Text = UIBase.GetAppText(App.mLocale_UI, new string[] { "ÃкغÃÔÉѷ㹡ÒÃà¢éÒ·Ó§Ò¹", "Select Company" });
}
private void pmInitGridProp()
{
System.Data.DataView dvBrow = this.dtsDataEnv.Tables[this.mstrBrowViewAlias].DefaultView;
dvBrow.Sort = "QCPROD";
this.grdBrowView.DataSource = this.dtsDataEnv.Tables[this.mstrBrowViewAlias];
for (int intCnt = 0; intCnt < this.gridView1.Columns.Count; intCnt++)
{
this.gridView1.Columns[intCnt].Visible = false;
this.gridView1.Columns[intCnt].OptionsColumn.AllowEdit = false;
}
int i = 0;
this.gridView1.Columns["CTAGVALUE"].VisibleIndex = i++;
this.gridView1.Columns["QCPROD"].VisibleIndex = i++;
this.gridView1.Columns["QNPROD"].VisibleIndex = i++;
this.gridView1.Columns["NQTY"].VisibleIndex = i++;
this.gridView1.Columns["QNUM"].VisibleIndex = i++;
this.gridView1.Columns["CTAGVALUE"].OptionsColumn.AllowSort = DefaultBoolean.False;
this.gridView1.Columns["CTAGVALUE"].ImageIndex = 0;
this.gridView1.Columns["CTAGVALUE"].ImageAlignment = StringAlignment.Center;
this.gridView1.Columns["CTAGVALUE"].OptionsColumn.AllowEdit = true;
this.gridView1.Columns["CTAGVALUE"].Visible = true;
this.gridView1.Columns["QCPROD"].Visible = true;
this.gridView1.Columns["QNPROD"].Visible = true;
this.gridView1.Columns["CTAGVALUE"].Caption = " ";
this.gridView1.Columns["QCPROD"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "รหัสสินค้า", "RM / Product Code" });
this.gridView1.Columns["QNPROD"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "ชื่อสินค้า", "RM / Product Description" });
this.gridView1.Columns["NQTY"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "จำนวน", "Qty." });
this.gridView1.Columns["QNUM"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "หน่วยนับ", "Unit" });
this.gridView1.Columns["NQTY"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView1.Columns["NQTY"].DisplayFormat.FormatString = "#,###,##0.0000";
this.gridView1.Columns["CTAGVALUE"].OptionsColumn.AllowEdit = true;
this.gridView1.Columns["CTAGVALUE"].Width = 40;
this.gridView1.Columns["QCPROD"].Width = 120;
this.gridView1.Columns["NQTY"].Width = 90;
this.gridView1.Columns["QNUM"].Width = 90;
this.pmCalcColWidth();
this.pmSetSortKey("QCPROD", true);
}
private void pmInitGridProp_TemPd()
{
System.Data.DataView dvBrow = this.dtsDataEnv.Tables[this.mstrTemPd].DefaultView;
this.grdTemPd.DataSource = this.dtsDataEnv.Tables[this.mstrTemPd];
for (int intCnt = 0; intCnt < this.gridView1.Columns.Count; intCnt++)
{
this.gridView1.Columns[intCnt].Visible = false;
this.gridView1.Columns[intCnt].OptionsColumn.AllowEdit = false;
this.gridView1.Columns[intCnt].OptionsColumn.AllowFocus = false;
}
int i = 0;
this.gridView1.Columns["nRecNo"].VisibleIndex = i++;
this.gridView1.Columns["cOPSeq"].VisibleIndex = i++;
this.gridView1.Columns["cPdType"].VisibleIndex = i++;
this.gridView1.Columns["cQcProd"].VisibleIndex = i++;
//this.gridView1.Columns["cQnProd"].VisibleIndex = i++;
//this.gridView1.Columns["cRemark1"].VisibleIndex = i++;
this.gridView1.Columns["cQcWHouse"].VisibleIndex = i++;
this.gridView1.Columns["cLot"].VisibleIndex = i++;
this.gridView1.Columns["nQty"].VisibleIndex = i++;
this.gridView1.Columns["cQnUOM"].VisibleIndex = i++;
this.gridView1.Columns["cProcure"].VisibleIndex = i++;
this.gridView1.Columns["cScrap"].VisibleIndex = i++;
this.gridView1.Columns["cRoundCtrl"].VisibleIndex = i++;
this.gridView1.Columns["cQcBOM"].VisibleIndex = i++;
//this.gridView1.Columns["cSubSti"].VisibleIndex = i++;
this.gridView1.Columns["nRecNo"].Caption = "No.";
this.gridView1.Columns["cOPSeq"].Caption = "OP. Seq.";
this.gridView1.Columns["cPdType"].Caption = "T";
this.gridView1.Columns["cQcProd"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "รหัสสินค้า", "RM / Product Code" });
this.gridView1.Columns["cQnProd"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "ชื่อสินค้า", "RM / Product Description" });
this.gridView1.Columns["cRemark1"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "หมายเหตุ", "Remark" });
this.gridView1.Columns["nRefQty"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "จำนวน BOM", "BOM Qty." });
this.gridView1.Columns["nQty"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "จำนวน", "Qty." });
this.gridView1.Columns["cQnUOM"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "หน่วย", "Unit" });
this.gridView1.Columns["cQcWHouse"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "คลังสินค้า", "WareHouse" });
this.gridView1.Columns["cLot"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "ล๊อต", "Lot" });
this.gridView1.Columns["cScrap"].Caption = "Scrap";
this.gridView1.Columns["cProcure"].Caption = "Procure";
this.gridView1.Columns["cSubSti"].Caption = "S";
this.gridView1.Columns["cQcBOM"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "BOM", "BOM" });
this.gridView1.Columns["cRoundCtrl"].Caption = "Round";
this.gridView1.Columns["nRecNo"].Width = 50;
this.gridView1.Columns["cOPSeq"].Width = 80;
this.gridView1.Columns["cPdType"].Width = 50;
this.gridView1.Columns["cQcProd"].Width = 130;
this.gridView1.Columns["cRemark1"].Width = 80;
this.gridView1.Columns["nRefQty"].Width = 80;
this.gridView1.Columns["nQty"].Width = 80;
this.gridView1.Columns["cQnUOM"].Width = 80;
this.gridView1.Columns["cScrap"].Width = 80;
this.gridView1.Columns["cProcure"].Width = 60;
this.gridView1.Columns["cQcBOM"].Width = 130;
//this.gridView1.Columns["cSubSti"].Width = 5;
this.gridView1.Columns["cRoundCtrl"].Width = 60;
//WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside);
this.grcQcProd.Buttons[0].Tag = "GRDVIEW1_CQCPROD";
this.grcPdType.Buttons[0].Tag = "GRDVIEW1_CPDTYPE";
//this.grcRemark2.Buttons[0].Tag = "GRDVIEW1_CREMARK1";
this.grcQcBOM.Buttons[0].Tag = "GRDVIEW1_CQCBOM";
this.grcQcWHouse.Buttons[0].Tag = "GRDVIEW1_CQCWHOUSE";
this.grcLot.Buttons[0].Tag = "GRDVIEW1_CQCWHOUSE";
this.grcQcProd.MaxLength = MapTable.GetMaxLength(pobjSQLUtil, "PROD", "FCCODE");
this.grcQcWHouse.MaxLength = MapTable.GetMaxLength(pobjSQLUtil, "WHOUSE", "FCCODE");
//this.grcRemark.MaxLength = 150;
//this.grcRemark2.MaxLength = 150;
this.grcScrap.MaxLength = 20;
this.gridView1.Columns["cQcWHouse"].OptionsColumn.AllowEdit = true;
this.gridView1.Columns["cQcWHouse"].OptionsColumn.AllowFocus = true;
this.gridView1.Columns["cLot"].OptionsColumn.AllowEdit = true;
this.gridView1.Columns["cLot"].OptionsColumn.AllowFocus = true;
//this.gridView1.Columns["nRecNo"].AppearanceCell.Options. = DevExpress.Utils.HorzAlignment.Far;
this.gridView1.Columns["nRecNo"].AppearanceCell.BackColor = System.Drawing.Color.WhiteSmoke;
this.gridView1.Columns["nRecNo"].OptionsColumn.AllowFocus = false;
this.gridView1.Columns["nRecNo"].OptionsColumn.ReadOnly = true;
this.gridView1.Columns["nRefQty"].AppearanceCell.BackColor = System.Drawing.Color.WhiteSmoke;
this.gridView1.Columns["nRefQty"].OptionsColumn.AllowFocus = false;
this.gridView1.Columns["nRefQty"].OptionsColumn.ReadOnly = true;
this.gridView1.Columns["nRefQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView1.Columns["nRefQty"].DisplayFormat.FormatString = "#,###,###,##0.0000";
this.gridView1.Columns["cQnProd"].AppearanceCell.BackColor = System.Drawing.Color.WhiteSmoke;
this.gridView1.Columns["cQnProd"].OptionsColumn.AllowFocus = false;
this.gridView1.Columns["cQnProd"].OptionsColumn.ReadOnly = true;
this.gridView1.Columns["cQnUOM"].AppearanceCell.BackColor = System.Drawing.Color.WhiteSmoke;
this.gridView1.Columns["cQnUOM"].OptionsColumn.AllowFocus = false;
this.gridView1.Columns["cQnUOM"].OptionsColumn.ReadOnly = true;
this.gridView1.Columns["nQty"].ColumnEdit = this.grcQty;
this.gridView1.Columns["cPdType"].ColumnEdit = this.grcPdType;
this.gridView1.Columns["cQcProd"].ColumnEdit = this.grcQcProd;
//this.gridView1.Columns["cRemark1"].ColumnEdit = this.grcRemark2;
this.gridView1.Columns["cProcure"].ColumnEdit = this.grcProcure;
this.gridView1.Columns["cScrap"].ColumnEdit = this.grcScrap;
this.gridView1.Columns["cQcBOM"].ColumnEdit = this.grcQcBOM;
this.gridView1.Columns["cRoundCtrl"].ColumnEdit = this.grcRoundCtrl;
this.gridView1.Columns["cQcWHouse"].ColumnEdit = this.grcQcWHouse;
this.gridView1.Columns["cLot"].ColumnEdit = this.grcLot;
this.pmCalcColWidth2();
}
private void pmInitGridProp()
{
//this.grdBrowView.SetDataBinding(this.dtsDataEnv.Tables[this.mstrAlias], "");
//this.grdBrowView.RetrieveStructure();
System.Data.DataView dvBrow = this.dtsDataEnv.Tables[this.mstrAlias].DefaultView;
this.grdBrowView.DataSource = this.dtsDataEnv.Tables[this.mstrAlias];
for (int intCnt = 0; intCnt < this.gridView1.Columns.Count; intCnt++)
{
this.gridView1.Columns[intCnt].Visible = false;
}
int i = 0;
this.gridView1.Columns["nRecNo"].VisibleIndex = i++;
this.gridView1.Columns["cOPSeq"].VisibleIndex = i++;
this.gridView1.Columns["cPdType"].VisibleIndex = i++;
this.gridView1.Columns["cQcProd"].VisibleIndex = i++;
this.gridView1.Columns["cQnProd"].VisibleIndex = i++;
//this.gridView1.Columns["cRemark1"].VisibleIndex = i++;
if (this.mbllShowStock)
{
this.gridView1.Columns["nBalQty"].VisibleIndex = i++;
}
this.gridView1.Columns["nQty"].VisibleIndex = i++;
this.gridView1.Columns["nCost"].VisibleIndex = i++;
this.gridView1.Columns["nAmt"].VisibleIndex = i++;
this.gridView1.Columns["cQnUOM"].VisibleIndex = i++;
this.gridView1.Columns["cProcure"].VisibleIndex = i++;
this.gridView1.Columns["cScrap"].VisibleIndex = i++;
this.gridView1.Columns["nRecNo"].Caption = "No.";
this.gridView1.Columns["cOPSeq"].Caption = "OP. Seq.";
this.gridView1.Columns["cPdType"].Caption = "T";
this.gridView1.Columns["cQcProd"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "รหัสสินค้า", "RM / Product Code" });
this.gridView1.Columns["cQnProd"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "ชื่อสินค้า", "RM / Product Description" });
this.gridView1.Columns["cRemark1"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "หมายเหตุ", "Remark" });
this.gridView1.Columns["nBalQty"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "คงเหลือ", "Stock" });
this.gridView1.Columns["nQty"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "จำนวน", "Qty." });
this.gridView1.Columns["cQnUOM"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "หน่วย", "Unit" });
this.gridView1.Columns["nCost"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "ต้นทุน", "Cost" });
this.gridView1.Columns["nAmt"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "มูลค่า", "Amt." });
this.gridView1.Columns["cScrap"].Caption = "Scrap";
//this.gridView1.Columns["IsMRP"].Caption = "MRP";
//this.gridView1.Columns["IsCost"].Caption = "Cost";
//this.gridView1.Columns["IsOverHead"].Caption = "Over Hd.";
//this.gridView1.Columns["IsIssue"].Caption = "Issue";
this.gridView1.Columns["cProcure"].Caption = "Procure";
//this.gridView1.Columns["cRoundCtrl"].Caption = "Round";
//this.gridView1.Columns["cSubSti"].Caption = "S";
//this.gridView1.Columns["cQcBOM"].Caption = UIBase.GetAppText(App.mLocale_UI, new string[] { "BOM", "BOM" });
this.gridView1.Columns["nRecNo"].Width = 50;
this.gridView1.Columns["cOPSeq"].Width = 80;
this.gridView1.Columns["cPdType"].Width = 50;
this.gridView1.Columns["cQcProd"].Width = 130;
this.gridView1.Columns["cRemark1"].Width = 80;
this.gridView1.Columns["nBalQty"].Width = 80;
this.gridView1.Columns["nQty"].Width = 80;
this.gridView1.Columns["nCost"].Width = 80;
this.gridView1.Columns["cQnUOM"].Width = 80;
this.gridView1.Columns["cScrap"].Width = 80;
this.gridView1.Columns["cProcure"].Width = 60;
this.gridView1.Columns["cRoundCtrl"].Width = 60;
//this.gridView1.Columns["cQcBOM"].Width = 130;
//this.gridView1.Columns["cSubSti"].Width = 5;
WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside);
this.gridView1.Columns["nRecNo"].AppearanceCell.BackColor = System.Drawing.Color.WhiteSmoke;
this.gridView1.Columns["nRecNo"].OptionsColumn.AllowFocus = false;
this.gridView1.Columns["nRecNo"].OptionsColumn.ReadOnly = true;
this.gridView1.Columns["cQnProd"].AppearanceCell.BackColor = System.Drawing.Color.WhiteSmoke;
this.gridView1.Columns["cQnProd"].OptionsColumn.AllowFocus = false;
this.gridView1.Columns["cQnProd"].OptionsColumn.ReadOnly = true;
this.gridView1.Columns["cQnUOM"].AppearanceCell.BackColor = System.Drawing.Color.WhiteSmoke;
this.gridView1.Columns["cQnUOM"].OptionsColumn.AllowFocus = false;
this.gridView1.Columns["cQnUOM"].OptionsColumn.ReadOnly = true;
this.gridView1.Columns["nBalQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView1.Columns["nBalQty"].DisplayFormat.FormatString = "#,###,###,##0.0000";
this.gridView1.Columns["nQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView1.Columns["nQty"].DisplayFormat.FormatString = "#,###,###,##0.0000";
this.gridView1.Columns["nQty"].SummaryItem.DisplayFormat = "{0:#,###,##0.0000;-#,###,##0.0000; }";
this.gridView1.Columns["nQty"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
this.gridView1.Columns["nCost"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView1.Columns["nCost"].DisplayFormat.FormatString = "#,###,###,##0.0000";
this.gridView1.Columns["nCost"].SummaryItem.DisplayFormat = "{0:#,###,##0.0000;-#,###,##0.0000; }";
this.gridView1.Columns["nCost"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
this.gridView1.Columns["nAmt"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView1.Columns["nAmt"].DisplayFormat.FormatString = "#,###,###,##0.0000";
this.gridView1.Columns["nAmt"].SummaryItem.DisplayFormat = "{0:#,###,##0.0000;-#,###,##0.0000; }";
this.gridView1.Columns["nAmt"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
}
