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