private void chkNull(StockCardEndYear p) { long 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.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.price = p.price == null ? "" : p.price; p.item_id = p.item_id == null ? "" : p.item_id; p.remark = p.remark == null ? "" : p.remark; p.unit_name = p.unit_name == null ? "" : p.unit_name; p.remark = p.remark == null ? "" : p.remark; p.remark = p.remark == null ? "" : p.remark; p.remark = p.remark == null ? "" : p.remark; p.rec_draw_sale_id = long.TryParse(p.rec_draw_sale_id, out chk) ? chk.ToString() : "0"; p.rec_draw_sale_date = long.TryParse(p.rec_draw_sale_date, out chk) ? chk.ToString() : "0"; p.status_rec_draw = long.TryParse(p.status_rec_draw, out chk) ? chk.ToString() : "0"; p.price = Decimal.TryParse(p.price, out chk1) ? chk1.ToString() : "0"; p.item_id = Decimal.TryParse(p.item_id, out chk1) ? chk1.ToString() : "0"; p.onhand = Decimal.TryParse(p.onhand, out chk1) ? chk1.ToString() : "0"; }
private void BtnSave_Click(object sender, EventArgs e) { //throw new NotImplementedException(); ic.ivfDB.stkeDB.DeleteAll(""); foreach (Row row in grf2019.Rows) { if (row[colStkStatus] == null) { continue; } if (row[colStkStatus].ToString().Equals("onhand")) { StockCardEndYear stke = new StockCardEndYear(); stke.stock_endyear_id = ""; stke.year_id = "2019"; stke.item_id = row[colStkId].ToString(); stke.unit_name = row[colStkUnit] != null ? row[colStkUnit].ToString() : ""; stke.onhand = row[colStkOnhand] != null ? row[colStkOnhand].ToString(): "0"; stke.active = "1"; stke.remark = row[colStkRemark] != null ? row[colStkRemark].ToString() : ""; String re = ic.ivfDB.stkeDB.insertStockCardEndYear(stke, ""); long chk = 0; } } }
public String update(StockCardEndYear p, String userId) { String re = ""; String sql = ""; int chk = 0; chkNull(p); sql = "Update " + stkc.table + " Set " + " " + stkc.item_id + " = '" + p.item_id + "'" + "," + stkc.price + " = '" + p.price.Replace("'", "''") + "'" + "," + stkc.remark + " = '" + p.remark.Replace("'", "''") + "'" + "," + stkc.date_modi + " = now()" + "," + stkc.user_modi + " = '" + userId + "' " + "," + stkc.host_id + " = '" + p.host_id + "' " + "," + stkc.branch_id + " = '" + p.branch_id + "' " + "," + stkc.device_id + " = '" + p.device_id + "' " + "," + stkc.sort1 + " = '" + p.sort1 + "' " + "," + stkc.onhand + " = '" + p.onhand + "' " + "Where " + stkc.pkField + "='" + p.stock_endyear_id + "'" ; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
public String insert(StockCardEndYear p, String userId) { String re = ""; String sql = ""; p.qty = "1"; //p.ssdata_id = ""; int chk = 0; chkNull(p); sql = "Insert Into " + stkc.table + " set " + " " + stkc.item_id + " = '" + p.item_id + "'" + "," + stkc.price + " = '" + p.price.Replace("'", "''") + "'" + "," + stkc.remark + " = '" + p.remark.Replace("'", "''") + "'" + "," + stkc.date_create + " = now()" + "," + stkc.onhand + " = '" + p.onhand + "'" + "," + stkc.user_create + " = '" + userId + "' " + "," + stkc.host_id + " = '" + p.host_id + "' " + "," + stkc.branch_id + " = '" + p.branch_id + "' " + "," + stkc.device_id + " = '" + p.device_id + "' " + "," + stkc.sort1 + " = '" + p.sort1 + "' " + "," + stkc.year_id + " = '" + p.year_id + "' " + "," + stkc.unit_name + " = '" + p.unit_name + "' " + " "; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
private StockCardEndYear setStockCardEndYear(DataTable dt) { StockCardEndYear dept1 = new StockCardEndYear(); if (dt.Rows.Count > 0) { dept1.stock_endyear_id = dt.Rows[0][stkc.stock_endyear_id].ToString(); dept1.year_id = dt.Rows[0][stkc.year_id].ToString(); dept1.item_id = dt.Rows[0][stkc.item_id].ToString(); dept1.price = dt.Rows[0][stkc.price].ToString(); dept1.weight = dt.Rows[0][stkc.weight] != null ? dt.Rows[0][stkc.weight].ToString() : ""; dept1.item_id = dt.Rows[0][stkc.item_id] != null ? dt.Rows[0][stkc.item_id].ToString() : ""; dept1.remark = dt.Rows[0][stkc.remark] != null ? dt.Rows[0][stkc.remark].ToString() : ""; dept1.date_create = dt.Rows[0][stkc.date_create] != null ? dt.Rows[0][stkc.date_create].ToString() : ""; dept1.date_modi = dt.Rows[0][stkc.date_modi] != null ? dt.Rows[0][stkc.date_modi].ToString() : ""; dept1.date_cancel = dt.Rows[0][stkc.date_cancel] != null ? dt.Rows[0][stkc.date_cancel].ToString() : ""; dept1.user_create = dt.Rows[0][stkc.user_create] != null ? dt.Rows[0][stkc.user_create].ToString() : ""; dept1.user_modi = dt.Rows[0][stkc.user_modi] != null ? dt.Rows[0][stkc.user_modi].ToString() : ""; dept1.user_cancel = dt.Rows[0][stkc.user_cancel] != null ? dt.Rows[0][stkc.user_cancel].ToString() : ""; dept1.qty = dt.Rows[0][stkc.qty] != null ? dt.Rows[0][stkc.qty].ToString() : ""; dept1.sort1 = dt.Rows[0][stkc.sort1] != null ? dt.Rows[0][stkc.sort1].ToString() : ""; dept1.price = dt.Rows[0][stkc.price] != null ? dt.Rows[0][stkc.price].ToString() : ""; dept1.rec_draw_sale_id = dt.Rows[0][stkc.rec_draw_sale_id] != null ? dt.Rows[0][stkc.rec_draw_sale_id].ToString() : ""; dept1.rec_draw_sale_date = dt.Rows[0][stkc.rec_draw_sale_date] != null ? dt.Rows[0][stkc.rec_draw_sale_date].ToString() : ""; dept1.status_rec_draw = dt.Rows[0][stkc.status_rec_draw] != null ? dt.Rows[0][stkc.status_rec_draw].ToString() : ""; dept1.onhand = dt.Rows[0][stkc.onhand] != null ? dt.Rows[0][stkc.onhand].ToString() : ""; } else { dept1.stock_endyear_id = ""; dept1.year_id = ""; dept1.item_id = ""; dept1.price = ""; dept1.weight = ""; dept1.remark = ""; dept1.date_create = ""; dept1.date_modi = ""; dept1.date_cancel = ""; dept1.user_create = ""; dept1.user_modi = ""; dept1.user_cancel = ""; dept1.qty = ""; dept1.sort1 = ""; dept1.price = ""; dept1.item_id = ""; dept1.rec_draw_sale_id = ""; dept1.status_rec_draw = ""; dept1.rec_draw_sale_date = ""; dept1.onhand = ""; } return(dept1); }
public String insertStockCardEndYear(StockCardEndYear p, String userId) { String re = ""; if (p.stock_endyear_id.Equals("")) { re = insert(p, ""); } else { re = update(p, ""); } return(re); }
private void initConfig() { lstkc = new List <StockCardEndYear>(); stkc = new StockCardEndYear(); stkc.stock_endyear_id = "stock_endyear_id"; stkc.year_id = "year_id"; stkc.item_id = "item_id"; stkc.price = "price"; stkc.qty = "qty"; stkc.remark = "remark"; stkc.sort1 = "sort1"; stkc.date_cancel = "date_cancel"; stkc.date_create = "date_create"; stkc.date_modi = "date_modi"; stkc.user_cancel = "user_cancel"; stkc.user_create = "user_create"; stkc.user_modi = "user_modi"; stkc.host_id = "host_id"; stkc.branch_id = "branch_id"; stkc.device_id = "device_id"; stkc.weight = "weight"; stkc.rec_draw_sale_id = "rec_draw_sale_id"; stkc.status_rec_draw = "status_rec_draw"; stkc.rec_draw_sale_date = "rec_draw_sale_date"; stkc.onhand = "onhand"; stkc.host_id = "host_id"; stkc.branch_id = "branch_id"; stkc.device_id = "device_id"; stkc.active = "active"; stkc.remark1 = "remark1"; stkc.description = "description"; stkc.doc_no = "doc_no"; stkc.unit_name = "unit_name"; stkc.pkField = "stock_endyear_id"; stkc.table = "t_stock_endyear"; }