private void pmSetFormUI()
{
this.lblBranch.Text = UIBase.GetAppUIText(new string[] { "ระบุสาขา :", "Branch Code :" });
this.lblPlant.Text = UIBase.GetAppUIText(new string[] { "ระบุโรงงาน :", "Plant Code :" });
this.lblBook.Text = UIBase.GetAppUIText(new string[] { "ระบุเล่มเอกสาร :", "Book Code :" });
this.lblDate.Text = UIBase.GetAppUIText(new string[] { "ตั้งแต่วันที่ :", "Date between :" });
this.lblToDate.Text = UIBase.GetAppUIText(new string[] { "ถึง ", "To" });
//this.lblRngCode.Text = UIBase.GetAppUIText(new string[] { "เลือกเอกสารรหัสตั้งแต่", "Select #MO Code From :" });
//this.lblRngCode2.Text = UIBase.GetAppUIText(new string[] { "ถึง :", "To :" });
//this.lblRngSect.Text = UIBase.GetAppUIText(new string[] { "เลือกช่วงแผนก", "Select Range Section" });
//this.lblFrSect.Text = UIBase.GetAppUIText(new string[] { "ตั้งแต่ :", "From :" });
//this.lblToSect.Text = UIBase.GetAppUIText(new string[] { "ถึง :", "To :" });
//this.lblRngJob.Text = UIBase.GetAppUIText(new string[] { "เลือกช่วงโครงการ", "Select Range Job" });
//this.lblFrJob.Text = UIBase.GetAppUIText(new string[] { "ตั้งแต่ :", "From :" });
//this.lblToJob.Text = UIBase.GetAppUIText(new string[] { "ถึง :", "To :" });
this.lblRngProd.Text = UIBase.GetAppUIText(new string[] { "เลือกช่วงสินค้า/วัตถุดิบ", "Select Range RM/Product" });
this.lblFrProd.Text = UIBase.GetAppUIText(new string[] { "ตั้งแต่ :", "From :" });
this.lblToProd.Text = UIBase.GetAppUIText(new string[] { "ถึง :", "To :" });
this.lblWhCost.Text = UIBase.GetAppUIText(new string[] { "ใช้ราคาทุนจาก :", "Use Cost from :" });
this.btnPrint.Text = UIBase.GetAppUIText(new string[] { "ตกลง", "OK" });
this.btnCancel.Text = UIBase.GetAppUIText(new string[] { "ยกเลิก", "Cancel" });
}
private void pmInitializeComponent()
{
this.txtQcBranch.Properties.MaxLength = DialogForms.dlgGetBranch.MAXLENGTH_CODE;
this.txtQnBranch.Properties.MaxLength = DialogForms.dlgGetBranch.MAXLENGTH_NAME;
this.txtQcBook.Properties.MaxLength = DialogForms.dlgGetBook.MAXLENGTH_CODE;
this.txtQnBook.Properties.MaxLength = DialogForms.dlgGetBook.MAXLENGTH_NAME;
this.lblBranch.Text = UIBase.GetAppUIText(new string[] { "ÃкØÊÒ¢Ò :", "Branch Code :" });
this.lblBook.Text = UIBase.GetAppUIText(new string[] { "ÃкØàÅèÁàÍ¡ÊÒà :", "Book Code :" });
this.lblDate.Text = UIBase.GetAppUIText(new string[] { "µÑé§áµèÇѹ·Õè :", "Date between :" });
this.lblToDate.Text = UIBase.GetAppUIText(new string[] { "¶Ö§", "To :" });
this.pmDefaultOption();
if (this.mstrRefType == "SR")
{
this.txtQcWkStat.Enabled = false;
this.pnlWorkStation.Visible = true;
this.mbllIsValidateWorkStation = true;
}
else
{
this.mbllIsValidateWorkStation = false;
}
if (App.AppUserName.TrimEnd() == "BIGBOSS")
{
this.txtQcWkStat.Enabled = true;
}
}
private void pmInitGridProp()
{
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["QCPROD"].VisibleIndex = i++;
this.gridView1.Columns["QNPROD"].VisibleIndex = i++;
this.gridView1.Columns["QCCOOR"].VisibleIndex = i++;
this.gridView1.Columns["QNCOOR"].VisibleIndex = i++;
this.gridView1.Columns["FNBACKQTY"].VisibleIndex = i++;
this.gridView1.Columns["QCPROD"].Caption = UIBase.GetAppUIText(new string[] { "รหัสสินค้า", "Product Code" });
this.gridView1.Columns["QNPROD"].Caption = UIBase.GetAppUIText(new string[] { "รหัสสินค้า", "Product Name" });
this.gridView1.Columns["QCCOOR"].Caption = UIBase.GetAppUIText(new string[] { "รหัสลูกค้า", "Customer Code" });
this.gridView1.Columns["QNCOOR"].Caption = UIBase.GetAppUIText(new string[] { "ชื่อลูกค้า", "Customer Name" });
this.gridView1.Columns["FNBACKQTY"].Caption = UIBase.GetAppUIText(new string[] { "จำนวน", "Qty." });
this.gridView1.Columns["QCPROD"].Width = 60;
this.gridView1.Columns["QCCOOR"].Width = 60;
this.gridView1.Columns["QNCOOR"].Width = 80;
this.gridView1.Columns["FNBACKQTY"].Width = 80;
this.gridView1.Columns["FNBACKQTY"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView1.Columns["FNBACKQTY"].DisplayFormat.FormatString = "#,###,###.00";
this.grdBrowView.Focus();
}
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.GetAppUIText(new string[] { "ÃËÑÊ" + this.mstrCoorMsg, this.mstrCoorMsg + " Code" });
this.gridView1.Columns["FCNAME"].Caption = UIBase.GetAppUIText(new string[] { "ª×èÍ" + this.mstrCoorMsg, this.mstrCoorMsg + " Name" });
this.gridView1.Columns["FCSNAME"].Caption = UIBase.GetAppUIText(new string[] { "ª×èÍÂèÍ", "Short Name" });;
this.gridView1.Columns["FCCODE"].Width = 15;
this.gridView1.Columns["FCSNAME"].Width = 30;
this.pmSetSortKey("FCCODE", true);
}
private void pmDeleteData()
{
string strErrorMsg = "";
DataRow dtrBrow = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle);
if (this.gridView1.RowCount == 0 || dtrBrow == null)
{
return;
}
this.mstrEditRowID = dtrBrow["cRowID"].ToString();
string strDeleteDesc = "(" + dtrBrow[QMFResTypeInfo.Field.Code].ToString().TrimEnd() + ") " + dtrBrow[QMFResTypeInfo.Field.Name].ToString().TrimEnd();
if (!this.pmCheckHasUsed(this.mstrEditRowID, dtrBrow[QMFResTypeInfo.Field.Code].ToString(), ref strErrorMsg))
{
if (MessageBox.Show(UIBase.GetAppUIText(new string[] { "ยืนยันการลบข้อมูล", "Do you want to delete " }) + this.mstrFormMenuName + " : " + strDeleteDesc + " ?", "Application confirm message", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
if (this.pmDeleteRow(this.mstrEditRowID, dtrBrow[QMFResTypeInfo.Field.Code].ToString(), dtrBrow[QMFResTypeInfo.Field.Name].ToString(), ref strErrorMsg))
{
this.dtsDataEnv.Tables[this.mstrBrowViewAlias].Rows.RemoveAt(this.pmGetRowID(this.mstrEditRowID));
}
}
}
else
{
if (strErrorMsg != "")
{
MessageBox.Show(strErrorMsg, "Application Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
this.mstrEditRowID = "";
}
private void pmSetFormUI()
{
this.Text = UIBase.GetAppUIText(new string[] { "ÃкبӹǹÊÔ¹¤éÒ áÅР˹èǹѺ", "Specifiy Qty and Unit of Meterial" });
this.lblQty11.Text = UIBase.GetAppUIText(new string[] { "¨Ó¹Ç¹Ë¹èǹѺÁҵðҹ :", "Qty :" });
this.lblQty13.Text = UIBase.GetAppUIText(new string[] { "=", "=" });
this.lblQty21.Text = UIBase.GetAppUIText(new string[] { "¨Ó¹Ç¹Ë¹èǤØÁʵçͤ :", "Stock Qty :" });
this.lblQty23.Text = UIBase.GetAppUIText(new string[] { "=", "=" });
this.txtQty.Properties.EditMask = App.ActiveCorp.QtyFormatString;
this.txtQty.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.txtQty.Properties.DisplayFormat.FormatString = App.ActiveCorp.QtyFormatString;
this.txtUMQty.Properties.EditMask = App.ActiveCorp.QtyFormatString;
this.txtUMQty.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.txtUMQty.Properties.DisplayFormat.FormatString = App.ActiveCorp.QtyFormatString;
this.txtStQty.Properties.EditMask = App.ActiveCorp.QtyFormatString;
this.txtStQty.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.txtStQty.Properties.DisplayFormat.FormatString = App.ActiveCorp.QtyFormatString;
this.txtStUMQty.Properties.EditMask = App.ActiveCorp.QtyFormatString;
this.txtStUMQty.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.txtStUMQty.Properties.DisplayFormat.FormatString = App.ActiveCorp.QtyFormatString;
}
private void pmInitGridProp()
{
System.Data.DataView dvBrow = this.dtsDataEnv.Tables[this.mstrBrowViewAlias].DefaultView;
dvBrow.Sort = this.mstrSortKey;
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["CSTEP"].Caption = UIBase.GetAppUIText(new string[] { "STEP", "STEP" });
this.gridView1.Columns["CCODE"].Caption = UIBase.GetAppUIText(new string[] { "เลขที่ภายใน", "DOC. CODE" });
this.gridView1.Columns["CREFNO"].Caption = UIBase.GetAppUIText(new string[] { "เลขที่อ้างอิง", "Ref. No." });
this.gridView1.Columns["DDATE"].Caption = UIBase.GetAppUIText(new string[] { "วันที่", "Date" });
this.gridView1.Columns["DDATE"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView1.Columns["DDATE"].DisplayFormat.FormatString = "dd/MM/yy";
this.gridView1.Columns["CSTEP"].Width = 15;
this.gridView1.Columns["CCODE"].Width = 30;
this.gridView1.Columns["DDATE"].Width = 30;
int i = 0;
this.gridView1.Columns["CSTEP"].VisibleIndex = i++;
this.gridView1.Columns["CCODE"].VisibleIndex = i++;
this.gridView1.Columns["CREFNO"].VisibleIndex = i++;
this.gridView1.Columns["DDATE"].VisibleIndex = i++;
this.pmSetSortKey(this.mstrSortKey, true);
}
private void pmSetFormUI()
{
this.lblPlant.Text = UIBase.GetAppUIText(new string[] { "ระบุโรงงาน :", "Plant Code :" });
this.lblBook.Text = UIBase.GetAppUIText(new string[] { "ระบุเล่มเอกสาร :", "Book Code :" });
this.lblCode.Text = UIBase.GetAppUIText(new string[] { "เลขที่เอกสาร :", "Doc. Code :" });
this.lblRefNo.Text = UIBase.GetAppUIText(new string[] { "เลขที่อ้างอิง :", "Ref No. :" });
}
private bool pmValidOption()
{
bool bllResult = false;
string strErrorMsg = "";
if (this.txtQcBranch.Text.Trim() == "")
{
strErrorMsg = UIBase.GetAppUIText(new string[] { "ยังไม่ได้ระบุสาขา !", "Branch Code is not define !" });
this.txtQcBranch.Focus();
}
else if (this.txtQcBook.Text.Trim() == "")
{
strErrorMsg = UIBase.GetAppUIText(new string[] { "ยังไม่ได้ระบุเล่มเอกสาร !", "Book Code is not define !" });
this.txtQcBook.Focus();
}
else if (this.txtQcCoor.Text.Trim() == "")
{
strErrorMsg = UIBase.GetAppUIText(new string[] { "ยังไม่ได้ระบุผู้จำหน่าย !", "Supplier Code is not define !" });
this.txtQcCoor.Focus();
}
else
{
bllResult = true;
}
if (strErrorMsg != string.Empty)
{
MessageBox.Show(strErrorMsg, "Application Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
return(bllResult);
}
private void pmSetFormUI()
{
//this.Text = UIBase.GetAppUIText(new string[] { "เพิ่ม/แก้ไข" + this.mstrFormMenuName, this.mstrFormMenuName + " ENTRY" });
//this.lblBook.Text = string.Format("{0} :", new string[] { UIBase.GetAppUIText(new string[] { "ระบุเล่มเอกสาร", "Book Code" }) });
this.lblCoor.Text = string.Format("{0} :", new string[] { UIBase.GetAppUIText(new string[] { "สินค้า", "Product" }) });
//this.lblTitle1.Text = UIBase.GetAppUIText(new string[] { "รายการสินค้าตาม P/O", "Product Items from P/O" });
}
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.dlgGetFMBook_KeyDown);
this.mstrBOOKMsg = UIBase.GetAppUIText(new string[] { "เล่มเอกสาร", "Book" });
}
private void pmInitGridProp()
{
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].AppearanceCell.BackColor = System.Drawing.Color.WhiteSmoke;
this.gridView1.Columns[intCnt].OptionsColumn.AllowFocus = false;
this.gridView1.Columns[intCnt].OptionsColumn.ReadOnly = true;
}
int i = 0;
this.gridView1.Columns["nRecNo"].VisibleIndex = i++;
this.gridView1.Columns["fcCode"].VisibleIndex = i++;
this.gridView1.Columns["fcRefNo"].VisibleIndex = i++;
this.gridView1.Columns["fdDate"].VisibleIndex = i++;
this.gridView1.Columns["QcProd"].VisibleIndex = i++;
this.gridView1.Columns["QnProd"].VisibleIndex = i++;
this.gridView1.Columns["fnBackQty"].VisibleIndex = i++;
//this.gridView1.Columns["fnMOQty"].VisibleIndex = i++;
this.gridView1.Columns["fnMOQty"].AppearanceCell.BackColor = System.Drawing.Color.White;
this.gridView1.Columns["fnMOQty"].OptionsColumn.AllowFocus = true;
this.gridView1.Columns["fnMOQty"].OptionsColumn.ReadOnly = false;
this.gridView1.Columns["nRecNo"].Caption = UIBase.GetAppUIText(new string[] { "No.", "No." });
this.gridView1.Columns["fcCode"].Caption = UIBase.GetAppUIText(new string[] { "เลขที่ภายใน", "Doc. Code" });
this.gridView1.Columns["fcRefNo"].Caption = UIBase.GetAppUIText(new string[] { "เลขที่อ้างอิง", "Ref. No" });
this.gridView1.Columns["fdDate"].Caption = UIBase.GetAppUIText(new string[] { "วันที่", "Doc. Date" });
this.gridView1.Columns["fnBackQty"].Caption = UIBase.GetAppUIText(new string[] { "P/O Qty", "P/O Qty" });
//this.gridView1.Columns["fnMOQty"].Caption = UIBase.GetAppUIText(new string[] { "M/O Qty", "M/O Qty" });
this.gridView1.Columns["QcProd"].Caption = UIBase.GetAppUIText(new string[] { "รหัสสินค้า", "Prod. Code" });
this.gridView1.Columns["QnProd"].Caption = UIBase.GetAppUIText(new string[] { "ชื่อสินค้า", "Prod. Name" });
this.gridView1.Columns["nRecNo"].Width = 35;
this.gridView1.Columns["fcCode"].Width = 85;
this.gridView1.Columns["fcRefNo"].Width = 120;
this.gridView1.Columns["fdDate"].Width = 85;
this.gridView1.Columns["fnBackQty"].Width = 80;
//this.gridView1.Columns["fnMOQty"].Width = 80;
this.gridView1.Columns["fnBackQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView1.Columns["fnBackQty"].DisplayFormat.FormatString = "#,###,###.00";
this.gridView1.Columns["fnMOQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView1.Columns["fnMOQty"].DisplayFormat.FormatString = "#,###,###.00";
this.gridView1.Columns["fdDate"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView1.Columns["fdDate"].DisplayFormat.FormatString = "dd/MM/yy";
this.gridView1.Columns["fnMOQty"].ColumnEdit = this.grcQty;
//this.pmCalcColWidth();
this.grdTemPd.Focus();
}
private void pmSetFormUI()
{
//this.Text = UIBase.GetAppUIText(new string[] { "เพิ่ม/แก้ไข" + this.mstrFormMenuName, this.mstrFormMenuName + " ENTRY" });
this.lblBook.Text = string.Format("{0} :", new string[] { UIBase.GetAppUIText(new string[] { "ระบุเล่มเอกสาร", "Book Code" }) });
this.lblCoor.Text = string.Format("{0} :", new string[] { UIBase.GetAppUIText(new string[] { "ลูกค้า", "Customer" }) });
this.lblProd.Text = string.Format("{0} :", new string[] { UIBase.GetAppUIText(new string[] { "สินค้า", "Product" }) });
this.lblTotMfgQty.Text = string.Format("{0} :", new string[] { UIBase.GetAppUIText(new string[] { "รวมจำนวนที่สั่งผลิต", "Total Qty." }) });
this.lblTitle1.Text = UIBase.GetAppUIText(new string[] { "รายการสินค้าตาม S/O", "Product Items from S/O" });
}
public dlgPRange()
{
InitializeComponent();
this.lblTitle.Text = UIBase.GetAppUIText(new string[] { "ระบุช่วงในการพิมพ์ข้อมูล", "Select Document to print" });
this.lblCode.Text = UIBase.GetAppUIText(new string[] { "ตั้งแต่ :", "From :" });
this.lblToCode.Text = UIBase.GetAppUIText(new string[] { "ถึง :", "To :" });
UIBase.SetDefaultChildAppreance(this);
}
private void pmSetFormUI()
{
this.lblPlant.Text = UIBase.GetAppUIText(new string[] { "ระบุโรงงาน :", "Plant Code :" });
this.lblDate.Text = UIBase.GetAppUIText(new string[] { "ประจำปี :", "Year :" });
this.lblHoliday.Text = UIBase.GetAppUIText(new string[] { "ระบุข้อมูลวันหยุดประจำปี :", "Select Holiday and NoworkingDay :" });
this.lblStdWorkHr.Text = UIBase.GetAppUIText(new string[] { "ระบุข้อมูลเวลาทำงานมาตรฐาน :", "Select Stadard Work Hour :" });
this.btnOK.Text = UIBase.GetAppUIText(new string[] { "ตกลง", "OK" });
this.btnCancel.Text = UIBase.GetAppUIText(new string[] { "ยกเลิก", "Cancel" });
}
private void btnPrint_Click(object sender, EventArgs e)
{
//WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
//KeepLogAgent.KeepLog(objSQLHelper, KeepLogType.Print, this.mstrTaskName, "", "", App.FMAppUserID, App.AppUserName);
this.pmClrOldData();
this.pmGenTem();
this.pmSaveData();
//MessageBox.Show("OK");
MessageBox.Show(this, UIBase.GetAppUIText(new string[] { "ประมวลผลเสร็จเรียบร้อย", "Generate Complete" }), "Application confirm message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void pmSetFormUI()
{
//this.Text = UIBase.GetAppUIText(new string[] { "เพิ่ม/แก้ไข" + this.mstrFormMenuName, this.mstrFormMenuName + " ENTRY" });
//this.lblTitle1.Text = UIBase.GetAppUIText(new string[] { "ขั้นตอนที่ 1 : ระบุสินค้าที่จะดึงไปผลิต", "Step 1 : Select Product Items from S/O" });
//this.lblTitle2.Text = UIBase.GetAppUIText(new string[] { "ขั้นตอนที่ 2 :ระบุเอกสาร " + mstrRefType + " ที่จะดึงไปผลิต", "Step 2 : Select S/O for Production" });
string strCoorMsg = (mstrRefType == "SO" ? UIBase.GetAppUIText(new string[] { "ลูกค้า", "Customer" }) : UIBase.GetAppUIText(new string[] { "ผู้จำหน่าย", "Supplier" }));
//this.lblCoor.Text = string.Format("{0} :", new string[] { strCoorMsg });
//this.lblProd.Text = string.Format("{0} :", new string[] { UIBase.GetAppUIText(new string[] { "สินค้า", "Product" }) });
//this.lblTotMfgQty.Text = string.Format("{0} :", new string[] { UIBase.GetAppUIText(new string[] { "รวมจำนวนที่สั่งผลิต", "Total Qty." }) });
}
private void pmInitGridProp2()
{
//System.Data.DataView dvBrow = this.dtsDataEnv.Tables[this.mstrAlias].DefaultView;
//dvBrow.Sort = "dDate, cRefNo";
this.grdTemPd.DataSource = this.dtsDataEnv.Tables[this.mstrBrowViewAlias2];
for (int intCnt = 0; intCnt < this.gridView2.Columns.Count; intCnt++)
{
this.gridView2.Columns[intCnt].Visible = false;
this.gridView2.Columns[intCnt].OptionsColumn.AllowEdit = false;
}
int i = 0;
this.gridView2.Columns["CTAGVALUE"].VisibleIndex = i++;
this.gridView2.Columns["FCCODE"].VisibleIndex = i++;
this.gridView2.Columns["FCREFNO"].VisibleIndex = i++;
this.gridView2.Columns["FDDATE"].VisibleIndex = i++;
this.gridView2.Columns["QCPROD"].VisibleIndex = i++;
this.gridView2.Columns["QNPROD"].VisibleIndex = i++;
this.gridView2.Columns["FNBACKQTY"].VisibleIndex = i++;
this.gridView2.Columns["CTAGVALUE"].Caption = " ";
this.gridView2.Columns["FCCODE"].Caption = UIBase.GetAppUIText(new string[] { "เลขที่ภายใน", "Doc. Code" });
this.gridView2.Columns["FCREFNO"].Caption = UIBase.GetAppUIText(new string[] { "เลขที่อ้างอิง", "Ref. No" });
this.gridView2.Columns["FDDATE"].Caption = UIBase.GetAppUIText(new string[] { "วันที่", "Doc. Date" });
this.gridView2.Columns["FNBACKQTY"].Caption = UIBase.GetAppUIText(new string[] { "จำนวน", "Qty." });
this.gridView2.Columns["QCPROD"].Caption = UIBase.GetAppUIText(new string[] { "รหัสสินค้า", "Prod. Code" });
this.gridView2.Columns["QNPROD"].Caption = UIBase.GetAppUIText(new string[] { "ชื่อสินค้า", "Prod. Name" });
this.gridView2.Columns["CTAGVALUE"].OptionsColumn.AllowSort = DefaultBoolean.False;
this.gridView2.Columns["CTAGVALUE"].ImageIndex = 0;
this.gridView2.Columns["CTAGVALUE"].ImageAlignment = StringAlignment.Center;
this.gridView2.Columns["CTAGVALUE"].OptionsColumn.AllowEdit = true;
this.gridView2.OptionsView.ColumnAutoWidth = false;
this.gridView2.Columns["CTAGVALUE"].Width = 40;
this.gridView2.Columns["FCCODE"].Width = 85;
this.gridView2.Columns["FCREFNO"].Width = 85;
this.gridView2.Columns["FDDATE"].Width = 85;
this.gridView2.Columns["FNBACKQTY"].Width = 80;
this.gridView2.Columns["FNBACKQTY"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView2.Columns["FNBACKQTY"].DisplayFormat.FormatString = "#,###,###.00";
this.gridView2.Columns["FDDATE"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView2.Columns["FDDATE"].DisplayFormat.FormatString = "dd/MM/yy";
this.pmCalcColWidth();
this.gridView2.Columns["CTAGVALUE"].ColumnEdit = this.chkTag;
this.grdTemPd.Focus();
}
private bool pmValidBeforeSave(ref string ioErrorMsg)
{
bool bllResult = true;
string strMsg = "";
if (this.txtCode.Text.TrimEnd() == string.Empty)
{
strMsg = UIBase.GetAppUIText(new string[] {
"ยังไม่ได้ระบุ " + this.mstrFormMenuName + " Code ต้องการให้เครื่อง Running ให้หรือไม่ ?"
, this.mstrFormMenuName + " Code is not define ! " + "Do you want to Auto Running Code ?"
});
if (MessageBox.Show(strMsg, "Application confirm message", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question) == DialogResult.Yes)
{
this.pmRunCode();
}
}
if (this.txtCode.Text.TrimEnd() == string.Empty)
{
ioErrorMsg = UIBase.GetAppUIText(new string[] { "ยังไม่ได้ระบุ " + this.mstrFormMenuName + " Code", this.mstrFormMenuName + " Code is not define ! " });
this.txtCode.Focus();
return(false);
}
else if (this.txtName.Text.Trim() == string.Empty)
{
ioErrorMsg = UIBase.GetAppUIText(new string[] { "ยังไม่ได้ระบุ " + this.mstrFormMenuName + " Code", this.mstrFormMenuName + " Name is not define ! " });
this.txtName.Focus();
return(false);
}
else if ((this.mFormEditMode == UIHelper.AppFormState.Insert || this.mstrOldCode.TrimEnd() != this.txtCode.Text.TrimEnd()) &&
!this.pmIsValidateCode(new object[] { App.ActiveCorp.RowID, this.txtCode.Text.TrimEnd() }))
{
ioErrorMsg = UIBase.GetAppUIText(new string[] { "รหัส " + this.mstrFormMenuName + " ซ้ำ", "Duplicate " + this.mstrFormMenuName + " Code !" });
this.txtCode.Focus();
return(false);
}
//else if ((this.mFormEditMode == UIHelper.AppFormState.Insert || this.mstrOldName.TrimEnd() != this.txtName.Text.TrimEnd())
// && !this.pmIsValidateName(new object[] { App.ActiveCorp.RowID , this.txtName.Text.TrimEnd() }))
//{
// ioErrorMsg = "ชื่อโรงงานซ้ำ";
// this.txtName.Focus();
// return false;
//}
else
{
bllResult = true;
}
return(bllResult);
}
private void pmInitForm()
{
this.txtQcBranch.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(txtPopUp_ButtonClick);
this.txtQcBranch.KeyDown += new KeyEventHandler(txtPopUp_KeyDown);
this.txtQcBranch.Validating += new CancelEventHandler(txtQcBranch_Validating);
this.txtQcWHouse.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(txtPopUp_ButtonClick);
this.txtQcWHouse.KeyDown += new KeyEventHandler(txtPopUp_KeyDown);
this.txtQcWHouse.Validating += new CancelEventHandler(txtQcWHouse_Validating);
this.txtQcBook.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(txtPopUp_ButtonClick);
this.txtQcBook.KeyDown += new KeyEventHandler(txtPopUp_KeyDown);
this.txtQcBook.Validating += new CancelEventHandler(txtQcMfgBook_Validating);
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside);
WS.Data.Agents.cDBMSAgent objSQLHelper2 = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
this.txtQcBook.Properties.MaxLength = MapTable.GetMaxLength(objSQLHelper2, QMfgBookInfo.TableName, QMfgBookInfo.Field.Code);
this.txtQnBook.Properties.MaxLength = MapTable.GetMaxLength(objSQLHelper2, QMfgBookInfo.TableName, QMfgBookInfo.Field.Name);
this.btnOK.Click += new EventHandler(btnOK_Click);
this.txtQcBook.Tag = "";
this.txtQcBook.Text = "";
this.txtQnBook.Text = "";
int intYear = DateTime.Now.Year;
string strErrorMsg = "";
objSQLHelper.SetPara(new object[] { App.ActiveCorp.RowID });
if (objSQLHelper.SQLExec(ref this.dtsDataEnv, "QBranch", "BRANCH", "select fcSkid, fcCode, fcName from BRANCH where FCCORP = ? order by FCCODE", ref strErrorMsg))
{
DataRow dtrBranch = this.dtsDataEnv.Tables["QBranch"].Rows[0];
this.txtQcBranch.Tag = dtrBranch["fcSkid"].ToString();
this.txtQcBranch.Text = dtrBranch["fcCode"].ToString().TrimEnd();
this.txtQnBranch.Text = dtrBranch["fcName"].ToString().TrimEnd();
}
this.pmDefaultBook();
this.txtBegDate.DateTime = DateTime.Now;
this.lblTitle.Text = UIBase.GetAppUIText(new string[] { "ระบุ Option การสร้างใบเบิก", "Gen Finish Good Recieve Option" });
this.lblBranch.Text = UIBase.GetAppUIText(new string[] { "ระบุสาขา :", "Branch Code :" });
this.lblWHouse.Text = UIBase.GetAppUIText(new string[] { "ระบุคลังสินค้า :", "Warehouse Code :" });
this.lblBook.Text = UIBase.GetAppUIText(new string[] { "ระบุเล่มเอกสาร :", "Book Code :" });
this.lblLot.Text = UIBase.GetAppUIText(new string[] { "ระบุ LOT :", "LOT :" });
this.lblDate.Text = UIBase.GetAppUIText(new string[] { "วันที่เอกสาร :", "Document Date :" });
UIBase.SetDefaultChildAppreance(this);
}
private void gridView1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
DataRow dtrBrow = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle);
if (dtrBrow != null)
{
this.txtFooter.Text = UIBase.GetAppUIText(new string[] { "สร้างโดย LOGIN : "******"Create By LOGIN : "******"CLOGIN_ADD"].ToString().TrimEnd() + UIBase.GetAppUIText(new string[] { "วันที่/เวลา : ", " Date/Time : " }) + Convert.ToDateTime(dtrBrow["dCreate"]).ToString("dd/MM/yy hh:mm:ss");
this.txtFooter.Text += UIBase.GetAppUIText(new string[] { "\r\nแก้ไขล่าสุดโดย LOGIN : "******"\r\nLast update by LOGIN : "******"CLOGIN_UPD"].ToString().TrimEnd() + UIBase.GetAppUIText(new string[] { "วันที่/เวลา : ", " Date/Time : " }) + Convert.ToDateTime(dtrBrow["dLastUpdBy"]).ToString("dd/MM/yy hh:mm:ss");
}
else
{
this.txtFooter.Text = "";
}
}
private string pmGetPOption()
{
string strResult = "";
strResult += this.txtQcBranch.Text.TrimEnd() + " : " + this.txtQnBranch.Text.TrimEnd() + "|";
strResult += this.cmbIsDetail.Text.TrimEnd() + "|";
strResult += this.txtBegDate.DateTime.ToString("dd/MM/yy") + UIBase.GetAppUIText(new string[] { " ถึง ", " to " }) + this.txtEndDate.DateTime.ToString("dd/MM/yy") + "|";
strResult += this.txtBegQcProd.Text.TrimEnd() + " : " + this.txtBegQnProd.Text.TrimEnd()
+ UIBase.GetAppUIText(new string[] { " ถึง ", " to " }) + this.txtBegQcProd.Text.TrimEnd() + " : " + this.txtEndQnProd.Text.TrimEnd() + "|";
//strResult += this.cmbWHCost.Text.TrimEnd() + "|";
return(strResult);
}
private void pmInitGridProp_TemOTHour()
{
System.Data.DataView dvBrow = this.dtsDataEnv.Tables[this.mstrTemOTHour].DefaultView;
this.grdTemOTHour.DataSource = this.dtsDataEnv.Tables[this.mstrTemOTHour];
for (int intCnt = 0; intCnt < this.gridView3.Columns.Count; intCnt++)
{
this.gridView3.Columns[intCnt].Visible = false;
}
int i = 0;
this.gridView3.Columns["nRecNo"].VisibleIndex = i++;
//this.gridView3.Columns["cDay"].VisibleIndex = i++;
this.gridView3.Columns["dBegTime"].VisibleIndex = i++;
this.gridView3.Columns["dEndTime"].VisibleIndex = i++;
this.gridView3.Columns["nTotHour"].VisibleIndex = i++;
this.gridView3.Columns["nRecNo"].Caption = "No.";
this.gridView3.Columns["dBegTime"].Caption = UIBase.GetAppUIText(new string[] { "ตั้งแต่", "Start" });
this.gridView3.Columns["dEndTime"].Caption = UIBase.GetAppUIText(new string[] { "ถึง", "End" });
this.gridView3.Columns["nTotHour"].Caption = UIBase.GetAppUIText(new string[] { "ชม.", "Hour" });
this.gridView3.Columns["nRecNo"].Width = 30;
this.gridView3.Columns["dBegTime"].Width = 80;
this.gridView3.Columns["dEndTime"].Width = 80;
WS.Data.Agents.cDBMSAgent pobjSQLUtil = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
//this.gridView3.Columns["nRecNo"].AppearanceCell.Options. = DevExpress.Utils.HorzAlignment.Far;
this.gridView3.Columns["nRecNo"].AppearanceCell.BackColor = System.Drawing.Color.WhiteSmoke;
this.gridView3.Columns["nRecNo"].OptionsColumn.AllowFocus = false;
this.gridView3.Columns["nRecNo"].OptionsColumn.ReadOnly = true;
this.gridView3.Columns["nTotHour"].AppearanceCell.BackColor = System.Drawing.Color.WhiteSmoke;
this.gridView3.Columns["nTotHour"].OptionsColumn.AllowFocus = false;
this.gridView3.Columns["nTotHour"].OptionsColumn.ReadOnly = true;
this.gridView3.Columns["nTotHour"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView3.Columns["nTotHour"].DisplayFormat.FormatString = "{0:#,###,##0.0;-#,###,##0.0; }";
this.gridView3.Columns["dBegTime"].ColumnEdit = this.grcBegTime;
this.gridView3.Columns["dEndTime"].ColumnEdit = this.grcEndTime;
this.gridView3.Columns["nTotHour"].SummaryItem.DisplayFormat = "{0:#,###,##0.0000;-#,###,##0.0000; }";
this.gridView3.Columns["nTotHour"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
//this.pmCalcColWidth();
}
private void pmSetFormUI()
{
//this.Text = UIBase.GetAppUIText(new string[] { "เพิ่ม/แก้ไข" + this.mstrFormMenuName, this.mstrFormMenuName + " ENTRY" });
this.lblBook.Text = string.Format("{0} :", new string[] { UIBase.GetAppUIText(new string[] { "ระบุเล่มเอกสาร", "Book Code" }) });
this.lblCoor.Text = string.Format("{0} :", new string[] { UIBase.GetAppUIText(new string[] { "ลูกค้า", "Customer" }) });
if (this.mstrReferKey == "SO")
{
this.lblTitle1.Text = UIBase.GetAppUIText(new string[] { "รายการสินค้าตาม S/O", "Product Items from S/O" });
}
else
{
this.lblTitle1.Text = UIBase.GetAppUIText(new string[] { "รายการสินค้าตาม P/O", "Product Items from P/O" });
}
}
private void pmInitGridProp()
{
//this.grdBrowView.SetDataBinding(this.dtsDataEnv.Tables[this.mstrAlias], "");
//this.grdBrowView.RetrieveStructure();
System.Data.DataView dvBrow = this.dtsDataEnv.Tables[this.mstrAlias].DefaultView;
//dvBrow.Sort = "dDate, cRefNo";
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["cFrOPSeq"].VisibleIndex = i++;
this.gridView1.Columns["cQcFrMOPR"].VisibleIndex = i++;
this.gridView1.Columns["cQnFrMOPR"].VisibleIndex = i++;
//this.gridView1.Columns["cQnFrWkCtr"].VisibleIndex = i++;
this.gridView1.Columns["cToOPSeq"].VisibleIndex = i++;
this.gridView1.Columns["cQnToMOPR"].VisibleIndex = i++;
//this.gridView1.Columns["cQnToWkCtr"].VisibleIndex = i++;
this.gridView1.Columns["cFrOPSeq"].Caption = UIBase.GetAppUIText(new string[] { "OP Seq.", "OP Seq." });
this.gridView1.Columns["cQcFrMOPR"].Caption = UIBase.GetAppUIText(new string[] { "รหัส OPR", "OPR Code" });
this.gridView1.Columns["cQnFrMOPR"].Caption = UIBase.GetAppUIText(new string[] { "ชื่อ OPR", "OPR Name" });
this.gridView1.Columns["cQnFrWkCtr"].Caption = UIBase.GetAppUIText(new string[] { "โอนจาก W/C", "From W/C" });
this.gridView1.Columns["cToOPSeq"].Caption = UIBase.GetAppUIText(new string[] { "Next OP.", "Next OP.." });
this.gridView1.Columns["cQnToMOPR"].Caption = UIBase.GetAppUIText(new string[] { "ชื่อ OPR", "OPR Name" });
this.gridView1.Columns["cQnToWkCtr"].Caption = UIBase.GetAppUIText(new string[] { "โอนเข้า W/C", "To W/C" });
//this.gridView1.Columns["cType"].Width = 60;
//this.gridView1.Columns["dDate"].Width = 40;
//this.gridView1.Columns["cQcBank"].Width = 60;
//this.gridView1.Columns["cCode"].Width = 60;
//this.gridView1.Columns["nAmt"].Width = 50;
//this.gridView1.Columns["nAmt"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
//this.gridView1.Columns["nAmt"].DisplayFormat.FormatString = "#,###,###.00";
//this.gridView1.Columns["dDate"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
//this.gridView1.Columns["dDate"].DisplayFormat.FormatString = "dd/MM/yy";
this.grdBrowView.Focus();
}
private void pmSetFormUI()
{
this.lblBranch.Text = UIBase.GetAppUIText(new string[] { "ระบุสาขา :", "Branch Code :" });
this.lblPlant.Text = UIBase.GetAppUIText(new string[] { "ระบุโรงงาน :", "Plant Code :" });
this.lblBook.Text = UIBase.GetAppUIText(new string[] { "ระบุเล่มเอกสาร :", "Book Code :" });
this.lblDate.Text = UIBase.GetAppUIText(new string[] { "ตั้งแต่วันที่ :", "Date between :" });
this.lblToDate.Text = UIBase.GetAppUIText(new string[] { "ถึง", "To :" });
this.lblPOption1.Text = UIBase.GetAppUIText(new string[] { "พิมพ์ SO Step ? :", "Print SO Step ? :" });
this.lblRngProd.Text = UIBase.GetAppUIText(new string[] { "เลือกช่วงสินค้า/วัตถุดิบ", "Select Range RM/Product" });
this.lblFrProd.Text = UIBase.GetAppUIText(new string[] { "ตั้งแต่ :", "From :" });
this.lblToProd.Text = UIBase.GetAppUIText(new string[] { "ถึง :", "To :" });
this.lblRngCode.Text = UIBase.GetAppUIText(new string[] { "เลือกเอกสารรหัสตั้งแต่", "Select #MO Code From :" });
this.lblRngCode2.Text = UIBase.GetAppUIText(new string[] { "ถึง :", "To :" });
this.btnPrint.Text = UIBase.GetAppUIText(new string[] { "ตกลง", "OK" });
this.btnCancel.Text = UIBase.GetAppUIText(new string[] { "ยกเลิก", "Cancel" });
}
private void pmInitGridProp()
{
System.Data.DataView dvBrow = this.dtsDataEnv.Tables[this.mstrAlias].DefaultView;
//dvBrow.Sort = "dDate, cRefNo";
this.grdBrowView.DataSource = this.dtsDataEnv.Tables[this.mstrAlias];
for (int intCnt = 0; intCnt < this.gridView1.Columns.Count; intCnt++)
{
this.gridView1.Columns[intCnt].Visible = false;
}
this.gridView1.Columns["cRefType"].Group();
int i = 0;
this.gridView1.Columns["cRefType"].VisibleIndex = i++;
this.gridView1.Columns["dDate"].VisibleIndex = i++;
this.gridView1.Columns["cCode"].VisibleIndex = i++;
this.gridView1.Columns["cRefNo"].VisibleIndex = i++;
this.gridView1.Columns["cRefType"].Caption = " ";
this.gridView1.Columns["dDate"].Caption = UIBase.GetAppUIText(new string[] { "วันที่เอกสาร", "DOC. DATE" });
this.gridView1.Columns["cCode"].Caption = UIBase.GetAppUIText(new string[] { "เลขที่ภายใน", "DOC. CODE" });
this.gridView1.Columns["cRefNo"].Caption = UIBase.GetAppUIText(new string[] { "เลขที่อ้างอิง", "REF. CODE" });
this.gridView1.Columns["cRefType"].Width = 60;
this.gridView1.Columns["dDate"].Width = 40;
this.gridView1.Columns["cCode"].Width = 60;
this.gridView1.Columns["cRefNo"].Width = 50;
this.gridView1.Columns["dDate"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView1.Columns["dDate"].DisplayFormat.FormatString = "dd/MM/yy";
//this.gridView1.SortKeys.Add(new Janus.Windows.GridEX.GridEXSortKey(this.gridView1.Columns["dDate"], Janus.Windows.GridEX.SortOrder.Ascending));
//this.gridView1.SortKeys.Add(new Janus.Windows.GridEX.GridEXSortKey(this.gridView1.Columns["cRefNo"], Janus.Windows.GridEX.SortOrder.Ascending));
////this.gridView1.Columns[this.mstrSortKey].CellStyle.BackColor = Color.WhiteSmoke;
//this.gridView1.GroupSummary.Add(DevExpress.Data.SummaryItemType.Sum, "nAmt", this.gridView1.Columns["nAmt"], "{0:n2}");
this.grdBrowView.Focus();
this.gridView1.ExpandAllGroups();
}
private void pmInitForm()
{
this.cmbOrderBy.SelectedIndexChanged += new EventHandler(cmbOrderBy_SelectedIndexChanged);
this.txtBegDoc.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(txtPopUp_ButtonClick);
this.txtBegDoc.KeyDown += new KeyEventHandler(txtPopUp_KeyDown);
this.txtBegDoc.Validating += new CancelEventHandler(txtBegDoc_Validating);
this.txtEndDoc.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(txtPopUp_ButtonClick);
this.txtEndDoc.KeyDown += new KeyEventHandler(txtPopUp_KeyDown);
this.txtEndDoc.Validating += new CancelEventHandler(txtBegDoc_Validating);
WS.Data.Agents.cDBMSAgent objSQLHelper = new WS.Data.Agents.cDBMSAgent(App.ERPConnectionString, App.DatabaseReside);
WS.Data.Agents.cDBMSAgent objSQLHelper2 = new WS.Data.Agents.cDBMSAgent(App.ConnectionString, App.DatabaseReside);
int intYear = DateTime.Now.Year;
string strErrorMsg = "";
this.txtMOBegDate.DateTime = DateTime.Now;
this.txtMOEndDate.DateTime = DateTime.Now;
this.lblTitle.Text = UIBase.GetAppUIText(new string[] { "ระบุ Option การสร้าง ตารางการผลิต", "Select Generate Planning Option" });
this.cmbOrderBy.Properties.Items.Clear();
this.cmbOrderBy.Properties.Items.AddRange(new object[] {
UIBase.GetAppUIText(new string[] { "ช่วงวันที่", "By Date" })
, UIBase.GetAppUIText(new string[] { "ช่วงเลขที่", "By MO Code" })
});
this.cmbOrderBy.SelectedIndex = 0;
this.lblRng.Text = UIBase.GetAppUIText(new string[] { "เลือกสร้างเอกสารตาม :", "Generate P/R Order :" });
this.lblRngDate_MO.Text = UIBase.GetAppUIText(new string[] { "ระบุช่วงวันที่เอกสาร MO", "Specify range MO date" });
this.lblRngDate_Beg.Text = UIBase.GetAppUIText(new string[] { "ตั้งแต่วันที่ :", "From Date :" });
this.lblRngDate_End.Text = UIBase.GetAppUIText(new string[] { "ถึง :", "To :" });
this.lblRngDoc_MO.Text = UIBase.GetAppUIText(new string[] { "ระบุช่วงเลขที่เอกสาร MO", "Specify range MO Code" });
this.lblRngDoc_Beg.Text = UIBase.GetAppUIText(new string[] { "ตั้งแต่เลขที่ :", "From Code :" });
this.lblRngDoc_End.Text = UIBase.GetAppUIText(new string[] { "ถึง :", "To :" });
UIBase.SetDefaultChildAppreance(this);
}
private void pmInitGridProp()
{
this.grdTemPack.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].AppearanceCell.BackColor = System.Drawing.Color.WhiteSmoke;
//this.gridView1.Columns[intCnt].OptionsColumn.AllowFocus = false;
//this.gridView1.Columns[intCnt].OptionsColumn.ReadOnly = true;
}
int i = 0;
this.gridView1.Columns["nRecNo"].VisibleIndex = i++;
this.gridView1.Columns["cQcPackStyle"].VisibleIndex = i++;
this.gridView1.Columns["cQnPackStyle"].VisibleIndex = i++;
this.gridView1.Columns["nPackSize"].VisibleIndex = i++;
this.gridView1.Columns["cShowPack"].VisibleIndex = i++;
//this.gridView1.Columns["fnMOQty"].VisibleIndex = i++;
this.gridView1.Columns["nRecNo"].Caption = UIBase.GetAppUIText(new string[] { "No.", "No." });
this.gridView1.Columns["cQcPackStyle"].Caption = UIBase.GetAppUIText(new string[] { "Pack Code", "Pack Code" });
this.gridView1.Columns["cQnPackStyle"].Caption = UIBase.GetAppUIText(new string[] { "Pack Name", "Pack Name" });
this.gridView1.Columns["nPackSize"].Caption = UIBase.GetAppUIText(new string[] { "Pack Size", "Pack Size" });
this.gridView1.Columns["cShowPack"].Caption = UIBase.GetAppUIText(new string[] { "Pack Detail", "Pack Detail" });
this.gridView1.Columns["nRecNo"].Width = 35;
this.gridView1.Columns["cQcPackStyle"].Width = 85;
this.gridView1.Columns["cQnPackStyle"].Width = 120;
this.gridView1.Columns["nPackSize"].Width = 85;
this.gridView1.Columns["cShowPack"].Width = 85;
this.gridView1.Columns["nPackSize"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView1.Columns["nPackSize"].DisplayFormat.FormatString = "#,###,###.00";
this.gridView1.Columns["cQcPackStyle"].ColumnEdit = this.grcQcPack;
this.gridView1.Columns["cQnPackStyle"].ColumnEdit = this.grcQcPack;
this.gridView1.Columns["cShowPack"].ColumnEdit = this.grcShowPack;
//this.pmCalcColWidth();
this.grdTemPack.Focus();
}
private void pmInitGridProp()
{
this.grdTemPack.DataSource = this.dtsDataEnv.Tables["TemRefTo_Pack_Det"];
for (int intCnt = 0; intCnt < this.gridView1.Columns.Count; intCnt++)
{
this.gridView1.Columns[intCnt].Visible = false;
//this.gridView1.Columns[intCnt].AppearanceCell.BackColor = System.Drawing.Color.WhiteSmoke;
//this.gridView1.Columns[intCnt].OptionsColumn.AllowFocus = false;
//this.gridView1.Columns[intCnt].OptionsColumn.ReadOnly = true;
}
int i = 0;
this.gridView1.Columns["nRecNo"].VisibleIndex = i++;
this.gridView1.Columns["cPackCode"].VisibleIndex = i++;
this.gridView1.Columns["cLot"].VisibleIndex = i++;
this.gridView1.Columns["nQty"].VisibleIndex = i++;
this.gridView1.Columns["nPackQty"].VisibleIndex = i++;
this.gridView1.Columns["nRecNo"].Caption = UIBase.GetAppUIText(new string[] { "No.", "No." });
this.gridView1.Columns["cPackCode"].Caption = UIBase.GetAppUIText(new string[] { "Storage Code", "Storage Code" });
this.gridView1.Columns["cLot"].Caption = UIBase.GetAppUIText(new string[] { "Lot", "Lot" });
this.gridView1.Columns["nQty"].Caption = UIBase.GetAppUIText(new string[] { "Qty", "Qty" });
this.gridView1.Columns["nPackQty"].Caption = UIBase.GetAppUIText(new string[] { "Storage Qty", "Storage Qty" });
this.gridView1.Columns["nRecNo"].Width = 35;
this.gridView1.Columns["cPackCode"].Width = 120;
this.gridView1.Columns["cLot"].Width = 85;
this.gridView1.Columns["nQty"].Width = 85;
this.gridView1.Columns["nPackQty"].Width = 85;
this.gridView1.Columns["nQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView1.Columns["nQty"].DisplayFormat.FormatString = "#,###,###.00";
this.gridView1.Columns["nPackQty"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Custom;
this.gridView1.Columns["nPackQty"].DisplayFormat.FormatString = "#,###,###.00";
//this.pmCalcColWidth();
this.grdTemPack.Focus();
}
