public String update(OldPackageHeader p, String userId) { String re = ""; String sql = ""; int chk = 0; p.PackageName = p.PackageName == null ? "" : p.PackageName; p.Price = p.Price == null ? "0" : p.Price; sql = "Update " + oPkg.table + " Set " + " " + oPkg.PackageName + " = '" + p.PackageName.Replace("'", "''") + "' " + "," + oPkg.Price + " = '" + p.Price.Replace(",", "") + "' " + "Where " + oPkg.pkField + "='" + p.PCKID + "'" ; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
private OldPackageHeader setPackageHeader1(OldPackageHeader stf1) { stf1.PCKID = ""; stf1.PackageName = ""; stf1.Price = ""; return(stf1); }
public String insert(OldPackageHeader p, String userId) { String re = ""; String sql = ""; p.active = "1"; //p.ssdata_id = ""; int chk = 0; Decimal chk1 = 0; p.PackageName = p.PackageName == null ? "" : p.PackageName; //p.Price = p.Price == null ? "0" : p.Price; p.Price = Decimal.TryParse(p.Price, out chk1) ? chk1.ToString() : "0"; sql = "Insert Into " + oPkg.table + " Set " + oPkg.PackageName + " = '" + p.PackageName.Replace("'", "''") + "' " + "," + oPkg.Price + " = '" + p.Price + "' " + "," + oPkg.active + " = '1' " + " "; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
private void setControl(String posiId) { oPkg = ic.ivfDB.oPkgDB.selectByPk1(posiId); txtID.Value = oPkg.PCKID; txtPkgName.Value = oPkg.PackageName; txtPkgPrice.Value = oPkg.Price; setGrfPkgD(txtID.Text); }
private void initConfig() { ldtrO = new List <DoctorOld>(); oPkg = new OldPackageHeader(); oPkg.PCKID = "PCKID"; oPkg.PackageName = "PackageName"; oPkg.Price = "Price"; oPkg.active = "active"; oPkg.table = "PackageHeader"; oPkg.pkField = "PCKID"; }
public OldPackageHeader selectByPk1(String copId) { OldPackageHeader stf1 = new OldPackageHeader(); DataTable dt = new DataTable(); String sql = "select oPkg.* " + "From " + oPkg.table + " oPkg " + "Where oPkg." + oPkg.pkField + " ='" + copId + "' "; dt = conn.selectData(conn.conn, sql); stf1 = setPackageHeader(dt); return(stf1); }
public String insertPackageHeader(OldPackageHeader p, String userId) { String re = ""; if (p.PCKID.Equals("")) { re = insert(p, userId); } else { re = update(p, userId); } return(re); }
public OldPackageHeader setPackageHeader(DataTable dt) { OldPackageHeader ostkd1 = new OldPackageHeader(); if (dt.Rows.Count > 0) { ostkd1.PCKID = dt.Rows[0][oPkg.PCKID].ToString(); ostkd1.PackageName = dt.Rows[0][oPkg.PackageName].ToString(); ostkd1.Price = dt.Rows[0][oPkg.Price].ToString(); } else { setPackageHeader1(ostkd1); } return(ostkd1); }
private void initConfig() { fEdit = new Font(ic.iniC.grdViewFontName, ic.grdViewFontSize, FontStyle.Regular); fEditB = new Font(ic.iniC.grdViewFontName, ic.grdViewFontSize, FontStyle.Bold); oPkg = new OldPackageHeader(); btnNew.Click += BtnNew_Click; btnSave.Click += BtnSave_Click; btnEdit.Click += BtnEdit_Click; btnLab.Click += BtnLab_Click; btnSeAdd.Click += BtnSeAdd_Click; btnDrugAdd.Click += BtnDrugAdd_Click; btnCopyFrom.Click += BtnCopyFrom_Click; //cboGrp.SelectedIndexChanged += CboGrp_SelectedIndexChanged; C1ThemeController.ApplicationTheme = ic.iniC.themeApplication; theme1.Theme = C1ThemeController.ApplicationTheme; theme1.SetTheme(sB, "BeigeOne"); foreach (Control c in panel2.Controls) { theme1.SetTheme(c, theme1.Theme); } theme1.SetTheme(panel3, theme1.Theme); foreach (Control c in panel3.Controls) { theme1.SetTheme(c, theme1.Theme); } sB1.Text = ""; stt = new C1SuperTooltip(); sep = new C1SuperErrorProvider(); //ic.setCboPkgGrp(cboGrp); ic.ivfDB.oPkgDB.setCboPackage(cboCopyFrom, ""); initGrfPkg(); initGrfPkgD(); initGrfDrug(); initGrfSe(); initGrfLab(); setGrfPkg(); setGrfLab(); setGrfSe(); setGrfDrug(); }