private void chkNull(OldBilldetail p)
{
long chk = 0;
decimal chk1 = 0;
p.Name = p.Name == null ? "" : p.Name;
p.GroupType = p.GroupType == null ? "" : p.GroupType;
p.Comment = p.Comment == null ? "" : p.Comment;
p.status = p.status == null ? "0" : p.status;
p.date_cancel = p.date_cancel == null ? "" : p.date_cancel;
p.date_create = p.date_create == null ? "" : p.date_create;
p.date_modi = p.date_modi == null ? "" : p.date_modi;
p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
p.user_create = p.user_create == null ? "" : p.user_create;
p.user_modi = p.user_modi == null ? "" : p.user_modi;
p.remark = p.remark == null ? "" : p.remark;
p.sort1 = p.sort1 == null ? "" : p.sort1;
p.bill_id = long.TryParse(p.bill_id, out chk) ? chk.ToString() : "0";
p.Extra = long.TryParse(p.Extra, out chk) ? chk.ToString() : "0";
p.VN = long.TryParse(p.VN, out chk) ? chk.ToString() : "0";
p.item_id = long.TryParse(p.item_id, out chk) ? chk.ToString() : "0";
p.pcksid = long.TryParse(p.pcksid, out chk) ? chk.ToString() : "0";
p.closeday_id = long.TryParse(p.closeday_id, out chk) ? chk.ToString() : "0";
p.bill_group_id = long.TryParse(p.bill_group_id, out chk) ? chk.ToString() : "0";
p.pckid = long.TryParse(p.pckid, out chk) ? chk.ToString() : "0";
p.Price = decimal.TryParse(p.Price, out chk1) ? chk1.ToString() : "0";
p.Total = decimal.TryParse(p.Total, out chk1) ? chk1.ToString() : "0";
p.price1 = decimal.TryParse(p.price1, out chk1) ? chk1.ToString() : "0";
p.qty = decimal.TryParse(p.qty, out chk1) ? chk1.ToString() : "0";
}
private void initConfig()
{
obilld = new OldBilldetail();
obilld.ID = "ID";
obilld.VN = "VN";
obilld.Name = "Name";
obilld.Extra = "Extra";
obilld.Price = "Price";
obilld.Total = "Total";
obilld.GroupType = "GroupType";
obilld.Comment = "Comment";
obilld.item_id = "item_id";
obilld.status = "status";
obilld.pcksid = "pcksid";
obilld.price1 = "price1";
obilld.qty = "qty";
obilld.bill_id = "bill_id";
obilld.active = "active";
obilld.remark = "remark";
obilld.sort1 = "sort1";
obilld.date_cancel = "date_cancel";
obilld.date_create = "date_create";
obilld.date_modi = "date_modi";
obilld.user_cancel = "user_cancel";
obilld.user_create = "user_create";
obilld.user_modi = "user_modi";
obilld.closeday_id = "closeday_id";
obilld.bill_group_id = "bill_group_id";
obilld.pckid = "pckid";
obilld.table = "BillDetail";
obilld.pkField = "ID";
}
private OldBilldetail setBillD(OldBilldetail obilld1)
{
obilld1.ID = "";
obilld1.VN = "";
obilld1.Name = "";
obilld1.Extra = "";
obilld1.Price = "";
obilld1.Total = "";
obilld1.GroupType = "";
obilld1.Comment = "";
obilld1.item_id = "";
obilld1.status = "";
obilld1.pcksid = "";
obilld1.price1 = "";
obilld1.qty = "";
obilld1.bill_id = "";
obilld1.active = "";
obilld1.remark = "";
obilld1.sort1 = "";
obilld1.date_cancel = "";
obilld1.date_create = "";
obilld1.date_modi = "";
obilld1.user_cancel = "";
obilld1.user_create = "";
obilld1.user_modi = "";
obilld1.closeday_id = "";
obilld1.bill_group_id = "";
obilld1.pckid = "";
return(obilld1);
}
public OldBilldetail selectByPk1(String copId)
{
DataTable dt = new DataTable();
OldBilldetail obilld1 = new OldBilldetail();
String sql = "select obilld.* " +
"From " + obilld.table + " obilld " +
"Where obilld." + obilld.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
obilld1 = setBillD(dt);
return(obilld1);
}
public String insert(OldBilldetail p, String userId)
{
String re = "";
String sql = "";
//p.active = "1";
//p.ssdata_id = "";
long chk = 0;
chkNull(p);
if (userId == null)
{
userId = "";
}
//lbReq.form_a_id = "form_a_id";
//p.req_code = genReqDoc();
sql = "Insert Into " + obilld.table + " Set " +
" " + obilld.VN + " = '" + p.VN + "'" +
"," + obilld.Name + "= '" + p.Name.Replace("'", "''") + "'" +
"," + obilld.Extra + "= '" + p.Extra + "'" +
"," + obilld.Price + "= '" + p.Price + "'" +
"," + obilld.Total + "= '" + p.Total + "'" +
"," + obilld.GroupType + "= '" + p.GroupType + "'" +
"," + obilld.Comment + "= '" + p.Comment.Replace("'", "''") + "'" +
"," + obilld.item_id + "= '" + p.item_id + "'" +
"," + obilld.status + "= '" + p.status + "'" +
"," + obilld.pcksid + "= '" + p.pcksid + "'" +
"," + obilld.price1 + "= '" + p.price1 + "'" +
"," + obilld.qty + "= '" + p.qty + "'" +
"," + obilld.date_cancel + "= ''" +
"," + obilld.date_create + "= now() " +
"," + obilld.date_modi + "= ''" +
"," + obilld.user_cancel + "= ''" +
"," + obilld.user_create + "= '" + userId + "@" + conn._IPAddress + "'" +
"," + obilld.user_modi + "= ''" +
"," + obilld.remark + "= '" + p.remark + "'" +
"," + obilld.sort1 + "= '" + p.sort1 + "'" +
"," + obilld.active + "= '1'" +
"," + obilld.bill_id + "= '" + p.bill_id + "'" +
"," + obilld.closeday_id + "= '0'" +
"," + obilld.bill_group_id + "= '" + p.bill_group_id + "'" +
"," + obilld.pckid + "= '" + p.pckid + "'" +
"";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
public String insertBillDetail(OldBilldetail p, String userId)
{
String re = "";
if (p.ID.Equals(""))
{
re = insert(p, userId);
}
else
{
//re = update(p, "");
}
return(re);
}
public OldBilldetail setBillD(DataTable dt)
{
OldBilldetail obilld1 = new OldBilldetail();
if (dt.Rows.Count > 0)
{
obilld1 = new OldBilldetail();
obilld1.ID = dt.Rows[0][obilld.ID].ToString();
obilld1.VN = dt.Rows[0][obilld.VN].ToString();
obilld1.Name = dt.Rows[0][obilld.Name].ToString();
obilld1.Extra = dt.Rows[0][obilld.Extra].ToString();
obilld1.Price = dt.Rows[0][obilld.Price].ToString();
obilld1.Total = dt.Rows[0][obilld.Total].ToString();
obilld1.GroupType = dt.Rows[0][obilld.GroupType].ToString();
obilld1.Comment = dt.Rows[0][obilld.Comment].ToString();
obilld1.item_id = dt.Rows[0][obilld.item_id].ToString();
obilld1.status = dt.Rows[0][obilld.status].ToString();
obilld1.pcksid = dt.Rows[0][obilld.pcksid].ToString();
obilld1.price1 = dt.Rows[0][obilld.price1].ToString();
obilld1.qty = dt.Rows[0][obilld.qty].ToString();
obilld1.bill_id = dt.Rows[0][obilld.bill_id].ToString();
obilld1.active = dt.Rows[0][obilld.active].ToString();
obilld1.remark = dt.Rows[0][obilld.remark].ToString();
obilld1.sort1 = dt.Rows[0][obilld.sort1].ToString();
obilld1.date_cancel = dt.Rows[0][obilld.date_cancel].ToString();
obilld1.date_create = dt.Rows[0][obilld.date_create].ToString();
obilld1.date_modi = dt.Rows[0][obilld.date_modi].ToString();
obilld1.user_cancel = dt.Rows[0][obilld.user_cancel].ToString();
obilld1.user_create = dt.Rows[0][obilld.user_create].ToString();
obilld1.user_modi = dt.Rows[0][obilld.user_modi].ToString();
obilld1.closeday_id = dt.Rows[0][obilld.closeday_id].ToString();
obilld1.bill_group_id = dt.Rows[0][obilld.bill_group_id].ToString();
obilld1.pckid = dt.Rows[0][obilld.pckid].ToString();
}
else
{
setBillD(obilld1);
}
return(obilld1);
}
public String update(OldBilldetail p, String userId)
{
String re = "";
String sql = "";
chkNull(p);
sql = "Update " + obilld.table + " Set " +
" " + obilld.Name + " = '" + p.Name.Replace("'", "''") + "'" +
"," + obilld.Extra + " = '" + p.Extra + "'" +
"," + obilld.Price + " = '" + p.Price + "'" +
"," + obilld.Total + " = '" + p.Total + "'" +
"," + obilld.GroupType + " = '" + p.GroupType + "'" +
"," + obilld.Comment + " = '" + p.Comment.Replace("'", "''") + "'" +
"," + obilld.item_id + " = '" + p.item_id + "'" +
"," + obilld.status + " = '" + p.status + "'" +
"," + obilld.pcksid + " = '" + p.pcksid + "'" +
"," + obilld.price1 + "= '" + p.price1 + "'" +
"," + obilld.qty + "= '" + p.qty + "'" +
"," + obilld.date_modi + "= now() " +
"," + obilld.user_modi + "= '" + userId + "'" +
"," + obilld.remark + "= '" + p.remark + "'" +
"," + obilld.bill_group_id + "= '" + p.bill_group_id + "'" +
"Where " + obilld.pkField + "='" + p.ID + "'"
;
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
