/// <summary> /// 判断客户是否存在 /// </summary> /// <param name="clientsname">客户名称</param> /// <param name="connection">链接类</param> /// <returns>业主类</returns> public static ClientsM IsExist_clientsname(string clientsname, string id, IConnectionD connection) { ClientsM result = null; if (id != "") { string where = string.Format(" and {0}='{1}' and {2} <> {3}", TableStructM.Info_Clients.CL_NAME, clientsname.ReplaceStr(), TableStructM.Info_Clients.CL_ID, id.ReplaceStr()); IList <ClientsM> lst = ReadDataBase(where, connection); if (lst != null) { result = lst.FirstOrDefault(); } } else { string where = string.Format(" and {0}='{1}' ", TableStructM.Info_Clients.CL_NAME, clientsname.ReplaceStr(), TableStructM.Info_Clients.CL_ID, id.ReplaceStr()); IList <ClientsM> lst = ReadDataBase(where, connection); if (lst != null) { result = lst.FirstOrDefault(); } } return(result); }
/// <summary> /// 转换成业务逻辑层的对象 /// </summary> /// <param name="clients">客户信息(模型层)</param> /// <returns>(业务逻辑层)对象</returns> IClientsB ConvertToClients_B(ClientsM clientsm) { IClientsB result = null; if (clientsm != null) { result = new ClientsB(clientsm, this._connectionb); } return(result); }
/// <summary> /// Clients_List页面行为 /// </summary> /// <returns>视图</returns> public ActionResult Clients_List() { //获取客户用户(id)数据信息 string id = ViewMethods.GetForm(Request, "ID", CommonEnums.ValueEnum.vlGet).ToString(); ClientsFactory clientsfactory = new ClientsFactory(); IClientsB lstClients = clientsfactory.GetDataByID(id); ClientsM clientsm = (lstClients != null ? lstClients.Infomation_clients : null); ViewBag.ClientsInfo = clientsm; return(View()); }
/// <summary> /// 判断客户是否存在 /// </summary> /// <param name="clientsname">客户名</param> /// <returns>客户类</returns> public bool IsExist_clientsname(string clientsname, string id) { bool isExist_clientsname = false; ClientsM clientsm = this._clientsb.IsExist_clientsname(clientsname, id); if (clientsm != null) { this.Infomation_clients = clientsm; isExist_clientsname = true; } return(isExist_clientsname); }
/// <summary> /// 将数据阅读器中的数据添加到对象中 /// </summary> /// <param name="dr">数据阅读器</param> /// <param name="alias">表别名</param> /// <returns>数据</returns> public static ClientsM AddDataToObject(IDataReader dr, string alias = "") { ClientsM result = new ClientsM(); result.CLID = dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Clients.CL_ID, alias)].ConvertToInt32(); result.CLNAME = (dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Clients.CL_NAME, alias)].ToString()); result.CLACCOUNT = (dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Clients.CL_ACCOUNT, alias)].ToString()); result.CLADDRESS = (dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Clients.CL_ADDRESS, alias)].ToString()); result.CLBANK = (dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Clients.CL_BANK, alias)].ToString()); result.CLBELONG = dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Clients.CL_BELONG, alias)].ConvertToInt32(); result.CLCODE = (dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Clients.CL_CODE, alias)].ToString()); result.CLPERSON = (dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Clients.CL_PERSON, alias)].ToString()); result.CLTEL = (dr[CommonMethods.CombineFieldAlias(TableStructM.Info_Clients.CL_TEL, alias)].ToString()); return(result); }
/// <summary> /// 编辑客户信息(Clients_Edit页面) /// </summary> public ActionResult Edit_Clients() { ClientsFactory clientsfactory = new ClientsFactory(); //获取客户编号(id)信息 string id = ViewMethods.GetForm(Request, "ID", CommonEnums.ValueEnum.vlGet).ToString(); IClientsB clientsb = clientsfactory.GetDataByID(id); ClientsM clientsm = (clientsb == null ? null : clientsb.Infomation_clients); //编辑客户信息 string clientsname = ViewMethods.GetForm(Request, "name", CommonEnums.ValueEnum.vlPost).ToString(); string clientsbelong = ViewMethods.GetForm(Request, "belong", CommonEnums.ValueEnum.vlPost).ToString(); string clientsperson = ViewMethods.GetForm(Request, "person", CommonEnums.ValueEnum.vlPost).ToString(); string clientstel = ViewMethods.GetForm(Request, "tel", CommonEnums.ValueEnum.vlPost).ToString(); string clientsaddress = ViewMethods.GetForm(Request, "address", CommonEnums.ValueEnum.vlPost).ToString(); string clientscode = ViewMethods.GetForm(Request, "code", CommonEnums.ValueEnum.vlPost).ToString(); string clientsbank = ViewMethods.GetForm(Request, "bank", CommonEnums.ValueEnum.vlPost).ToString(); string clientsaccount = ViewMethods.GetForm(Request, "account", CommonEnums.ValueEnum.vlPost).ToString(); bool isExist = clientsfactory.IsExist_clientsname(clientsname, id); if (isExist) { return(ViewMethods.AlertBack("客户已存在,请重新确认", "-1")); } if (clientsname == "") { return(ViewMethods.AlertBack("名称不能为空", "-1")); } clientsm.CLNAME = clientsname; clientsm.CLBELONG = clientsbelong.ConvertToInt32(); clientsm.CLPERSON = clientsperson; clientsm.CLTEL = clientstel; clientsm.CLADDRESS = clientsaddress; clientsm.CLCODE = clientscode; clientsm.CLBANK = clientsbank; clientsm.CLACCOUNT = clientsaccount; clientsfactory.Infomation_clients = clientsm; ViewBag.ClientsInfo = clientsm; bool isSuccess = clientsfactory.Update(); if (isSuccess) { return(ViewMethods.AlertBack("修改成功", "../../Clients/Clients?BELONG=" + clientsbelong)); } else { return(ViewMethods.AlertBack("修改失败", "-1")); } }
/// <summary> /// 删除客户信息(Clients页面) /// </summary> /// <returns></returns> public ActionResult Delete_Clients() { //获取客户编号(id)信息 string uid = ViewMethods.GetForm(Request, "uid", CommonEnums.ValueEnum.vlPost).ToString(); ClientsM clientsm = new ClientsM(); clientsm.CLID = uid.ConvertToInt32(); ClientsFactory clientsfactory = new ClientsFactory(); clientsfactory.Infomation_clients = clientsm; clientsfactory.Del_Clients(); return(new JsonResult() { Data = PublicMethods.JSonHelper <string> .ObjectToJson(new { status = "0", msg = "删除成功" }), ContentType = "json" }); }
/// <summary> /// 添加客户信息(Clients_Add页面) /// </summary> public ActionResult Add_Clients() { string id = ""; ClientsFactory clientsfactory = new ClientsFactory(); //添加客户信息 ClientsM clientsm = new ClientsM(); string clientsname = ViewMethods.GetForm(Request, "name", CommonEnums.ValueEnum.vlPost).ToString(); string clientsbelong = ViewMethods.GetForm(Request, "belong", CommonEnums.ValueEnum.vlPost).ToString(); string clientsperson = ViewMethods.GetForm(Request, "person", CommonEnums.ValueEnum.vlPost).ToString(); string clientstel = ViewMethods.GetForm(Request, "tel", CommonEnums.ValueEnum.vlPost).ToString(); string clientsaddress = ViewMethods.GetForm(Request, "address", CommonEnums.ValueEnum.vlPost).ToString(); string clientscode = ViewMethods.GetForm(Request, "code", CommonEnums.ValueEnum.vlPost).ToString(); string clientsbank = ViewMethods.GetForm(Request, "bank", CommonEnums.ValueEnum.vlPost).ToString(); string clientsaccount = ViewMethods.GetForm(Request, "account", CommonEnums.ValueEnum.vlPost).ToString(); bool isExist = clientsfactory.IsExist_clientsname(clientsname, id); if (isExist) { return(ViewMethods.AlertBack("客户已存在,请重新确认", "-1")); } if (clientsname == "") { return(ViewMethods.AlertBack("名称不能为空", "-1")); } clientsm.CLNAME = clientsname; clientsm.CLBELONG = clientsbelong.ConvertToInt32(); clientsm.CLPERSON = clientsperson; clientsm.CLTEL = clientstel; clientsm.CLADDRESS = clientsaddress; clientsm.CLCODE = clientscode; clientsm.CLBANK = clientsbank; clientsm.CLACCOUNT = clientsaccount; clientsfactory.Infomation_clients = clientsm; clientsfactory.Save(); return(ViewMethods.AlertBack("添加客户成功!", "../../Clients/Clients?BELONG=" + clientsbelong)); }
/// <summary> /// 构造函数 /// </summary> /// <param name="info">业主信息类(模型层)</param> /// <param name="connectionb">链接类</param> public ClientsB(ClientsM info, IConnectionB connectionb) : this(connectionb) { this.Infomation_clients = info; }
/// <summary> /// 通过编号获取数据 /// </summary> /// <param name="id">编号</param> /// <returns>数据</returns> public IClientsB GetDataByID(string id) { ClientsM result = Methods.ReflexInvokeMethod(this._clientsd, this._methodnm_GetDataByID, new Type[] { typeof(String), typeof(IConnectionD) }, new object[] { id, this._connectionb.ConnectionD }) as ClientsM; return(ConvertToClients_B(result)); }