public int EditFinanceByFinanceID(Model.Finance Model)
{
StringBuilder SqlStr = new StringBuilder();
List <SqlParameter> ParamList = new List <SqlParameter>();
if (Model.FinanceName != null)
{
SqlStr.Append("FinanceName=@FinanceName,");
}
ParamList.Add(new SqlParameter("@FinanceName", Model.FinanceName));
if (Model.ChannelId != 0)
{
SqlStr.Append("ChannelId=@ChannelId,");
}
ParamList.Add(new SqlParameter("@ChannelId", Model.ChannelId));
if (Model.ManagerId != 0)
{
SqlStr.Append("ManagerId=@ManagerId,");
}
ParamList.Add(new SqlParameter("@ManagerId", Model.ManagerId));
if (Model.State != -1)
{
SqlStr.Append("State=@State,");
}
ParamList.Add(new SqlParameter("@State", Model.State));
if (Model.FinanceType != -1)
{
SqlStr.Append("FinanceType=@FinanceType,");
}
ParamList.Add(new SqlParameter("@FinanceType", Model.FinanceType));
if (Model.Remark != null)
{
SqlStr.Append("Remark=@Remark,");
}
ParamList.Add(new SqlParameter("@Remark", Model.Remark));
if (Model.FinanceNum != 0)
{
SqlStr.Append("FinanceNum=@FinanceNum,");
}
ParamList.Add(new SqlParameter("@FinanceNum", Model.FinanceNum));
if (Model.Amount != -1)
{
SqlStr.Append("Amount=@Amount,");
}
ParamList.Add(new SqlParameter("@Amount", Model.Amount));
if (ParamList.Count > 0)
{
SqlStr.Remove(SqlStr.Length - 1, 1);
}
SqlStr.Append(" where Id=@Id"); ParamList.Add(new SqlParameter("@Id", Model.Id));
return(ZGZY.Common.SqlHelper.ExecuteNonQuery(ZGZY.Common.SqlHelper.connStr, CommandType.Text, " update Finance set " + SqlStr.ToString(), ParamList.ToArray()));
}
public int AddFinance(Model.Finance Model)
{
string sqlstr = @"insert into Finance
(FinanceName, ChannelId, ManagerId, [State], CreateDate, FinanceType, Remark, Amount, FinanceNum) values
(@FinanceName,@ChannelId,@ManagerId,@State,GETDATE(),@FinanceType,@Remark,@Amount,@FinanceNum) SELECT SCOPE_IDENTITY()";
return(Int32.Parse(ZGZY.Common.SqlHelper.ExecuteScalar(ZGZY.Common.SqlHelper.connStr, CommandType.Text, sqlstr, new SqlParameter[] {
new SqlParameter("@FinanceName", Model.FinanceName),
new SqlParameter("@ChannelId", Model.ChannelId),
new SqlParameter("@ManagerId", Model.ManagerId),
new SqlParameter("@State", Model.State),
new SqlParameter("@FinanceType", Model.FinanceType),
new SqlParameter("@Remark", Model.Remark),
new SqlParameter("@Amount", Model.Amount),
new SqlParameter("@FinanceNum", Model.FinanceNum)
}).ToString()));
}
public int EditFinanceByFinanceID(Model.Finance Model)
{
return(dal.EditFinanceByFinanceID(Model));
}
public int AddFinance(Model.Finance Model)
{
return(dal.AddFinance(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);
}
}
