public IHttpActionResult AddCustomer()
{
string name = requestHelper.GetRequsetForm("customerName", "");
string tel = requestHelper.GetRequsetForm("tel", "");
if (string.IsNullOrEmpty(name))
{
return(Ok(ReturnJsonResult.ToJson(-1, "客户名称不能为空！", "")));
}
if (string.IsNullOrEmpty(tel))
{
return(Ok(ReturnJsonResult.ToJson(-1, "联系电话不能为空！", "")));
}
Model.Customers model = new Model.Customers();
model.CustomerName = name;
model.Tel = tel;
int i = bll.Add(model);
if (i > 0)
{
return(Ok(ReturnJsonResult.ToJson(1, "添加成功！", "")));
}
return(Ok(ReturnJsonResult.ToJson(-1, "添加失败！", "")));
}
public int AddCustomers(Model.Customers model)
{
StringBuilder strSql = new StringBuilder();//Id, CreateDate,
strSql.Append("insert into Customers values(@CusCode, @CusName, @State, @CusType, @CusLevel, GETDATE(),@SalesmanId, @ServicerId, @Remark)");
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@CusCode", model.CusCode),
new SqlParameter("@CusName", model.CusName),
new SqlParameter("@State", model.State),
new SqlParameter("@CusType", model.CusType),
new SqlParameter("@CusLevel", model.CusLevel),
new SqlParameter("@SalesmanId", model.SalesmanId),
new SqlParameter("@ServicerId", model.ServicerId),
new SqlParameter("@Remark", model.Remark)
};
using (SqlConnection con = new SqlConnection(ZGZY.Common.SqlHelper.connStr))
{
con.Open();
SqlCommand com = new SqlCommand(strSql.ToString(), con);
com.Parameters.AddRange(paras);
int sum = com.ExecuteNonQuery();
return(sum);
}
}
public Model.Customers GetCustomersById(object ID)
{
StringBuilder strsql = new StringBuilder();
strsql.Append("select * from Customers where Id=@id");
using (SqlConnection con = new SqlConnection(ZGZY.Common.SqlHelper.connStr))
{
con.Open();
SqlCommand com = new SqlCommand(strsql.ToString(), con);
com.Parameters.Add(new SqlParameter("@id", ID));
SqlDataReader read = com.ExecuteReader();
while (read.Read())
{
ZGZY.Model.Customers model = new Model.Customers();
model.Id = int.Parse(read["id"].ToString());
model.State = int.Parse(read["State"].ToString());
model.CusType = int.Parse(read["CusType"].ToString());
model.CusLevel = int.Parse(read["CusLevel"].ToString());
model.CusCode = read["CusCode"].ToString();
model.CusName = read["CusName"].ToString();
model.CreateDate = DateTime.Parse(read["CreateDate"].ToString());
model.SalesmanId = int.Parse(read["SalesmanId"].ToString());
model.ServicerId = int.Parse(read["ServicerId"].ToString());
model.Remark = read["Remark"].ToString();
return(model);
}
}
return(null);
}
public CustomerBuyProcces(int musteriID)
{
this.musteriID = musteriID;
InitializeComponent();
cust = CD.MusteriIDyeGöreAra(musteriID);
label3.Text = cust.CustomerName + cust.CustomerSurname + " müşterisinin hangi tarihler arasındaki satın\n alımlarını görmek istiyorsunuz ?";
dateTimePicker1.Value = DateTime.Now.AddDays(-30);
}
public int EditCustomers(Model.Customers model)
{
if (model != null)
{
StringBuilder strsql = new StringBuilder();
List <SqlParameter> list = new List <SqlParameter>();
if (model.CusName != "")
{
strsql.Append("CusName=@CusName,");
}
list.Add(new SqlParameter("@CusName", model.CusName));
if (model.State != -1)
{
strsql.Append("[State]=@State,");
}
list.Add(new SqlParameter("@State", model.State));
if (model.CusType != -1)
{
strsql.Append(" CusType=@CusType,");
}
list.Add(new SqlParameter("@CusType", model.CusType));
if (model.CusLevel >= 0)
{
strsql.Append("CusLevel=@CusLevel,");
}
list.Add(new SqlParameter("@CusLevel", model.CusLevel));
if (model.SalesmanId != 0)
{
strsql.Append("SalesmanId=@SalesmanId,");
}
list.Add(new SqlParameter("@SalesmanId", model.SalesmanId));
if (model.ServicerId != 0)
{
strsql.Append("ServicerId=@ServicerId,");
}
list.Add(new SqlParameter("@ServicerId", model.ServicerId));
if (model.Remark != null)
{
strsql.Append("Remark=@Remark,");
}
list.Add(new SqlParameter("@Remark", model.Remark));
if (strsql.Length > 0)
{
strsql.Remove(strsql.Length - 1, 1);
strsql.Append(" where Id=@Id ");
list.Add(new SqlParameter("@Id", model.Id));
return(ZGZY.Common.SqlHelper.ExecuteNonQuery(ZGZY.Common.SqlHelper.connStr, CommandType.Text, "update Customers set " + strsql.ToString(), list.ToArray()));
}
}
return(-1);
}
public void UpdateChancesOK(int ChanID)
{
JavaScriptSerializer json = new JavaScriptSerializer();
Model.Chances model = new Model.Chances
{
ChanID = ChanID,
ChanState = 3,
};
int[] a = new int[4];
a = GetRandomByGuid(a);
string bh = "KH" + DateTime.Now.ToString("yyyyMMdd");
for (int j = 0; j < a.Length; j++)
{
bh += a[j];
}
Model.Chances add = new BLL.Chances().GetModel(ChanID);
Model.Customers cus = new Model.Customers
{
CusName = add.ChanName,
CusID = bh,
UserID = add.ChanDueMan,
CusState = 1
};
bool check = new BLL.Chances().SetChanceSuccess(model);
if (check)
{
bool i = new BLL.Customers().Add(cus);
if (i)
{
Context.Response.Write(0);
}
}
else
{
Context.Response.Write(0);
}
}
public List <Model.Customers> SelectAllCustomers(Model.Customers customers, int size, int pageindex)
{
StringBuilder str = new StringBuilder();
if (!string.IsNullOrEmpty(customers.CusName))
{
str.AppendFormat(" and a.CusName like '%{0}%' ", customers.CusName);
}
if (!string.IsNullOrEmpty(customers.UserName))
{
str.AppendFormat(" and b.UserName like '%{0}%' ", customers.UserName);
}
if (!string.IsNullOrEmpty(Convert.ToString(customers.CusDate)))
{
var cusdate = Convert.ToDateTime(customers.CusDate).ToString("yyyy-MM-dd");
str.AppendFormat(" and convert(varchar(10),CusDate,120)='{0}' ", cusdate);
}
BLL.Customers bookinfoBLL = new BLL.Customers();
return(bookinfoBLL.GetModelList(str.ToString(), "1>0" + str.ToString(), size, pageindex));
}
public List <Model.Customers> GetCustomersTbaleNoP()
{
List <Model.Customers> list = new List <Model.Customers>();
SqlDataReader read = dal.GetCustomersTbaleNoP();
while (read.Read())
{
Model.Customers modelcus = new Model.Customers();
modelcus.Id = Int32.Parse(read["Id"].ToString());
modelcus.CusCode = read["CusCode"].ToString();
modelcus.CusName = read["CusName"].ToString();
modelcus.State = Int32.Parse(read["State"].ToString());
modelcus.CusType = Int32.Parse(read["CusType"].ToString());
modelcus.CusLevel = Int32.Parse(read["CusLevel"].ToString());
modelcus.CreateDate = DateTime.Parse(read["CreateDate"].ToString() == "" ? null : read["CreateDate"].ToString());
modelcus.SalesmanId = Int32.Parse(read["SalesmanId"].ToString());
modelcus.ServicerId = Int32.Parse(read["ServicerId"].ToString());
modelcus.Remark = read["Remark"].ToString();
list.Add(modelcus);
}
return(list);
}
public bool Update(Model.Customers customers)
{
BLL.Customers bookinfoBLL = new BLL.Customers();
return(bookinfoBLL.Update(customers));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
string action = context.Request.Params["action"];
ZGZY.Model.UserOperateLog userOperateLog = null; //操作日志对象
try
{
ZGZY.Model.User user = ZGZY.Common.UserHelper.GetUser(context); //获取cookie里的用户对象
userOperateLog = new Model.UserOperateLog();
userOperateLog.UserIp = context.Request.UserHostAddress;
userOperateLog.UserName = user.UserId;
switch (action)
{
case "getbutton": //根据用户的权限获取用户点击的菜单有权限的按钮
string pageName = context.Request.Params["pagename"];
string menuCode = context.Request.Params["menucode"]; //菜单标识码
DataTable dt = new ZGZY.BLL.Customers().GetButtonByMenuCodeAndUserId(menuCode, user.Id);
context.Response.Write(ZGZY.Common.ToolbarHelper.GetToolBar(dt, pageName));
break;
case "add":
if (user != null && new ZGZY.BLL.Authority().IfAuthority("customers", "add", user.Id))
{
ZGZY.Model.Customers CustomersAdd = new Model.Customers();
CustomersAdd.CusName = context.Request.Params["ui_Customers_CusName_add"] ?? "";
CustomersAdd.State = Convert.ToInt32(context.Request.Params["ui_Cutomers_State_add"]);
CustomersAdd.CusType = Convert.ToInt32(context.Request.Params["ui_Cutomers_CusType_add"]);
CustomersAdd.CusLevel = Convert.ToInt32(context.Request.Params["ui_Customers_CusLevel"]);
CustomersAdd.Remark = context.Request.Params["ui_Customers_Remark_add"] ?? "";
CustomersAdd.SalesmanId = 72;
CustomersAdd.ServicerId = 72;
CustomersAdd.CusCode = DateTime.Now.ToString();
int departmentId = new ZGZY.BLL.Customers().AddCustomers(CustomersAdd);
if (departmentId > 0)
{
userOperateLog.OperateInfo = "添加客户";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "添加成功，客户主键：" + departmentId;
context.Response.Write("{\"msg\":\"添加成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "添加客户";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "添加失败";
context.Response.Write("{\"msg\":\"添加失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "添加客户";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":true}");
}
ZGZY.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
break;
case "edit":
if (user != null && new ZGZY.BLL.Authority().IfAuthority("customers", "edit", user.Id))
{
ZGZY.Model.Customers CustomersEdit = new Model.Customers();
CustomersEdit.Id = Convert.ToInt32(context.Request.Params["id"]);
CustomersEdit.CusName = context.Request.Params["ui_Customers_CusName_edit"] ?? "";
CustomersEdit.State = Convert.ToInt32(context.Request.Params["ui_Cutomers_State_edit"]);
CustomersEdit.CusType = Convert.ToInt32(context.Request.Params["ui_Cutomers_CusType_edit"]);
CustomersEdit.CusLevel = Convert.ToInt32(context.Request.Params["ui_Customers_CusLevel_edit"]);
CustomersEdit.Remark = context.Request.Params["ui_Customers_Remark_edit"] ?? "";
int outputRow = new ZGZY.BLL.Customers().EditCustomers(CustomersEdit);
if (outputRow > 0)
{
userOperateLog.OperateInfo = "修改客户";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "修改成功，客户主键：" + outputRow;
context.Response.Write("{\"msg\":\"添加成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "修改客户";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "修改失败";
context.Response.Write("{\"msg\":\"添加失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "修改客户";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":true}");
}
ZGZY.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
break;
case "search":
string strWhere = "1=1";
string sort = context.Request.Params["sort"]; //排序列
string order = context.Request.Params["order"]; //排序方式 asc或者desc
int pageindex = int.Parse(context.Request.Params["page"]);
int pagesize = int.Parse(context.Request.Params["rows"]);
int totalCount; //输出参数
string strJson = new ZGZY.BLL.Button().GetPager("Customers", "Id, CusCode, CusName, State, CusType, CusLevel, CreateDate, SalesmanId, ServicerId, Remark", sort + " " + order, pagesize, pageindex, strWhere, out totalCount);
context.Response.Write("{\"total\": " + totalCount.ToString() + ",\"rows\":" + strJson + "}");
userOperateLog.OperateInfo = "查询按钮";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "查询条件：" + strWhere + " 排序：" + sort + " " + order + " 页码/每页大小：" + pageindex + " " + pagesize;
ZGZY.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
break;
case "delete":
if (user != null && new ZGZY.BLL.Authority().IfAuthority("customers", "delete", user.Id))
{
object departmentIds = context.Request.Params["id"];
if (new ZGZY.BLL.Customers().DeleteCustomersById(departmentIds) == 1)
{
userOperateLog.OperateInfo = "删除客户";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "删除成功，客户主键：" + departmentIds;
context.Response.Write("{\"msg\":\"删除成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "删除客户";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "删除失败，客户主键：" + departmentIds;
context.Response.Write("{\"msg\":\"删除失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "删除客户";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
ZGZY.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
break;
default:
context.Response.Write("{\"result\":\"参数错误！\",\"success\":false}");
break;
}
}
catch (Exception ex)
{
context.Response.Write("{\"msg\":\"" + ZGZY.Common.JsonHelper.StringFilter(ex.Message) + "\",\"success\":false}");
userOperateLog.OperateInfo = "按钮功能异常";
userOperateLog.IfSuccess = false;
userOperateLog.Description = ZGZY.Common.JsonHelper.StringFilter(ex.Message);
ZGZY.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
}
