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());
}
