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