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