public String update(BillingCover p, String userId)
{
String re = "", sql = "";
chkNull(p);
sql = "Update " + bllC.table + " Set " +
" " + bllC.remark1 + "='" + p.remark1 + "' " +
"," + bllC.billing_cover_code + "='" + p.billing_cover_code.Replace("'", "''") + "' " +
"," + bllC.remark + "='" + p.remark.Replace("'", "''") + "' " +
"," + bllC.date_modi + "=now() " +
"," + bllC.user_modi + "='" + userId.Replace("'", "''") + "' " +
"," + bllC.remark2 + "='" + p.remark2.Replace("'", "''") + "' " +
"," + bllC.job_id + "='" + p.job_id.Replace("'", "''") + "' " +
"," + bllC.cust_id + "='" + p.cust_id.Replace("'", "''") + "' " +
"Where " + bllC.pkField + "='" + p.billing_cover_id + "'";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
public String insert(BillingCover p, String userId)
{
String re = "", sql = "";
p.active = "1";
//p.ssdata_id = "";
chkNull(p);
sql = "Insert Into " + bllC.table + "(" + bllC.remark1 + "," + bllC.billing_cover_code + "," + bllC.job_id + "," +
bllC.active + "," + bllC.remark + ", " + bllC.remark2 + ", " +
bllC.date_create + ", " + bllC.date_modi + ", " + bllC.date_cancel + ", " +
bllC.user_create + ", " + bllC.user_modi + ", " + bllC.user_cancel + "," +
bllC.cust_id + " " +
") " +
"Values ('" + p.remark1 + "','" + p.billing_cover_code + "','" + p.job_id + "'," +
"'" + p.active + "','" + p.remark + "','" + p.remark2 + "'," +
"now(),'" + p.date_modi + "','" + p.date_cancel + "'," +
"'" + userId + "','" + p.user_modi + "','" + p.user_cancel + "'," +
"'" + p.cust_id + "' " +
")";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
public BillingCover selectByPk1(String copId)
{
BillingCover cop1 = new BillingCover();
DataTable dt = new DataTable();
String sql = "select bll.* " +
"From " + bllC.table + " bll " +
//"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " +
"Where bll." + bllC.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
cop1 = setBillingCover(dt);
return(cop1);
}
public String insertBillingCover(BillingCover p, String userId)
{
String re = "";
if (p.billing_cover_id.Equals(""))
{
re = insert(p, userId);
}
else
{
re = update(p, userId);
}
return(re);
}
private void initConfig()
{
fEdit = new Font(xC.iniC.grdViewFontName, xC.grdViewFontSize, FontStyle.Regular);
fEditB = new Font(xC.iniC.grdViewFontName, xC.grdViewFontSize, FontStyle.Bold);
C1ThemeController.ApplicationTheme = xC.iniC.themeApplication;
theme1.Theme = C1ThemeController.ApplicationTheme;
theme1.SetTheme(sB, "BeigeOne");
theme1.SetTheme(tC1, "Office2010Green");
//btnNew.Click += BtnNew_Click;
txtCusNameT1.KeyUp += TxtCusNameT1_KeyUp;
btnCashOk.Click += BtnCashOk_Click;
btnBNew.Click += BtnBNew_Click;
btnBSave.Click += BtnBSave_Click;
btnPrnRcp.Click += BtnPrnRcp_Click;
btnPrnCover.Click += BtnPrnCover_Click;
DateTime billDate = DateTime.Now;
txtBillDate.Value = billDate.Year.ToString() + "-" + billDate.ToString("MM-dd");
sB1.Text = "";
cop = new Company();
cop = xC.xtDB.copDB.selectByCode1("001");
bll = new Billing();
cus = new Customer();
jim = new JobImport();
bllC = new BillingCover();
stt = new C1SuperTooltip();
sep = new C1SuperErrorProvider();
txtBIvat.Value = cop.vat;
txtBEvat.Value = cop.vat;
txtEvat.Value = cop.vat;
//stt.BackgroundGradient = C1.Win.C1SuperTooltip.BackgroundGradient.Gold;
//chkAll.Checked = true;
//xC.setCboYear(cboYear);
initGrfJob();
initGrfDrawView();
initGrfBill();
initGrfCover();
tC1.SelectedTab = tabMake;
tC2.SelectedTab = tabDraw;
//setGrfDeptH();
}
private void setBillingCover()
{
bllC = new BillingCover();
bllC.billing_cover_id = "";
bllC.billing_cover_code = xC.xtDB.copDB.genBillingCoverDoc();
bllC.remark1 = txtRemark1.Text;
bllC.remark2 = txtRemark2.Text;
bllC.active = "1";
bllC.remark = "";
bllC.date_create = "";
bllC.date_modi = "";
bllC.date_cancel = "";
bllC.user_create = "";
bllC.user_modi = "";
bllC.user_cancel = "";
bllC.job_id = txtJobId.Text;
bllC.cust_id = cus.cust_id;
}
private void chkNull(BillingCover p)
{
int chk = 0;
Decimal chk1 = 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.remark1 = p.remark1 == null ? "" : p.remark1;
p.billing_cover_code = p.billing_cover_code == null ? "" : p.billing_cover_code;
p.remark = p.remark == null ? "" : p.remark;
p.remark2 = p.remark2 == null ? "" : p.remark2;
p.cust_id = int.TryParse(p.cust_id, out chk) ? chk.ToString() : "0";
p.job_id = int.TryParse(p.job_id, out chk) ? chk.ToString() : "0";
}
public BillingCover setBillingCover(DataTable dt)
{
BillingCover bllC1 = new BillingCover();
if (dt.Rows.Count > 0)
{
bllC1.billing_cover_id = dt.Rows[0][bllC.billing_cover_id].ToString();
bllC1.billing_cover_code = dt.Rows[0][bllC.billing_cover_code].ToString();
bllC1.remark1 = dt.Rows[0][bllC.remark1].ToString();
bllC1.remark2 = dt.Rows[0][bllC.remark2].ToString();
bllC1.active = dt.Rows[0][bllC.active].ToString();
bllC1.date_cancel = dt.Rows[0][bllC.date_cancel].ToString();
bllC1.date_create = dt.Rows[0][bllC.date_create].ToString();
bllC1.date_modi = dt.Rows[0][bllC.date_modi].ToString();
bllC1.user_cancel = dt.Rows[0][bllC.user_cancel].ToString();
bllC1.user_create = dt.Rows[0][bllC.user_create].ToString();
bllC1.user_modi = dt.Rows[0][bllC.user_modi].ToString();
bllC1.cust_id = dt.Rows[0][bllC.cust_id].ToString();
bllC1.remark = dt.Rows[0][bllC.remark].ToString();
bllC1.job_id = dt.Rows[0][bllC.job_id].ToString();
}
else
{
bllC1.billing_cover_id = "";
bllC1.billing_cover_code = "";
bllC1.remark1 = "";
bllC1.remark2 = "";
bllC1.active = "";
bllC1.remark = "";
bllC1.date_create = "";
bllC1.date_modi = "";
bllC1.date_cancel = "";
bllC1.user_create = "";
bllC1.user_modi = "";
bllC1.user_cancel = "";
bllC1.cust_id = "";
bllC1.job_id = "";
}
return(bllC1);
}
private void initConfig()
{
bllC = new BillingCover();
bllC.billing_cover_id = "billing_cover_id";
bllC.billing_cover_code = "billing_cover_code";
bllC.remark1 = "remark1";
bllC.remark2 = "remark2";
bllC.active = "active";
bllC.remark = "remark";
bllC.date_create = "date_create";
bllC.date_modi = "date_modi";
bllC.date_cancel = "date_cancel";
bllC.user_create = "user_create";
bllC.user_modi = "user_modi";
bllC.user_cancel = "user_cancel";
bllC.job_id = "job_id";
bllC.cust_id = "cust_id";
bllC.table = "t_billing_cover";
bllC.pkField = "billing_cover_id";
lexpn = new List <BillingCover>();
}
