/// <summary>
/// 客户管理 详情查询
/// </summary>
public object Get(int id)
{
base_customers info = customersBLL.GetInfo(id, out errmsg)
; if (!string.IsNullOrEmpty(errmsg))
{
return(new { Rcode = -1, Rmsg = "获取数据失败" });
}
return(new { Rcode = 1, Rdata = info });
}
/// <summary>
/// 客户管理 添加数据
/// </summary>
public object Post([FromBody] base_customers info)
{
info.creator = LoginUserData.UserID;
info.createdtime = DateTime.Now;
bool success = customersBLL.Add(info, out errmsg);
WriteSysLog(0, string.Format("添加客户{0}，返回{1} {2}", info.customername, success, errmsg));
if (!success || !string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "添加失败" }
}
;
return(new { Rcode = 1, Rmsg = "添加成功" });
}
/// <summary>
/// 客户管理 更新数据
/// </summary>
public object Put(int id, [FromBody] base_customers info)
{
info.customerid = id;
info.creator = LoginUserData.UserID;
info.createdtime = DateTime.Now;
bool success = customersBLL.Update(info, out errmsg);
WriteSysLog(1, string.Format("更新客户id为{0}，返回{1} {2}", id, success, errmsg));
if (!success || !string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "更新失败" }
}
;
return(new { Rcode = 1, Rmsg = "更新成功" });
}
public object Get(string codes, string type, string flig, string customerid)
{
if (!string.IsNullOrEmpty(type))
{
base_customers info = customersBLL.selectcusername(codes, type, out errmsg);
if (string.Equals("修改", flig))
{
if (info != null)
{
return(new { valid = (string.Equals(info.customerid.ToString(), customerid)) ? true : false });
}
return(new { valid = true });
}
return(new { valid = (info == null) ? true : false });
}
return(new { valid = false });
}
/// <summary>
/// 客户管理 添加数据
/// </summary>
/// <param name="base_customers">要添加的客户管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(base_customers info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("customername", info.customername));
pars.Add(new DataParameter("contacts", info.contacts));
pars.Add(new DataParameter("email", info.email));
pars.Add(new DataParameter("phone", info.phone));
pars.Add(new DataParameter("fax", info.fax));
pars.Add(new DataParameter("country", info.country));
pars.Add(new DataParameter("areacode", info.areacode));
pars.Add(new DataParameter("postcode", info.postcode));
pars.Add(new DataParameter("industry", info.industry));
pars.Add(new DataParameter("website", info.website));
pars.Add(new DataParameter("logourl", info.logourl));
pars.Add(new DataParameter("introduction", info.introduction));
pars.Add(new DataParameter("creator", info.creator));
pars.Add(new DataParameter("createdtime", info.createdtime));
string sqlstr = "insert into base_customers (customername,contacts,email,phone,fax,country,areacode,postcode,industry,website,logourl,introduction,creator,createdtime) values (@customername,@contacts,@email,@phone,@fax,@country,@areacode,@postcode,@industry,@website,@logourl,@introduction,@creator,@createdtime) ";
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 客户管理 更新数据
/// </summary>
/// <param name="base_customers">要更新的客户管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(base_customers info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("customername", info.customername));
pars.Add(new DataParameter("contacts", info.contacts));
pars.Add(new DataParameter("email", info.email));
pars.Add(new DataParameter("phone", info.phone));
pars.Add(new DataParameter("fax", info.fax));
pars.Add(new DataParameter("country", info.country));
pars.Add(new DataParameter("areacode", info.areacode));
pars.Add(new DataParameter("postcode", info.postcode));
pars.Add(new DataParameter("industry", info.industry));
pars.Add(new DataParameter("website", info.website));
pars.Add(new DataParameter("logourl", info.logourl));
pars.Add(new DataParameter("introduction", info.introduction));
pars.Add(new DataParameter("creator", info.creator));
pars.Add(new DataParameter("createdtime", info.createdtime));
string sqlstr = "update base_customers set customername=@customername,contacts=@contacts,email=@email,phone=@phone,fax=@fax,country=@country,areacode=@areacode,postcode=@postcode,industry=@industry,website=@website,logourl=@logourl,introduction=@introduction,creator=@creator,createdtime=@createdtime where customerid=@customerid ";
pars.Add(new DataParameter("customerid", info.customerid));
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 客户管理 更新数据
/// </summary>
/// <param name="base_customers">要更新的客户管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(base_customers info, out string errmsg)
{
return(customersDAL.Update(info, out errmsg));
}
/// <summary>
/// 客户管理 添加数据
/// </summary>
/// <param name="base_customers">要添加的客户管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(base_customers info, out string errmsg)
{
return(customersDAL.Add(info, out errmsg));
}
/// <summary>
/// 客户管理 详情查询
/// </summary>
public static base_customers GetInfo(int customerid, out string errmsg)
{
base_customers info = customersDAL.GetInfo(customerid, out errmsg);
return(info);
}
