public void del_line(string id) { lineModel ln = new lineModel(); ln.line_id = id; ln.del_line(); }
public IActionResult addCustomer() { customerTypeModel ct = new customerTypeModel(); ViewData["cus_type"] = ct.drop_cus_type_code(); prefixModel px = new prefixModel(); ViewData["prefix"] = px.drop_prefix(""); provinceModel pv = new provinceModel(); ampuresModel am = new ampuresModel(); districts dt = new districts(); ViewData["province"] = pv.drop_province(""); ViewData["amphur"] = am.dorp_amphur(""); ViewData["district"] = dt.drop_district(""); conditionPayModel cd = new conditionPayModel(); ViewData["condition"] = cd.drop_con_pay(""); lineModel ln = new lineModel(); ViewData["line"] = ln.drop_line(""); line_saleModel ls = new line_saleModel(); ViewData["line_sale"] = ls.drop_line_sale(""); return(View()); }
public lineModel getLineInf(string station, string line) { lineModel model = new lineModel(); string sql = "select * from stationLine where STATIONID='" + station + "' and LINEID='" + line + "'"; try { DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text); if (dt.Rows.Count > 0) { model.StationID = dt.Rows[0]["STATIONID"].ToString(); model.LINEID = dt.Rows[0]["LINEID"].ToString(); model.ASM = dt.Rows[0]["ASM"].ToString(); model.VMAS = dt.Rows[0]["VMAS"].ToString(); model.SDS = dt.Rows[0]["SDS"].ToString(); model.JZJS_LIGHT = dt.Rows[0]["JZJS_LIGHT"].ToString(); model.JZJS_HEAVY = dt.Rows[0]["JZJS_HEAVY"].ToString(); model.ZYJS = dt.Rows[0]["ZYJS"].ToString(); model.LZ = dt.Rows[0]["LZ"].ToString(); model.PRINTER = dt.Rows[0]["PRINTER"].ToString(); model.AUTOPRINT = dt.Rows[0]["AUTOPRINT"].ToString(); } else { model.StationID = "-2"; //当服务器上没有找到本线时,本线编号置为-2,以免为0 } } catch (Exception) { throw; } return(model); }
public string select_line(string id) { lineModel ln = new lineModel(); ln.select_line("line_id = '" + id + "'"); return(ln.line_code + "^" + ln.line_name); }
public IActionResult line() { lineModel ln = new lineModel(); ViewData["line"] = ln.list_line(); return(View()); }
public IActionResult insert_line(string line_code, string line_name) { lineModel ln = new lineModel(); ln.line_code = line_code; ln.line_name = line_name; ln.insert_line(); return(RedirectToAction("line", "Information")); }
public IActionResult update_line(string line_code_edit, string line_name_edit, string line_id) { lineModel ln = new lineModel(); ln.line_id = line_id; ln.line_name = line_name_edit; ln.line_code = line_code_edit; ln.update_line(); return(RedirectToAction("line", "Information")); }
public static List <lineModel> getLineName(int lineId) { lineModel data = new lineModel { lineId = lineId }; string sql = @"select lineName from [Line] where lineId=@lineId ;"; return(SqlDataAccess.LoadData <lineModel>(sql, data)); }
public IActionResult typeEmp() { lineModel ln = new lineModel(); employeeModel emp = new employeeModel(); line_saleModel ls = new line_saleModel(); line_transport lt = new line_transport(); ViewData["line"] = ln.drop_line(""); ViewData["employee"] = emp.drop_emp(""); ViewData["line_sale"] = ls.list_line_sale(); ViewData["line_tran"] = lt.list_line_tran(); return(View()); }
public IActionResult editcustomer(string cus) { ViewData["cus_id"] = cus; CustomerModel ctm = new CustomerModel(); ctm.select_customer(" cus_id = '" + cus + "'"); ViewData["cus_code"] = ctm.cus_code; ViewData["cus_name"] = ctm.cus_name; ViewData["cus_name_contact"] = ctm.cus_name_contact; ViewData["cus_trade"] = ctm.cus_trade; ViewData["cus_tax"] = ctm.cus_tax; customerTypeModel ct = new customerTypeModel(); ViewData["cus_type"] = ct.drop_cus_type_code(ctm.cus_ref_type_id); prefixModel px = new prefixModel(); ViewData["prefix"] = px.drop_prefix(ctm.cus_ref_prefix_id); px.select_prefix("prefix_id = '" + ctm.cus_ref_prefix_id + "'"); ViewData["last_name"] = px.prefix_ending; CustomerAddressModel ca = new CustomerAddressModel(); ca.select_address("add_ref_cus_id = '" + cus + "'"); ViewData["add_num"] = ca.add_num; ViewData["add_alley"] = ca.add_alley; ViewData["add_road"] = ca.add_road; ViewData["add_postcode"] = ca.add_poscode; ViewData["add_status"] = ca.add_type_status; ViewData["add_branch"] = ca.add_branch; ViewData["add_id"] = ca.add_id; provinceModel pv = new provinceModel(); ampuresModel am = new ampuresModel(); districts dt = new districts(); ViewData["province"] = pv.drop_province(ca.add_province); ViewData["amphur"] = am.dorp_amphur(ca.add_amphur); ViewData["district"] = dt.drop_district(ca.add_district); CustomerContactModel c_t = new CustomerContactModel(); c_t.select_contact("ct_ref_cus_id = '" + cus + "'"); ViewData["ct_tel"] = c_t.ct_tel; ViewData["ct_fax"] = c_t.ct_fax; ViewData["ct_email"] = c_t.ct_email; ViewData["ct_web"] = c_t.ct_web; ViewData["ct_id"] = c_t.ct_id; CustomerCreditModel crd = new CustomerCreditModel(); crd.select_credit("credit_ref_cus_id = '" + cus + "'"); ViewData["credit_money"] = crd.credit_money; ViewData["credit_id"] = crd.credit_id; conditionPayModel cd = new conditionPayModel(); ViewData["condition"] = cd.drop_con_pay(crd.credit_ref_condition); CustomerLineSaleModel cl = new CustomerLineSaleModel(); cl.select_cus_line("cs_ref_cus_id = '" + cus + "'"); ViewData["sale_name"] = cl.cs_sale_name; ViewData["sale_id"] = cl.cs_id; lineModel ln = new lineModel(); ViewData["line"] = ln.drop_line(cl.cs_ref_line_id); line_saleModel ls = new line_saleModel(); ViewData["line_sale"] = ls.drop_line_sale(""); CustomerTransportModel ts = new CustomerTransportModel(); ts.select_cus_tran("at_ref_cus_id = '" + cus + "'"); ViewData["name_ts"] = ts.at_customer_name; ViewData["num_ts"] = ts.at_num; ViewData["alley_ts"] = ts.at_alley; ViewData["road_ts"] = ts.at_road; ViewData["postcode_ts"] = ts.at_postcode; ViewData["province_ts"] = pv.drop_province(ts.at_province); ViewData["amphur_ts"] = am.dorp_amphur(ts.at_amphur); ViewData["district_ts"] = dt.drop_district(ts.at_district); ViewData["ts_id"] = ts.at_id; return(View()); }