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