public override void BtnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (GetGridStatu() == GridStatu.gsAdd) { int mRow = 0; string mNo = XF001.Text; string mSQL = "SELECT XF001 FROM POSXC LEFT JOIN POSXF ON XC001=XF008 WHERE XF001='" + mNo + "'"; while (!ValidMaxNo(mSQL)) { mNo = mNo.Substring(0, 9) + fc.ZeroatFirst((Int32.Parse(mNo.Substring(9, mNo.Length - 9)) + 1), 2); mSQL = "SELECT XF001 FROM POSXC LEFT JOIN POSXF ON XC001=XF008 WHERE XF001='" + mNo + "'"; } XF001.Text = mNo; //單身 for (int i = 0; i < GV_Body.RowCount; i++) { mRow = GV_Body.GetRowHandle(i); GV_Body.SetRowCellValue(mRow, "XG001", XF001.Text); //口味加料子單身 GV_Body.SetMasterRowExpanded(mRow, true); GridView gridViewTests = GV_Body.GetDetailView(mRow, 0) as GridView; if (gridViewTests != null) { for (int j = 0; j < gridViewTests.Columns.Count; j++) { gridViewTests.SetRowCellValue(mRow, "XK001", XF001.Text); } } } } base.BtnSave_ItemClick(sender, e); }
public override void InitUIVar() { f2 = new F2Window(this); TabControlMainHeight = 230; GC_Main.DataSource = pOSXFBindingSource; GC_Body.DataSource = pOSXGBindingSource; MainControls.Add(XF001); MainControls.Add(XF008); KeyFieldMain = "XF001"; KeyFieldBody = "XG001,XG010,XG002"; VisibleFieldMain = "XF005,XF006,XF007"; VisibleFieldBody = "XG001,XB006,XG007,XG008"; OrderFieldMain = "XF001"; OrderFieldBody = "XG001,XG010,XG002"; RequiredFieldMain = "XF008"; RequiredFieldBody = "XG002,XG010"; ReadOnlyFieldBody = "XB007C,XG002C,XB004,XG006C,XG004,XG010"; DateFieldMain.Fields = "XF003,XC008"; TimeFieldMain.Fields = "XF004,XC007"; NumberFieldBody.Fields = "XG004,XG006C"; NumberFieldBody.NumFields.Add("XB004", "n1"); SetGroupSum("XG003", "XG004"); GV_Body.Columns["XG006C"].GroupIndex = 0; ButtonFieldListMain.Add(XF008); ButtonFieldListBody.Add(new ButtonFieldFormat(GCNum.GCN_Body, "", "XG002", this.XG002ButtonEdit_ButtonClick)); ButtonFieldListBody.Add(new ButtonFieldFormat(GCNum.GCN_Body, "", "XB007", this.XB007ButtonEdit_ButtonClick)); ButtonFieldListBody.Add(new ButtonFieldFormat(GCNum.GCN_Body, "", "XG006", this.XG006ButtonEdit_ButtonClick)); ButtonFieldListBody.Add(new ButtonFieldFormat(GCNum.GCN_Body, "", "XG009", this.XG009ButtonEdit_ButtonClick)); VisibleListMain.Add("XF001", 0); VisibleListMain.Add("XF008", 1); VisibleListMain.Add("XC009", 2); VisibleListMain.Add("XF002", 3); VisibleListMain.Add("XF002C", 4); VisibleListMain.Add("XF003", 5); VisibleListMain.Add("XF004", 6); VisibleListMain.Add("XC006", 7); VisibleListMain.Add("XC006C", 8); VisibleListMain.Add("XC008", 9); VisibleListMain.Add("XC007", 10); VisibleListBody.Add("XG010", 0); //序號 VisibleListBody.Add("XB007", 1); //菜色類別 VisibleListBody.Add("XB007C", 2); //類別名稱 VisibleListBody.Add("XG002", 3); //菜色編號 VisibleListBody.Add("XG002C", 4); //菜色名稱 VisibleListBody.Add("XB004", 5); //單價 VisibleListBody.Add("XG003", 6); //數量 VisibleListBody.Add("XG004", 7); //金額 VisibleListBody.Add("XG006", 8); //訂購人 VisibleListBody.Add("XG006C", 9); //名稱 VisibleListBody.Add("XG009", 10); //口味加料 VisibleListBody.Add("XG005", 11); //備註 FieldWidthMain.Add("XF001", 116); FieldWidthMain.Add("XF002", 86); FieldWidthMain.Add("XF003", 98); FieldWidthMain.Add("XF004", 86); FieldWidthMain.Add("XF005", 75); FieldWidthMain.Add("XF006", 75); FieldWidthMain.Add("XF007", 75); FieldWidthMain.Add("XF008", 119); FieldWidthMain.Add("XC006", 70); FieldWidthMain.Add("XC007", 86); FieldWidthMain.Add("XC008", 93); FieldWidthMain.Add("XC009", 86); FieldWidthMain.Add("XF002C", 205); FieldWidthMain.Add("XC006C", 102); FieldWidthBody.Add("XG001", 75); FieldWidthBody.Add("XG002", 86); FieldWidthBody.Add("XG003", 54); FieldWidthBody.Add("XG004", 75); FieldWidthBody.Add("XG005", 473); FieldWidthBody.Add("XG006", 70); FieldWidthBody.Add("XB004", 75); FieldWidthBody.Add("XB006", 75); FieldWidthBody.Add("XB007", 86); FieldWidthBody.Add("XG002C", 172); FieldWidthBody.Add("XB007C", 86); FieldWidthBody.Add("XG007", 75); FieldWidthBody.Add("XG008", 75); FieldWidthBody.Add("XG006C", 75); FieldWidthBody.Add("XG009", 335); FieldWidthBody.Add("XG010", 87); DS_RESAI04.POSXFDataTable dataTable = pOSXFTableAdapter.GetDataBy(""); if (dataTable != null) { for (int i = 0; i < dataTable.Columns.Count - 1; i++) { if (!dataTable.Columns[i].ColumnName.StartsWith("X")) { continue; } SchemaList.Add(dataTable.Columns[i].ColumnName + " " + dataTable.Columns[i].Caption); } } RepositoryItemTextEdit edit = new RepositoryItemTextEdit(); GV_Main.Columns["XC009"].ColumnEdit = edit; edit.DisplayFormat.FormatType = FormatType.Custom; edit.DisplayFormat.FormatString = "XC009"; edit.DisplayFormat.Format = new AI04Formatter(); //body RepositoryItemTextEdit mTextEdit = new RepositoryItemTextEdit(); GV_Body.Columns["XG003"].ColumnEdit = mTextEdit; mTextEdit.EditValueChanging += mTextEdit_EditValueChanging; SelectKeyMain = "XF001"; SelectKeyBody = "XG001"; XF002C.Text = ""; XC006C.Text = ""; XC009.Properties.DisplayMember = "Text"; XC009.Properties.ValueMember = "Value"; var items = new[] { new { Text = "1.早餐", Value = "1" }, new { Text = "2.午餐", Value = "2" }, new { Text = "3.下午茶", Value = "3" }, new { Text = "4.晚餐", Value = "4" } }; XC009.Properties.DataSource = items; base.InitUIVar(); GV_Body.SetMasterRowExpanded(GV_Body.FocusedRowHandle, GV_Body.GetMasterRowExpanded(GV_Body.FocusedRowHandle)); }
private void XG009ButtonEdit_ButtonClick(object sender, ButtonPressedEventArgs e) { if (GetGridStatu() != BaseForm.GridStatu.gsBrowse) { try { GV_Body.UpdateCurrentRow(); f2.SetMI = new string[] { "POSXN", "001" }; f2.SetMIParam = new string[] { XF002.Text, "1", GV_Body.GetFocusedRowCellValue("XB007").ToString(), "2", GV_Body.GetFocusedRowCellValue("XG002").ToString() }; f2.SetShowWindow = false; if (f2.GetMI) { string mXN002 = f2.GetReturn[2]; string mXN003 = f2.GetReturn[3]; double money = 0; double mXB004 = 0; double mQty = 0; string MarkInfo = ""; RESAI04I ai04i = new RESAI04I(); string mXG001 = GV_Body.GetFocusedRowCellValue("XG001").ToString(); string mXG010 = GV_Body.GetFocusedRowCellValue("XG010").ToString(); string mXG002 = GV_Body.GetFocusedRowCellValue("XG002").ToString(); ai04i.DefaultData = new List <string>() { mXG001, mXG010, mXG002, XF002.Text, mXN002, mXN003 }; DataTable dtPOSXK = new DataTable("POSXK"); GridView gridViewTests = null; float mXH004 = 0; for (int i = 0; i < dS_RESAI04.POSXK.Columns.Count; i++) { dtPOSXK.Columns.Add(dS_RESAI04.POSXK.Columns[i].ColumnName, dS_RESAI04.POSXK.Columns[i].DataType); } //if (!GV_Body.IsMasterRowEmpty(GV_Body.FocusedRowHandle)) { GV_Body.SetMasterRowExpanded(GV_Body.FocusedRowHandle, true); gridViewTests = GV_Body.GetDetailView(GV_Body.FocusedRowHandle, 0) as GridView; if (gridViewTests != null) { for (int i = 0; i < gridViewTests.RowCount; i++) { int idx = gridViewTests.GetRowHandle(i); float.TryParse(gridViewTests.GetRowCellValue(idx, "XH004").ToString(), out mXH004); dtPOSXK.Rows.Add(new object[] { "", "", "", "", "", "", 0, "", "", "", "", //}); gridViewTests.GetRowCellValue(idx, "XK001").ToString(), gridViewTests.GetRowCellValue(idx, "XK002").ToString(), gridViewTests.GetRowCellValue(idx, "XK003").ToString(), gridViewTests.GetRowCellValue(idx, "XK004").ToString(), gridViewTests.GetRowCellValue(idx, "XK005").ToString(), gridViewTests.GetRowCellValue(idx, "XK006").ToString(), gridViewTests.GetRowCellValue(idx, "XK006C").ToString(), mXH004 }); } } } ai04i.SetPOSXK = dtPOSXK; if (ai04i.ShowDialog() == DialogResult.OK) { dtPOSXK = ai04i.SetPOSXK; while (gridViewTests.RowCount != 0) { gridViewTests.SelectAll(); gridViewTests.DeleteSelectedRows(); } for (int i = 0; i < dtPOSXK.Rows.Count; i++) { gridViewTests.BeginUpdate(); gridViewTests.AddNewRow(); gridViewTests.SetFocusedRowCellValue("COMPANY", dtPOSXK.Rows[i]["COMPANY"]); gridViewTests.SetFocusedRowCellValue("CREATOR", dtPOSXK.Rows[i]["CREATOR"]); gridViewTests.SetFocusedRowCellValue("USR_GROUP", dtPOSXK.Rows[i]["USR_GROUP"]); gridViewTests.SetFocusedRowCellValue("CREATE_DATE", dtPOSXK.Rows[i]["CREATE_DATE"]); gridViewTests.SetFocusedRowCellValue("MODIFIER", dtPOSXK.Rows[i]["MODIFIER"]); gridViewTests.SetFocusedRowCellValue("MODI_DATE", dtPOSXK.Rows[i]["MODI_DATE"]); gridViewTests.SetFocusedRowCellValue("FLAG", dtPOSXK.Rows[i]["FLAG"]); gridViewTests.SetFocusedRowCellValue("CREATE_TIME", dtPOSXK.Rows[i]["CREATE_TIME"]); gridViewTests.SetFocusedRowCellValue("MODI_TIME", dtPOSXK.Rows[i]["MODI_TIME"]); gridViewTests.SetFocusedRowCellValue("TRANS_TYPE", dtPOSXK.Rows[i]["TRANS_TYPE"]); gridViewTests.SetFocusedRowCellValue("TRANS_NAME", dtPOSXK.Rows[i]["TRANS_NAME"]); gridViewTests.SetFocusedRowCellValue("XK001", dtPOSXK.Rows[i]["XK001"]); gridViewTests.SetFocusedRowCellValue("XK002", dtPOSXK.Rows[i]["XK002"]); gridViewTests.SetFocusedRowCellValue("XK003", dtPOSXK.Rows[i]["XK003"]); gridViewTests.SetFocusedRowCellValue("XK004", dtPOSXK.Rows[i]["XK004"]); gridViewTests.SetFocusedRowCellValue("XK005", dtPOSXK.Rows[i]["XK005"]); gridViewTests.SetFocusedRowCellValue("XK006", dtPOSXK.Rows[i]["XK006"]); gridViewTests.SetFocusedRowCellValue("XK006C", dtPOSXK.Rows[i]["XK006C"]); gridViewTests.SetFocusedRowCellValue("XH004", dtPOSXK.Rows[i]["XH004"]); money += float.Parse(dtPOSXK.Rows[i]["XH004"].ToString()); MarkInfo += dtPOSXK.Rows[i]["XK006C"].ToString() + ","; gridViewTests.EndUpdate(); gridViewTests.UpdateCurrentRow(); } mXB004 = float.Parse(GV_Body.GetFocusedRowCellValue("XB004").ToString()); mQty = float.Parse(GV_Body.GetFocusedRowCellValue("XG003").ToString());; money += mXB004; GV_Body.SetFocusedRowCellValue("XG004", money * mQty); GV_Body.SetFocusedRowCellValue("XG009", MarkInfo); GV_Body.UpdateCurrentRow(); } } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); fc.ErrorLog(ex.Message); } } }