public int EditCustomerFinanceByFinanceId(Model.CustomerFinance modelCusFin)
{
//update CustomerFinance set CusId=@CusId, BeginDate=@BeginDate, EndDate=@EndDate where FinanceId=@FinanceId
StringBuilder str = new StringBuilder();
List <SqlParameter> list = new List <SqlParameter>();
if (modelCusFin.EndDate != null)
{
str.Append("EndDate=@EndDate,");
}
list.Add(new SqlParameter("@EndDate", modelCusFin.EndDate));
if (modelCusFin.BeginDate != null)
{
str.Append("BeginDate=@BeginDate,");
}
list.Add(new SqlParameter("@BeginDate", modelCusFin.BeginDate));
if (modelCusFin.CusId != 0)
{
str.Append("CusId=@CusId,");
}
list.Add(new SqlParameter("@CusId", modelCusFin.CusId));
if (str.Length > 0)
{
str.Remove(str.Length - 1, 1);
list.Add(new SqlParameter("@FinanceId", modelCusFin.FinanceId));
return(Common.SqlHelper.ExecuteNonQuery(Common.SqlHelper.connStr, CommandType.Text, " update CustomerFinance set " + str.ToString() + " where FinanceId=@FinanceId", list.ToArray()));
}
return(0);
}
public int AddCustomerFinance(Model.CustomerFinance Model)
{
string sql = "insert into CustomerFinance(CusId, FinanceId, BeginDate, EndDate) values(@CusId, @FinanceId, @BeginDate, @EndDate)";
return(ZGZY.Common.SqlHelper.ExecuteNonQuery(Common.SqlHelper.connStr, CommandType.Text, sql, new SqlParameter[] {
new SqlParameter("@CusId", Model.CusId),
new SqlParameter("@FinanceId", Model.FinanceId),
new SqlParameter("@BeginDate", Model.BeginDate),
new SqlParameter("@EndDate", Model.EndDate)
}));
}
public Model.CustomerFinance GetCustomerFinanceByID(object ID)
{
string sql = "select * from where Id=@Id";
SqlDataReader READ = Common.SqlHelper.ExecuteReader(Common.SqlHelper.connStr, CommandType.Text, sql, new SqlParameter[] { new SqlParameter("@Id", ID) });
Model.CustomerFinance model = null;
while (READ.Read())
{
model = new Model.CustomerFinance();
model.Id = Int32.Parse(READ["Id"].ToString());
model.CusId = Int32.Parse(READ["CusId"].ToString());
model.FinanceId = Int32.Parse(READ["FinanceId"].ToString());
model.BeginDate = DateTime.Parse(READ["BeginDate"].ToString());
model.EndDate = DateTime.Parse(READ["EndDate"].ToString());
return(model);
}
return(model);
}
public int EditCustomerFinanceByFinanceId(Model.CustomerFinance modelCusFin)
{
return(dal.EditCustomerFinanceByFinanceId(modelCusFin));
}
public int EditCustomerFinanceByCustomerFinanceID(Model.CustomerFinance Model)
{
return(dal.EditCustomerFinanceByCustomerFinanceID(Model));
}
public int AddCustomerFinance(Model.CustomerFinance Model)
{
return(dal.AddCustomerFinance(Model));
}
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;
JavaScriptSerializer jsonSerialize = new JavaScriptSerializer();
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);
string sum = ZGZY.Common.ToolbarHelper.GetToolBar(dt, pageName);
context.Response.Write(sum);
break;
case "add":
if (user != null && new ZGZY.BLL.Authority().IfAuthority("Channel", "add", user.Id))
{
Model.Finance FinanceModel = new Model.Finance();
FinanceModel.FinanceName = context.Request.Params["ui_Finance_FinanceName_add"];
FinanceModel.ChannelId = Int32.Parse(context.Request.Params["ui_Finance_ChannelID"]);
FinanceModel.ManagerId = 72;
FinanceModel.State = Int32.Parse(context.Request.Params["ui_Finance_State_add"]);
FinanceModel.CreateDate = DateTime.Now;
FinanceModel.FinanceType = Int32.Parse(context.Request.Params["ui_Finance_FinanceType_add"]);
FinanceModel.Remark = context.Request.Params["ui_Finance_Remark_add"];
FinanceModel.FinanceNum = Int32.Parse(context.Request.Params["ui_Finance_FinanceNum_add"]);
FinanceModel.Amount = Int32.Parse(context.Request.Params["ui_Finance_Amount_add"]);
int departmentId = new ZGZY.BLL.Finance().AddFinance(FinanceModel);
if (departmentId > 0)
{
Model.CustomerFinance cusFin = new Model.CustomerFinance();
cusFin.CusId = Int32.Parse(context.Request.Params["ui_Finance_CustomersID"]);
cusFin.FinanceId = departmentId;
cusFin.BeginDate = DateTime.Parse(context.Request.Params["ui_Finance_BeginDate_add"]);
cusFin.EndDate = DateTime.Parse(context.Request.Params["ui_Finance_EndDate_add"]);
new ZGZY.BLL.CustomerFinance().AddCustomerFinance(cusFin);
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 "GetChannelList":
List <Model.VW_GetEndDateAndBeginDateByChannelID> list = new ZGZY.BLL.Finance().GetFinanceFromCombobox();
context.Response.Write(jsonSerialize.Serialize(list));
//string strjson = GetJsonStr(list);
//context.Response.Write(strjson); GetDateById
break;
case "GetCustomersList":
List <Model.Customers> listCus = new ZGZY.BLL.Customers().GetCustomersTbaleNoP();
context.Response.Write(jsonSerialize.Serialize(listCus));
break;
case "GetDateById":
object Id = context.Request.Params["Id"];
Model.VW_GetEndDateAndBeginDateByChannelID model = new ZGZY.BLL.Finance().Get_VWDate(Id);
context.Response.Write(jsonSerialize.Serialize(model));
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("VW_FinanceAndChannel", "UserName,Id,CusId,CusName, FinanceName,BeginDate,EndDate, ChannelId, ManagerId, State, CreateDate, FinanceType, Remark, Amount, FinanceNum, ChannelName, Creator, SealNameId", 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 "edit":
if (user != null && new ZGZY.BLL.Authority().IfAuthority("Channel", "edit", user.Id))
{
Model.Finance financemodel = new Model.Finance();
financemodel.Id = Int32.Parse(context.Request.Params["ID"]);
financemodel.FinanceName = context.Request.Params["ui_Finance_FinanceName_edit"];
financemodel.ChannelId = Int32.Parse(context.Request.Params["ui_Finance_ChannelID_edit"]);
financemodel.State = Int32.Parse(context.Request.Params["ui_Finance_State_edit"]);
financemodel.FinanceType = Int32.Parse(context.Request.Params["ui_Finance_FinanceType_edit"]);
financemodel.FinanceNum = Int32.Parse(context.Request.Params["ui_Finance_FinanceNum_edit"]);
financemodel.Amount = double.Parse(context.Request.Params["ui_Finance_Amount_edit"]);
financemodel.Remark = context.Request.Params["ui_Finance_Remark_edit"];
int outputRow = new ZGZY.BLL.Finance().EditFinanceByFinanceID(financemodel);
Model.CustomerFinance modelCusFin = new Model.CustomerFinance();
modelCusFin.FinanceId = financemodel.Id;
modelCusFin.BeginDate = DateTime.Parse(context.Request.Params["ui_Finance_BeginDate_edit"]);
modelCusFin.EndDate = DateTime.Parse(context.Request.Params["ui_Finance_EndDate_edit"]);
modelCusFin.CusId = Int32.Parse(context.Request.Params["ui_Finance_CustomersID_edit"]);
outputRow += new ZGZY.BLL.CustomerFinance().EditCustomerFinanceByFinanceId(modelCusFin);
if (outputRow == 2)
{
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 "delete":
if (user != null && new ZGZY.BLL.Authority().IfAuthority("Channel", "delete", user.Id))
{
object departmentIds = context.Request.Params["id"];
if (new ZGZY.BLL.Finance().DeleteFinanceByFinanceID(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);
}
}
public int EditCustomerFinanceByCustomerFinanceID(Model.CustomerFinance modelCusFin)
{
throw new NotImplementedException();
}
