private void XN002_EditValueChanging(object sender, ChangingEventArgs e)
{
if (e.NewValue.ToString() == "")
{
e.Cancel = false;
return;
}
if (e.NewValue == e.OldValue)
{
e.Cancel = true;
return;
}
else
{
if (MessageBox.Show("切換種類將會清除單身已建資料!\r\n是否確定?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
e.Cancel = false;
XN003.Text = "";
XN003C.Text = "";
while (GV_Body.RowCount > 0)
{
GV_Body.SelectAll();
GV_Body.DeleteSelectedRows();
}
}
else
{
e.Cancel = true;
}
}
}
public override void GC_Body_MouseDown(object sender, MouseEventArgs e)
{
GridHitInfo hitInfo = GV_Body.CalcHitInfo(e.Location);
if (hitInfo == null || hitInfo.Column == null)
{
return;
}
if (GetGridStatu() == GridStatu.gsEdit)
{
if (hitInfo.InRowCell)
{
if (hitInfo.Column.RealColumnEdit is RepositoryItemCheckEdit)
{
GV_Body.FocusedColumn = hitInfo.Column;
GV_Body.FocusedRowHandle = hitInfo.RowHandle;
GV_Body.ShowEditor();
CheckEdit edit = GV_Body.ActiveEditor as CheckEdit;
if (edit == null)
{
return;
}
edit.Toggle();
DXMouseEventArgs.GetMouseArgs(e).Handled = true;
GV_Body.CloseEditor();
}
}
}
}
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);
}
private void XO004ButtonEdit_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (GetGridStatu() != BaseForm.GridStatu.gsBrowse)
{
string mType = GV_Body.GetFocusedRowCellValue("XO004").ToString();
f2.SetMI = new string[] { "POSXH", "001" };
f2.SetMIParam = new string[] { mType };
f2.SetMuity = true;
Dictionary <int, List <string> > muity = null;
if (f2.GetMI)
{
muity = f2.GetMuity;
bool IsExist = false;
bool IsFirst = true;
foreach (KeyValuePair <int, List <string> > s in muity)
{
for (int i = 0; i < GV_Body.RowCount; i++)
{
if ((GV_Body.GetRowCellValue(i, "XO005") == null))
{
IsExist = false;
break;
}
if (GV_Body.GetRowCellValue(i, "XO005").ToString() == s.Value[0])
{
if (GV_Body.GetRowCellValue(i, "XO004").ToString() == mType)
{
IsExist = true;
break;
}
}
}
if (IsExist)
{
IsExist = false;
continue;
}
else
{
if (IsFirst)
{
IsFirst = false;
}
else
{
GV_Body.AddNewRow();
}
GV_Body.SetFocusedRowCellValue("XO001", XN001.Text);
GV_Body.SetFocusedRowCellValue("XO002", XN002.EditValue);
GV_Body.SetFocusedRowCellValue("XO003", XN003.Text);
GV_Body.SetFocusedRowCellValue("XO004", mType);
GV_Body.SetFocusedRowCellValue("XO005", s.Value[0]);
GV_Body.SetFocusedRowCellValue("XO005C", s.Value[1]);
GV_Body.UpdateCurrentRow();
}
}
}
}
}
public override void GV_Body_InitNewRow(object sender, InitNewRowEventArgs e)
{
base.GV_Body_InitNewRow(sender, e);
GV_Body.SetFocusedRowCellValue("XO001", XN001.EditValue);
GV_Body.SetFocusedRowCellValue("XO002", XN002.EditValue);
GV_Body.SetFocusedRowCellValue("XO003", XN003.EditValue);
GV_Body.SetFocusedRowCellValue("XO004", "1");
GV_Body.FocusedColumn = GV_Body.Columns["XO005"];
GV_Body.ShowEditor();
}
public override void GV_Body_InitNewRow(object sender, InitNewRowEventArgs e)
{
base.GV_Body_InitNewRow(sender, e);
GV_Body.SetFocusedRowCellValue("XB001", XA001.Text);
GV_Body.SetFocusedRowCellValue("XB002", string.Format("{0:0000}", GV_Body.RowCount));
GV_Body.SetFocusedRowCellValue("XB006", XA002.Text);
GV_Body.UpdateCurrentRow();
GV_Body.FocusedColumn = GV_Body.Columns["XB007"];
GV_Body.ShowEditor();
}
public override void GC_Body_MouseClick(object sender, MouseEventArgs e)
{
base.GC_Body_MouseClick(sender, e);
if (IsCheckRequired)
{
if (GV_Body.RowCount == 0)
{
GV_Body.AddNewRow();
}
}
}
public override void GV_Body_InitNewRow(object sender, DevExpress.XtraGrid.Views.Grid.InitNewRowEventArgs e)
{
base.GV_Body_InitNewRow(sender, e);
GV_Body.PostEditor();
//int index = Int32.Parse(GV_Body.GetRowCellValue(FocuseRow_Body, "XL002").ToString()) + 1;
int index = GV_Body.RowCount;
GV_Body.FocusedColumn = GV_Body.Columns["XL002"]; //定位焦点网格的位置
FocuseRow_Body = GV_Body.FocusedRowHandle; //获取新焦点行的FocuseRowHandle并初始化全局变量
GV_Body.SetRowCellValue(FocuseRow_Body, "XL001", XI001.Text);
GV_Body.SetRowCellValue(FocuseRow_Body, "XL002", string.Format("{0:0000}", index));
}
private void XB002ButtonEdit_ButtonClick(object sender, ButtonPressedEventArgs e)
{
if (GetGridStatu() != BaseForm.GridStatu.gsBrowse)
{
f2.SetMI = new string[] { "POSXL", "001" };
f2.SetMIParam = new string[] { XA002.Text };
if (f2.GetMI)
{
GV_Body.SetRowCellValue(FocuseRow_Body, "XB007", f2.GetReturn[0]);
GV_Body.SetRowCellValue(FocuseRow_Body, "XB007C", f2.GetReturn[1]);
}
}
}
public override void GV_Body_KeyDown(object sender, KeyEventArgs e)
{
base.GV_Body_KeyDown(sender, e);
GV_Body.PostEditor();
if (e.KeyData == Keys.Down && IsKeyDownOK)
{
ColumnView view = (ColumnView)GC_Body.FocusedView;
if (view.IsLastRow)
{
GV_Body.AddNewRow();
}
}
}
private void XG006ButtonEdit_ButtonClick(object sender, ButtonPressedEventArgs e)
{
if (GetGridStatu() == BaseForm.GridStatu.gsBrowse)
{
return;
}
f2.SetMI = new string[] { "POSXC", "002" };
if (f2.GetMI)
{
GV_Body.SetRowCellValue(FocuseRow_Body, "XG006", f2.GetReturn[0]);
GV_Body.SetRowCellValue(FocuseRow_Body, "XG006C", f2.GetReturn[1]);
}
}
void mTextEdit_EditValueChanging(object sender, ChangingEventArgs e)
{
if (GetGridStatu() != BaseForm.GridStatu.gsBrowse)
{
float mPrice = 0;
float mCount = 0;
float mSale = 0;
mPrice = float.Parse(GV_Body.GetFocusedRowCellValue("XB004").ToString());
mCount = float.Parse(e.NewValue.ToString());
mSale = mPrice * mCount;
GV_Body.SetFocusedRowCellValue("XG004", mSale);
}
}
private void GetSPValue(List <List <string> > ls)
{
if (XF008.Text != "" && XF002.Text != "")
{
if (ls != null)
{
for (int j = 0; j < ls.Count; j++)
{
for (int i = 0; i < GV_Body.RowCount; i++)
{
if (GV_Body.GetRowCellValue(i, "XB007") != null && GV_Body.GetRowCellValue(i, "XG002") != null)
{
if (ls[j][1] == GV_Body.GetRowCellValue(i, "XB007").ToString() &&
ls[j][3] == GV_Body.GetRowCellValue(i, "XG002").ToString())
{
ls[j][0] = "F";
}
}
}
}
for (int j = 0; j < ls.Count; j++)
{
if (ls[j][0] == "T")
{
if (GV_Body.GetFocusedRowCellValue("XG002") == null)
{
GV_Body.AddNewRow();
}
else
{
if (GV_Body.GetFocusedRowCellValue("XG002").ToString().Trim() != "")
{
GV_Body.AddNewRow();
}
}
GV_Body.SetFocusedRowCellValue("XG001", XF001.Text);
GV_Body.SetFocusedRowCellValue("XB007", ls[j][1]);
GV_Body.SetFocusedRowCellValue("XB007C", ls[j][2]);
GV_Body.SetFocusedRowCellValue("XG002", ls[j][3]);
GV_Body.SetFocusedRowCellValue("XG002C", ls[j][4]);
GV_Body.SetFocusedRowCellValue("XG006", fc.FUser.ID);
GV_Body.SetFocusedRowCellValue("XG006C", fc.FUser.Name);
GV_Body.SetFocusedRowCellValue("XB004", ls[j][5]);
GV_Body.SetFocusedRowCellValue("XG004", ls[j][5]);
}
}
GV_Body.PostEditor();
GV_Body.FocusedRowHandle = GV_Body.RowCount;
}
}
}
private void XB007ButtonEdit_ButtonClick(object sender, ButtonPressedEventArgs e)
{
if (GetGridStatu() == BaseForm.GridStatu.gsBrowse)
{
return;
}
f2.SetMI = new string[] { "POSXG", "001" };
f2.SetMIParam = new string[] { XF002.Text };
if (f2.GetMI)
{
GV_Body.SetRowCellValue(FocuseRow_Body, "XB007", f2.GetReturn[0]);
GV_Body.SetRowCellValue(FocuseRow_Body, "XB007C", f2.GetReturn[1]);
GV_Body.FocusedColumn = GV_Body.VisibleColumns[2];//菜單編號
GV_Body.ShowEditor();
}
}
public override void BtnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (GetGridStatu() == GridStatu.gsAdd)
{
int mRow = 0;
string mNo = XA001.Text;
string mSQL = "SELECT XA001 FROM POSXA WHERE XA001='" + mNo + "'";
while (!ValidMaxNo(mSQL))
{
mNo = "R" + fc.ZeroatFirst((Int32.Parse(mNo.Substring(1, mNo.Length - 1)) + 1), 4); //R0000
mSQL = "SELECT XA001 FROM POSXA WHERE XA001='" + mNo + "'";
}
XA001.Text = mNo;
for (int i = 0; i < GV_Body.RowCount; i++)
{
mRow = GV_Body.GetRowHandle(i);
GV_Body.SetRowCellValue(mRow, "XB001", XA001.Text);
}
}
base.BtnSave_ItemClick(sender, e);
if (FImage != null)
{
using (SqlConnection conn = new SqlConnection(fc.makeConnectString(fc.FDBInfo)))
{
conn.Open();
try
{
string SQL = "UPDATE POSXA SET XA010=@XA010 WHERE XA001='" + XA001.Text + "'";
SqlCommand cmd = new SqlCommand(SQL, conn);
byte[] buffer = fc.ImageToBuffer(FImage, System.Drawing.Imaging.ImageFormat.Jpeg);
cmd.Parameters.AddWithValue("@XA010", buffer);
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
fc.ErrorLog(ex.Message);
conn.Close();
}
}
StorePic.Image = FImage;
}
}
private void CheckMoney()
{
if (rg01.SelectedIndex == 0)
{
GV_Body.ActiveFilterEnabled = false;
GV_Body.ActiveFilterString = "[XG007] = 'N'";
GV_Body.ActiveFilterEnabled = true;
}
else if (rg01.SelectedIndex == 1)
{
GV_Body.ActiveFilterEnabled = false;
GV_Body.ActiveFilterString = "[XG008] > 0";
GV_Body.ActiveFilterEnabled = true;
}
else if (rg01.SelectedIndex == 2)
{
GV_Body.ActiveFilterEnabled = false;
GV_Body.ActiveFilterString = "";
GV_Body.ActiveFilterEnabled = true;
}
float mSale = 0;
float mSale2 = 0;
float mSale3 = 0;
for (int i = 0; i < GV_Body.RowCount; i++)
{
if (GV_Body.GetRowCellValue(i, "XG004") != null)
{
mSale += float.Parse(GV_Body.GetRowCellValue(i, "XG004").ToString());
if (GV_Body.GetRowCellValue(i, "XG007").ToString() == "Y")
{
mSale2 += float.Parse(GV_Body.GetRowCellValue(i, "XG004").ToString());
}
else if (GV_Body.GetRowCellValue(i, "XG007").ToString() == "N")
{
mSale3 += float.Parse(GV_Body.GetRowCellValue(i, "XG004").ToString());
}
}
}
edMoney1.Text = mSale.ToString();
edMoney2.Text = mSale2.ToString();
//edMoney3.Text = (mSale - mSale2).ToString();
edMoney3.Text = mSale3.ToString();
}
/*public override void GC_Body_MouseClick(object sender, MouseEventArgs e)
* {
* base.GC_Body_MouseClick(sender, e);
* if (IsCheckRequired)
* {
* if (GV_Body.RowCount == 0)
* {
* GV_Body.AddNewRow();
* GV_Body.SetRowCellValue(FocuseRow_Body, "XL001", XI001.Text);
* GV_Body.SetRowCellValue(FocuseRow_Body, "XL002", "0001");
* }
* }
* }*/
public override void BtnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (GetGridStatu() == GridStatu.gsAdd)
{
string mNo = XI001.Text;
string mSQL = "SELECT XI001 FROM POSXI WHERE XI001='" + mNo + "'";
while (!ValidMaxNo(mSQL))
{
mNo = "K" + fc.ZeroatFirst((Int32.Parse(mNo.Substring(1, mNo.Length - 1)) + 1), 3); //K000
mSQL = "SELECT XI001 FROM POSXI WHERE XI001='" + mNo + "'";
}
XI001.Text = mNo;
for (int i = 0; i < GV_Body.RowCount; i++)
{
GV_Body.SetRowCellValue(i, "XL001", XI001.Text);
}
}
base.BtnSave_ItemClick(sender, e);
}
private void XG002ButtonEdit_ButtonClick(object sender, ButtonPressedEventArgs e)
{
if (GetGridStatu() != BaseForm.GridStatu.gsBrowse)
{
string mXB007 = GV_Body.GetRowCellValue(FocuseRow_Body, "XB007").ToString();
f2.SetMI = new string[] { "POSXG", "002" };
f2.SetMIParam = new string[] { XF002.Text, mXB007 };
if (f2.GetMI)
{
GV_Body.SetRowCellValue(FocuseRow_Body, "XG002", f2.GetReturn[0]);
GV_Body.SetRowCellValue(FocuseRow_Body, "XG002C", f2.GetReturn[1]);
GV_Body.SetRowCellValue(FocuseRow_Body, "XB004", f2.GetReturn[2]);
float mPrice = float.Parse(f2.GetReturn[2]);
float mQty = float.Parse(GV_Body.GetRowCellValue(FocuseRow_Body, "XG003").ToString());
GV_Body.SetRowCellValue(FocuseRow_Body, "XG004", mPrice * mQty);
GV_Body.FocusedColumn = GV_Body.VisibleColumns[9];//數量
GV_Body.ShowEditor();
}
}
}
public override void GV_Body_InitNewRow(object sender, InitNewRowEventArgs e)
{
base.GV_Body_InitNewRow(sender, e);
ColumnView newview = (ColumnView)GC_Body.FocusedView;
newview.FocusedColumn = newview.Columns["XB007"];
FocuseRow_Body = newview.FocusedRowHandle;
newview.ShowEditor();
int idx = 0;
for (int i = 0; i < GV_Body.RowCount; i++)
{
int mRow = GV_Body.GetRowHandle(i);
if (GV_Body.IsMasterRow(mRow))
{
idx++;
}
}
GV_Body.SetFocusedRowCellValue("XG001", XF001.Text);
GV_Body.SetFocusedRowCellValue("XG002", "");
GV_Body.SetFocusedRowCellValue("XG006", fc.FUser.ID);
GV_Body.SetFocusedRowCellValue("XG006C", fc.FUser.Name);
GV_Body.SetFocusedRowCellValue("XG010", string.Format("{0:0000}", idx));
}
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);
}
}
}
public override void GV_Body_KeyDown(object sender, KeyEventArgs e)
{
base.GV_Body_KeyDown(sender, e);
GV_Body.PostEditor();
}
