public String insert(Images p, String userId)
{
String re = "", sql = "";
p.active = "1";
//p.ssdata_id = "";
chkNull(p);
sql = "Insert Into " + img.table + "(" + img.image_name + "," + img.table_id + "," + img.job_id + "," +
img.active + "," + img.remark + ", " + img.image_path + "," +
img.date_create + ", " + img.date_modi + ", " + img.date_cancel + "," +
img.user_create + ", " + img.user_modi + ", " + img.user_cancel + " " +
") " +
"Values ('" + p.image_name + "','" + p.table_id + "','" + p.job_id + "'," +
"'" + p.active + "','" + p.remark + "','" + p.image_path + "', " +
"now(),'" + p.date_modi + "','" + p.date_cancel + "', " +
"'" + userId + "','" + p.user_modi + "','" + p.user_cancel + "' " +
")";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
public String insert(CustomerTaxInvoice p)
{
String re = "";
String sql = "";
p.active = "1";
//p.ssdata_id = "";
int chk = 0;
chkNull(p);
sql = "Insert Into " + cusT.table + "(" + cusT.cust_id + "," + cusT.tax_invoice_name_e + "," + cusT.tax_invoice_name_t + "," +
cusT.date_create + "," + cusT.date_modi + ", " + cusT.date_cancel + ", " +
cusT.user_create + "," + cusT.user_modi + ", " + cusT.user_cancel + ", " +
cusT.active + ", " + cusT.tax_id + ", " + cusT.sort1 + ", " +
cusT.remark + " " +
") " +
"Values ('" + p.cust_id.Replace("'", "''") + "','" + p.tax_invoice_name_e.Replace("'", "''") + "','" + p.tax_invoice_name_t.Replace("'", "''") + "', " +
"now(),'" + p.date_modi + "','" + p.date_cancel + "', " +
"'" + p.user_create + "','" + p.user_modi + "','" + p.user_cancel + "', " +
"'" + p.active + "','" + p.tax_id + "','" + p.sort1 + "', " +
"'" + p.remark + "' " +
")";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
//public String insert(FMethodPayment p, String userId)
//{
// String re = "";
// String sql = "";
// p.active = "1";
// //p.ssdata_id = "";
// int 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.prefix_id = int.TryParse(p.prefix_id, out chk) ? chk.ToString() : "0";
// //p.dept_id = int.TryParse(p.dept_id, out chk) ? chk.ToString() : "0";
// sql = "Insert Into " + mtp.table + "(" + mtp.method_payment_code + "," + mtp.method_payment_name_e + "," + mtp.method_payment_name_t + "," +
// mtp.date_create + "," + mtp.date_modi + "," + mtp.date_cancel + "," +
// mtp.user_create + "," + mtp.user_modi + "," + mtp.user_cancel + "," +
// mtp.active + "," + mtp.remark + ", " + mtp.sort1 + " " +
// ") " +
// "Values ('" + p.method_payment_code + "','" + p.method_payment_name_e.Replace("'", "''") + "','" + p.method_payment_name_t.Replace("'", "''") + "'," +
// "'" + p.date_create + "','" + p.date_modi + "','" + p.date_cancel + "'," +
// "'" + userId + "','" + p.user_modi + "','" + p.user_cancel + "'," +
// "'" + p.active + "','" + p.remark.Replace("'", "''") + "','" + p.sort1 + "' " +
// ")";
// try
// {
// re = conn.ExecuteNonQuery(conn.conn, sql);
// }
// catch (Exception ex)
// {
// sql = ex.Message + " " + ex.InnerException;
// }
// return re;
//}
//public String update(FMethodPayment p, String userId)
//{
// String re = "";
// String sql = "";
// int 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;
// sql = "Update " + mtp.table + " Set " +
// " " + mtp.method_payment_code + " = '" + p.method_payment_code + "'" +
// "," + mtp.method_payment_name_e + " = '" + p.method_payment_name_e.Replace("'", "''") + "'" +
// "," + mtp.method_payment_name_t + " = '" + p.method_payment_name_t.Replace("'", "''") + "'" +
// "," + mtp.remark + " = '" + p.remark.Replace("'", "''") + "'" +
// "," + mtp.date_modi + " = now()" +
// "," + mtp.user_modi + " = '" + userId + "' " +
// "," + mtp.sort1 + " = '" + p.sort1 + "' " +
// //"," + tmn.status_app + " = '" + p.status_app + "' " +
// "Where " + mtp.pkField + "='" + p.method_payment_id + "'"
// ;
// try
// {
// re = conn.ExecuteNonQuery(conn.conn, sql);
// }
// catch (Exception ex)
// {
// sql = ex.Message + " " + ex.InnerException;
// }
// return re;
//}
//public String insertMethodPayment(FMethodPayment p, String userId)
//{
// String re = "";
// if (p.method_payment_id.Equals(""))
// {
// re = insert(p, userId);
// }
// else
// {
// re = update(p, userId);
// }
// return re;
//}
public String deleteAll()
{
DataTable dt = new DataTable();
String sql = "Delete From " + fmtp.table;
conn.ExecuteNonQuery(conn.conn, sql);
return("");
}
public String insert(ExpensesPayDetail p, String userId)
{
String re = "", sql = "";
p.active = "1";
//p.ssdata_id = "";
chkNull(p);
sql = "Insert Into " + expnP.table + "(" + expnP.expenses_pay_id + "," + expnP.item_id + "," + expnP.status_pay_type + "," +
expnP.active + "," + expnP.remark + ", " +
expnP.date_create + ", " + expnP.date_modi + ", " + expnP.date_cancel + "," +
expnP.user_create + ", " + expnP.user_modi + ", " + expnP.user_cancel + ", " +
expnP.item_name_t + ", " + expnP.job_id + ", " + expnP.pay_amount + ", " +
expnP.pay_to_cus_id + ", " + expnP.pay_to_cus_name_t + ", " + expnP.pay_to_cus_addr + ", " +
expnP.pay_to_cus_tax + ", " + expnP.pay_cheque_no + ", " + expnP.pay_cheque_bank_id + ", " +
expnP.pay_staff_id + ", " + expnP.pay_date + ", " + expnP.comp_bank_id + ", " +
expnP.pay_bank_date + "," + expnP.expenses_draw_detail_id + "," + expnP.desc_dd + "," +
expnP.desc_d + "," + expnP.staff_id + "," + expnP.expense_clear_cash_id + "," +
expnP.ecc_doc + "," + expnP.erc_doc + "," + expnP.status_appv + "," +
expnP.appv_amt + " " +
") " +
"Values ('" + p.expenses_pay_id + "','" + p.item_id + "','" + p.status_pay_type + "'," +
"'" + p.active + "','" + p.remark + "'," +
"now() ,'" + p.date_modi + "','" + p.date_cancel + "'," +
"'" + p.user_create + "','" + p.user_modi + "','" + p.user_cancel + "'," +
"'" + p.item_name_t + "','" + p.job_id + "','" + p.pay_amount + "'," +
"'" + p.pay_to_cus_id + "','" + p.pay_to_cus_name_t + "','" + p.pay_to_cus_addr + "'," +
"'" + p.pay_to_cus_tax + "','" + p.pay_cheque_no + "','" + p.pay_cheque_bank_id + "'," +
"'" + p.pay_staff_id + "','" + p.pay_date + "','" + p.comp_bank_id + "'," +
"'" + p.pay_bank_date + "','" + p.expenses_draw_detail_id + "','" + p.desc_dd + "'," +
"'" + p.desc_d + "','" + p.staff_id + "','" + p.expense_clear_cash_id + "', " +
"'" + p.ecc_doc + "','" + p.erc_doc + "','" + p.status_appv + "'," +
"'" + p.appv_amt + "' " +
")";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
public String insert(JobImportCheckExam p)
{
String re = "";
String sql = "";
p.active = "1";
//p.ssdata_id = "";
int chk = 0;
chkNull(p);
sql = "Insert Into " + jce.table + "(" + jce.job_import_id + "," + jce.status_open_goods + "," + jce.qty_open_goods + "," +
jce.number_open_goods + "," + jce.status_layout_goods + "," + jce.qty_bad_goods + "," +
jce.number_bad_goods + "," + jce.bad_goods_desc + "," + jce.attend_corrupt + "," +
jce.status_corrupt_goods + "," + jce.dmc_no + "," + jce.dmc_date + "," +
jce.date_create + "," + jce.date_modi + ", " + jce.date_cancel + ", " +
jce.user_create + "," + jce.user_modi + ", " + jce.user_cancel + ", " +
jce.active + "," + jce.remark + ", " + jce.sort1 + ", " +
jce.transport_date + "," + jce.custom_date + ", " +
") " +
"Values ('" + p.job_import_id + "','" + p.status_open_goods + "','" + p.qty_open_goods + "'," +
"'" + p.number_open_goods + "','" + p.status_layout_goods.Replace("'", "''") + "','" + p.qty_bad_goods + "'," +
"'" + p.number_bad_goods + "','" + p.bad_goods_desc + "','" + p.attend_corrupt.Replace("'", "''") + "'," +
"'" + p.status_corrupt_goods.Replace("'", "''") + "','" + p.dmc_no.Replace("'", "''") + "','" + p.dmc_date.Replace("'", "''") + "'," +
"now(),'" + p.date_modi + "','" + p.date_cancel + "', " +
"'" + conn.user.staff_id + "','" + p.user_modi + "','" + p.user_cancel + "', " +
"'" + p.active + "','" + p.remark.Replace("'", "''") + "','" + p.sort1.Replace("'", "''") + "', " +
"'" + p.transport_date + "','" + p.custom_date.Replace("'", "''") + "','" +
")";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
String code = re.Substring(re.Length - 6);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
