private void initConfig()
{
fEdit = new Font(mposC.iniC.grdViewFontName, mposC.grdViewFontSize + 5, FontStyle.Regular);
fEditB = new Font(mposC.iniC.grdViewFontName, mposC.grdViewFontSize, FontStyle.Bold);
fEdit1 = new Font(mposC.iniC.grdViewFontName, mposC.grdViewFontSize + 5, FontStyle.Regular + 2);
fgrd = new Font(mposC.iniC.grdViewFontName, mposC.grdViewFontSize + 15, FontStyle.Regular);
ford = new Font(mposC.iniC.grdViewFontName, mposC.grdViewFontSize, FontStyle.Regular);
picPlus.Click += PicPlus_Click;
picMinus.Click += PicMinus_Click;
picDesc.Click += PicDesc_Click;
picDel.Click += PicDel_Click;
flagExplan = false;
sizeNormal = this.Size;
foo = new Foods();
foos = new FoodsSpecial();
hei1 = pnCri1.Height;
hei2 = pnCri2.Height;
hei3 = pnCri3.Height;
hei4 = pnCri4.Height;
heiselect = pnSelect.Height;
setControl();
PicDesc_Click(null, null);
}
public String update(FoodsSpecial p, String userId)
{
String re = "";
String sql = "";
int chk = 0;
chkNull(p);
sql = "Update " + foos.table + " Set " +
" " + foos.foods_id + " = '" + p.foods_id + "'" +
"," + foos.foods_spec_name + " = '" + p.foods_spec_name.Replace("'", "''") + "'" +
"," + foos.remark + " = '" + p.remark.Replace("'", "''") + "'" +
"," + foos.date_modi + " = now()" +
"," + foos.user_modi + " = '" + userId + "' " +
"," + foos.host_id + " = '" + p.host_id + "' " +
"," + foos.branch_id + " = '" + p.branch_id + "' " +
"," + foos.device_id + " = '" + p.device_id + "' " +
//"," + foos.status_aircondition + " = '" + p.status_aircondition + "' " +
"Where " + foos.pkField + "='" + p.foods_spec_id + "'"
;
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
public String insert(FoodsSpecial p, String userId)
{
String re = "";
String sql = "";
p.active = "1";
//p.ssdata_id = "";
int chk = 0;
chkNull(p);
sql = "Insert Into " + foos.table + " set " +
" " + foos.foods_id + " = '" + p.foods_id + "'" +
"," + foos.foods_spec_name + " = '" + p.foods_spec_name.Replace("'", "''") + "'" +
"," + foos.remark + " = '" + p.remark.Replace("'", "''") + "'" +
"," + foos.date_create + " = now()" +
"," + foos.active + " = '1'" +
"," + foos.user_create + " = '" + userId + "' " +
"," + foos.host_id + " = '" + p.host_id + "' " +
"," + foos.branch_id + " = '" + p.branch_id + "' " +
"," + foos.device_id + " = '" + p.device_id + "' " +
//"," + foos.status_aircondition + " = '" + p.status_aircondition + "' " +
" ";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
private FoodsSpecial setArea1(DataTable dt)
{
FoodsSpecial dept1 = new FoodsSpecial();
if (dt.Rows.Count > 0)
{
dept1.foods_spec_id = dt.Rows[0][foos.foods_spec_id].ToString();
dept1.foods_spec_name = dt.Rows[0][foos.foods_spec_name].ToString();
}
return(dept1);
}
private void initConfig()
{
fEdit = new Font(mposC.iniC.grdViewFontName, mposC.grdViewFontSize + 5, FontStyle.Regular);
fEditB = new Font(mposC.iniC.grdViewFontName, mposC.grdViewFontSize, FontStyle.Bold);
fEdit1 = new Font(mposC.iniC.grdViewFontName, mposC.grdViewFontSize + 5, FontStyle.Regular + 2);
fgrd = new Font(mposC.iniC.grdViewFontName, mposC.grdViewFontSize + 15, FontStyle.Regular);
ford = new Font(mposC.iniC.grdViewFontName, mposC.grdViewFontSize, FontStyle.Regular);
pnHead.BackColor = ColorTranslator.FromHtml(mposC.iniC.ucOrderTakeOutpnHeadBackColor);
lbRow.BackColor = ColorTranslator.FromHtml(mposC.iniC.ucOrderTakeOutpnHeadBackColor);
lbName.BackColor = ColorTranslator.FromHtml(mposC.iniC.ucOrderTakeOutpnHeadBackColor);
lbPrice.BackColor = ColorTranslator.FromHtml(mposC.iniC.ucOrderTakeOutpnHeadBackColor);
panel1.BackColor = ColorTranslator.FromHtml(mposC.iniC.ucOrderTakeOutpnHeadBackColor);
//lbName.BackColor = ColorTranslator.FromHtml(mposC.iniC.ucOrderTakeOutpnHeadBackColor);
if (mposC.iniC.ucOrderTakeOutBorderStyle.Equals("0"))
{
this.BorderStyle = BorderStyle.None;
}
else if (mposC.iniC.ucOrderTakeOutBorderStyle.Equals("1"))
{
this.BorderStyle = BorderStyle.FixedSingle;
}
else if (mposC.iniC.ucOrderTakeOutBorderStyle.Equals("1"))
{
this.BorderStyle = BorderStyle.Fixed3D;
}
picPlus.Click += PicPlus_Click;
picMinus.Click += PicMinus_Click;
picDesc.Click += PicDesc_Click;
picDel.Click += PicDel_Click;
picDesc.Click += PicDesc_Click1;
picTogo.Click += PicTogo_Click;
flagExplan = false;
sizeNormal = this.Size;
foo = new Foods();
foos = new FoodsSpecial();
tpl = new TableLayoutPanel();
initTlp();
setControl();
sizeNormal = this.Size;
statusTogo = false;
//if (!mposC.statusApplicationTogo) // seat in
//{
// picTogo.Hide();
//}
picTogo.Visible = mposC.statusApplicationTogo ? false : true;
statusTogo = mposC.statusApplicationTogo;
setStatusToGo();
//PicDesc_Click(null, null);
}
public FoodsSpecial selectByPk1(String copId)
{
FoodsSpecial cop1 = new FoodsSpecial();
DataTable dt = new DataTable();
String sql = "select sex.* " +
"From " + foos.table + " sex " +
//"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " +
"Where sex." + foos.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
cop1 = setFoodsSpecial(dt);
return(cop1);
}
public String insertFoodsSpecial(FoodsSpecial p, String userId)
{
String re = "";
if (p.foods_spec_id.Equals(""))
{
re = insert(p, "");
}
else
{
re = update(p, "");
}
return(re);
}
public void getlArea()
{
//lDept = new List<Position>();
lfooC.Clear();
DataTable dt = new DataTable();
dt = selectAll();
foreach (DataRow row in dt.Rows)
{
FoodsSpecial itm1 = new FoodsSpecial();
itm1.foods_spec_id = row[foos.foods_spec_id].ToString();
itm1.foods_spec_name = row[foos.foods_spec_name].ToString();
lfooC.Add(itm1);
}
}
public List <FoodsSpecial> getlFooSpecByFooId(String fooid)
{
//lDept = new List<Position>();
List <FoodsSpecial> lfooC1 = new List <FoodsSpecial>();
DataTable dt = new DataTable();
dt = selectByFoodsId2(fooid);
foreach (DataRow row in dt.Rows)
{
FoodsSpecial itm1 = new FoodsSpecial();
itm1.foods_spec_id = row[foos.foods_spec_id].ToString();
itm1.foods_spec_name = row[foos.foods_spec_name].ToString();
itm1.foods_id = row[foos.foods_id].ToString();
lfooC1.Add(itm1);
}
return(lfooC1);
}
private FoodsSpecial setFoodsSpecial(DataTable dt)
{
FoodsSpecial dept1 = new FoodsSpecial();
if (dt.Rows.Count > 0)
{
dept1.foods_spec_id = dt.Rows[0][foos.foods_spec_id].ToString();
dept1.foods_id = dt.Rows[0][foos.foods_id].ToString();
dept1.foods_spec_name = dt.Rows[0][foos.foods_spec_name].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][foos.remark] != null ? dt.Rows[0][foos.remark].ToString() : "";
dept1.date_create = dt.Rows[0][foos.date_create] != null ? dt.Rows[0][foos.date_create].ToString() : "";
dept1.date_modi = dt.Rows[0][foos.date_modi] != null ? dt.Rows[0][foos.date_modi].ToString() : "";
dept1.date_cancel = dt.Rows[0][foos.date_cancel] != null ? dt.Rows[0][foos.date_cancel].ToString() : "";
dept1.user_create = dt.Rows[0][foos.user_create] != null ? dt.Rows[0][foos.user_create].ToString() : "";
dept1.user_modi = dt.Rows[0][foos.user_modi] != null ? dt.Rows[0][foos.user_modi].ToString() : "";
dept1.user_cancel = dt.Rows[0][foos.user_cancel] != null ? dt.Rows[0][foos.user_cancel].ToString() : "";
dept1.active = dt.Rows[0][foos.active] != null ? dt.Rows[0][foos.active].ToString() : "";
dept1.sort1 = dt.Rows[0][foos.sort1] != null ? dt.Rows[0][foos.sort1].ToString() : "";
//dept1.status_aircondition = dt.Rows[0][foos.status_aircondition] != null ? dt.Rows[0][foos.status_aircondition].ToString() : "";
}
else
{
dept1.foods_spec_id = "";
dept1.foods_id = "";
dept1.foods_spec_name = "";
//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_aircondition = "";
//dept1.status_embryologist = "";
}
return(dept1);
}
private void chkNull(FoodsSpecial 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.host_id = p.host_id == null ? "" : p.host_id;
p.branch_id = p.branch_id == null ? "" : p.branch_id;
p.device_id = p.device_id == null ? "" : p.device_id;
p.foods_spec_name = p.foods_spec_name == null ? "" : p.foods_spec_name;
p.foods_id = p.foods_id == null ? "" : p.foods_id;
p.remark = p.remark == null ? "" : p.remark;
//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";
}
private void BtnFoosSave_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
FoodsSpecial foos = new FoodsSpecial();
foos.foods_spec_id = txtFoosId.Text;
foos.foods_id = txtID.Text;
foos.foods_spec_name = txtFoosName.Text;
foos.active = "1";
foos.remark = "";
foos.sort1 = "";
foos.date_cancel = "";
foos.date_create = "";
foos.date_modi = "";
foos.user_cancel = "";
foos.user_create = "";
foos.user_modi = "";
foos.host_id = "";
foos.branch_id = "";
foos.device_id = mposC.MACAddress;
mposC.mposDB.foosDB.insertFoodsSpecial(foos, "");
setGrfSpec(txtID.Text);
}
private void initConfig()
{
lfooC = new List <FoodsSpecial>();
foos = new FoodsSpecial();
foos.foods_spec_id = "foods_spec_id";
foos.foods_id = "foods_id";
foos.foods_spec_name = "foods_spec_name";
foos.active = "active";
foos.remark = "remark";
foos.sort1 = "sort1";
foos.date_cancel = "date_cancel";
foos.date_create = "date_create";
foos.date_modi = "date_modi";
foos.user_cancel = "user_cancel";
foos.user_create = "user_create";
foos.user_modi = "user_modi";
foos.host_id = "host_id";
foos.branch_id = "branch_id";
foos.device_id = "device_id";
//foos.status_aircondition = "status_aircondition";
foos.pkField = "foods_spec_id";
foos.table = "b_foods_special";
}
