private void initConfig() { lfooT = new List <MaterialDraw>(); matd = new MaterialDraw(); matd.matd_id = "matd_id"; matd.matd_code = "matd_code"; matd.matd_date = "matd_date"; matd.active = "active"; matd.remark = "remark"; matd.sort1 = "sort1"; matd.date_cancel = "date_cancel"; matd.date_create = "date_create"; matd.date_modi = "date_modi"; matd.user_cancel = "user_cancel"; matd.user_create = "user_create"; matd.user_modi = "user_modi"; matd.host_id = "host_id"; matd.branch_id = "branch_id"; matd.device_id = "device_id"; matd.year_id = "year_id"; matd.status_stock_year = "status_stock_year"; matd.status_stock = "status_stock"; matd.pkField = "matd_id"; matd.table = "t_material_draw"; }
public String insert(MaterialDraw p, String userId) { String re = ""; String sql = ""; p.active = "1"; //p.ssdata_id = ""; int chk = 0; chkNull(p); sql = "Insert Into " + matd.table + " set " + " " + matd.matd_code + " = '" + p.matd_code + "'" + "," + matd.matd_date + " = '" + p.matd_date.Replace("'", "''") + "'" + "," + matd.remark + " = '" + p.remark.Replace("'", "''") + "'" + "," + matd.date_create + " = now()" + "," + matd.active + " = '1'" + "," + matd.user_create + " = '" + userId + "' " + "," + matd.host_id + " = '" + p.host_id + "' " + "," + matd.branch_id + " = '" + p.branch_id + "' " + "," + matd.device_id + " = '" + p.device_id + "' " + "," + matd.year_id + " = year(now()) " + "," + matd.status_stock + " = '" + p.status_stock + "' " + "," + matd.status_stock_year + " = '" + p.status_stock_year + "' " + " "; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
public String update(MaterialDraw p, String userId) { String re = ""; String sql = ""; int chk = 0; chkNull(p); sql = "Update " + matd.table + " Set " + " " + matd.matd_code + " = '" + p.matd_code + "'" + "," + matd.matd_date + " = '" + p.matd_date.Replace("'", "''") + "'" + "," + matd.remark + " = '" + p.remark.Replace("'", "''") + "'" + "," + matd.date_modi + " = now()" + "," + matd.user_modi + " = '" + userId + "' " + "," + matd.host_id + " = '" + p.host_id + "' " + "," + matd.branch_id + " = '" + p.branch_id + "' " + "," + matd.device_id + " = '" + p.device_id + "' " + //"," + fooC.status_aircondition + " = '" + p.status_aircondition + "' " + "Where " + matd.pkField + "='" + p.matd_id + "'" ; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
private void initConfig() { fEdit = new Font(mposC.iniC.grdViewFontName, mposC.grdViewFontSize, FontStyle.Regular); fEditB = new Font(mposC.iniC.grdViewFontName, mposC.grdViewFontSize, FontStyle.Bold); stt = new C1SuperTooltip(); sep = new C1SuperErrorProvider(); matd = new MaterialDraw(); //C1ThemeController.ApplicationTheme = mposC.iniC.themeApplication; theme1.Theme = mposC.iniC.themeApplication; theme1.SetTheme(panel2, mposC.iniC.themeApplication); theme1.SetTheme(sB, "BeigeOne"); foreach (Control c in panel2.Controls) { theme1.SetTheme(c, mposC.iniC.themeApplication); } txtMatrDate.Value = System.DateTime.Now.Year + "-" + System.DateTime.Now.ToString("MM-dd"); cboMethod = new C1ComboBox(); cboMethod.AutoCompleteMode = AutoCompleteMode.Suggest; cboMethod.AutoCompleteSource = AutoCompleteSource.ListItems; mposC.mposDB.matDB.setCboMaterial(cboMethod, ""); btnVoid.Hide(); txtPasswordVoid.Hide(); btnSave.Click += BtnSave_Click; chkVoid.CheckedChanged += ChkVoid_CheckedChanged; txtPasswordVoid.KeyUp += TxtPasswordVoid_KeyUp; btnVoid.Click += BtnVoid_Click; btnDoc.Click += BtnDoc_Click; initGrfMatd(); sB1.Text = ""; }
private MaterialDraw setArea1(DataTable dt) { MaterialDraw dept1 = new MaterialDraw(); if (dt.Rows.Count > 0) { dept1.matd_id = dt.Rows[0][matd.matd_id].ToString(); dept1.matd_date = dt.Rows[0][matd.matd_date].ToString(); } return(dept1); }
public MaterialDraw selectByPk1(String copId) { MaterialDraw cop1 = new MaterialDraw(); DataTable dt = new DataTable(); String sql = "select sex.* " + "From " + matd.table + " sex " + //"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " + "Where sex." + matd.pkField + " ='" + copId + "' "; dt = conn.selectData(conn.conn, sql); cop1 = setTMaterial(dt); return(cop1); }
private void setControl() { matd = mposC.mposDB.matdDB.selectByPk1(matd_id); txtMatdId.Value = matd.matd_id; if (matd.matd_date.Length > 0) { txtMatrDate.Value = mposC.datetoShow(matd.matd_date); } txtRemark.Value = matd.remark; txtMatdCode.Value = matd.matd_code; setGrfMatd(); }
public String insertMatrDraw(MaterialDraw p, String userId) { String re = ""; if (p.matd_id.Equals("")) { re = insert(p, ""); } else { re = update(p, ""); } return(re); }
public void getlArea() { //lDept = new List<Position>(); lfooT.Clear(); DataTable dt = new DataTable(); dt = selectAll(); foreach (DataRow row in dt.Rows) { MaterialDraw itm1 = new MaterialDraw(); itm1.matd_id = row[matd.matd_id].ToString(); itm1.matd_date = row[matd.matd_date].ToString(); lfooT.Add(itm1); } }
private MaterialDraw setTMaterial(DataTable dt) { MaterialDraw dept1 = new MaterialDraw(); if (dt.Rows.Count > 0) { dept1.matd_id = dt.Rows[0][matd.matd_id].ToString(); dept1.matd_code = dt.Rows[0][matd.matd_code].ToString(); dept1.matd_date = dt.Rows[0][matd.matd_date].ToString(); //dept1.posi_name_e = dt.Rows[0][area.posi_name_e] != null ? dt.Rows[0][area.posi_name_e].ToString() : ""; //dept1.status_doctor = dt.Rows[0][area.status_doctor] != null ? dt.Rows[0][area.status_doctor].ToString() : ""; dept1.remark = dt.Rows[0][matd.remark] != null ? dt.Rows[0][matd.remark].ToString() : ""; dept1.date_create = dt.Rows[0][matd.date_create] != null ? dt.Rows[0][matd.date_create].ToString() : ""; dept1.date_modi = dt.Rows[0][matd.date_modi] != null ? dt.Rows[0][matd.date_modi].ToString() : ""; dept1.date_cancel = dt.Rows[0][matd.date_cancel] != null ? dt.Rows[0][matd.date_cancel].ToString() : ""; dept1.user_create = dt.Rows[0][matd.user_create] != null ? dt.Rows[0][matd.user_create].ToString() : ""; dept1.user_modi = dt.Rows[0][matd.user_modi] != null ? dt.Rows[0][matd.user_modi].ToString() : ""; dept1.user_cancel = dt.Rows[0][matd.user_cancel] != null ? dt.Rows[0][matd.user_cancel].ToString() : ""; dept1.active = dt.Rows[0][matd.active] != null ? dt.Rows[0][matd.active].ToString() : ""; dept1.status_stock = dt.Rows[0][matd.status_stock] != null ? dt.Rows[0][matd.status_stock].ToString() : ""; dept1.status_stock_year = dt.Rows[0][matd.status_stock_year] != null ? dt.Rows[0][matd.status_stock_year].ToString() : ""; } else { dept1.matd_id = ""; dept1.matd_code = ""; dept1.matd_date = ""; //posi.dept_parent_id = "dept_parent_id"; dept1.remark = ""; dept1.date_create = ""; dept1.date_modi = ""; dept1.date_cancel = ""; dept1.user_create = ""; dept1.user_modi = ""; dept1.user_cancel = ""; dept1.active = ""; dept1.sort1 = ""; dept1.status_stock = ""; dept1.status_stock_year = ""; } return(dept1); }
private void chkNull(MaterialDraw p) { long chk = 0; p.date_modi = p.date_modi == null ? "" : p.date_modi; p.date_cancel = p.date_cancel == null ? "" : p.date_cancel; p.user_create = p.user_create == null ? "" : p.user_create; p.user_modi = p.user_modi == null ? "" : p.user_modi; p.user_cancel = p.user_cancel == null ? "" : p.user_cancel; p.matd_date = p.matd_date == null ? "" : p.matd_date; p.matd_code = p.matd_code == null ? "" : p.matd_code; p.year_id = p.year_id == null ? "" : p.year_id; p.status_stock = p.status_stock == null ? "" : p.status_stock; p.status_stock_year = p.status_stock_year == null ? "" : p.status_stock_year; p.host_id = long.TryParse(p.host_id, out chk) ? chk.ToString() : "0"; p.branch_id = long.TryParse(p.branch_id, out chk) ? chk.ToString() : "0"; p.device_id = long.TryParse(p.device_id, out chk) ? chk.ToString() : "0"; }