private void GetDetail(HttpContext context, string btn)
{
if (btn != "show")
{
context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起，您没有操作权限！\"}");
return;
}
try
{
int ID = RequestHelper.GetInt("ID", 0);
SCZM.BLL.Repair.repair_AccessoriesBill bll = new SCZM.BLL.Repair.repair_AccessoriesBill();
DataSet ds = bll.GetDetail(ID);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count == 0)
{
context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起，该条数据已被其他人删除！\"}");
return;
}
string rowsStr = Utils.ToJson(dt);
DataTable AccessoriesBill_AccessoriesDT = ds.Tables["AccessoriesBill_Accessories"];
string AccessoriesBill_AccessoriesStr = Utils.ToJson(AccessoriesBill_AccessoriesDT);
StringBuilder jsonStr = new StringBuilder();
jsonStr.Append("{\"status\":\"1\",\"msg\":\"数据获取成功！\",\"info\":" + rowsStr);
jsonStr.Append(",\"AccessoriesBill_AccessoriesInfo\":" + AccessoriesBill_AccessoriesStr);
jsonStr.Append("}");
context.Response.Write(jsonStr);
}
catch (Exception e)
{
context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起，系统出错：" + Utils.HtmlEncode(e.Message) + "\"}");
}
}
private void DelData(HttpContext context, string btn)
{
if (btn != "btnDel")
{
context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起，您没有操作权限！\"}");
return;
}
string IDStr = RequestHelper.GetString("IDStr");
if (IDStr == "")
{
context.Response.Write("{\"status\":\"0\",\"msg\":\"请选择需要删除的记录！\"}");
return;
}
Model.System.sys_LoginUser loginUserModel = BaseWeb.GetLoginInfo();
SCZM.BLL.Repair.repair_AccessoriesBill bll = new SCZM.BLL.Repair.repair_AccessoriesBill();
string operaMessage = "";
string status = "0";
string operaAction = "";
string operaMemo = "";
try
{
if (bll.DeleteList(PageValidate.SafeLongFilter(IDStr, 0), out operaMessage))
{
status = "1";
operaAction = Enums.ActionEnum.Delete.ToString();
operaMemo = "删除辅料明细：" + IDStr;
//写入操作日志
BaseWeb.AddOpera(loginUserModel, int.Parse(RequestHelper.GetQueryString("MenuId")), operaAction, operaMemo);
}
context.Response.Write("{\"status\":\"" + status + "\",\"msg\":\"" + operaMessage + "\"}");
return;
}
catch (Exception e)
{
context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起，系统出错：" + Utils.HtmlEncode(e.Message) + "\"}");
}
}
private void GetList(HttpContext context, string btn)
{
if (btn != "show")
{
context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起，您没有操作权限！\"}");
return;
}
try
{
StringBuilder strWhere = new StringBuilder();
string IntentionCode = RequestHelper.GetString("IntentionCode").Trim();
string CustName = RequestHelper.GetString("CustName").Trim();
string MachineModel = RequestHelper.GetString("MachineModel").Trim();
string MachineCode = RequestHelper.GetString("MachineCode").Trim();
string GetAccessoriesDate_Start = RequestHelper.GetString("GetAccessoriesDate_Start").Trim();
string GetAccessoriesDate_End = RequestHelper.GetString("GetAccessoriesDate_End").Trim();
string UserName = RequestHelper.GetString("UserName").Trim();
string OperaTime = RequestHelper.GetString("OperaTime").Trim();
string BillType = RequestHelper.GetString("BillType").Trim();
if (IntentionCode != "")
{
strWhere.Append(" and b.IntentionCode like '%" + IntentionCode + "%' ");
}
if (CustName != "")
{
strWhere.Append(" and b.CustName like '%" + CustName + "%' ");
}
if (MachineModel != "")
{
strWhere.Append(" and c.MachineModel like '%" + MachineModel + "%' ");
}
if (MachineCode != "")
{
strWhere.Append(" and b.MachineCode like '%" + MachineCode + "%' ");
}
if (UserName != "")
{
strWhere.Append(" and a.UserName like '%" + UserName + "%' ");
}
if (GetAccessoriesDate_Start != "")
{
strWhere.Append(" and a.GetAccessoriesDate > '" + GetAccessoriesDate_Start + " 00:00:00' ");
}
if (GetAccessoriesDate_End != "")
{
strWhere.Append(" and a.GetAccessoriesDate < '" + GetAccessoriesDate_End + " 23:59:59' ");
}
if (OperaTime != "")
{
strWhere.Append(" and a.OperaTime between '" + OperaTime + " 00:00:00' and '" + OperaTime + " 23:59:59' ");
}
if (BillType != "" && BillType != "-1")
{
strWhere.Append(" and a.BillType=" + Utils.StrToInt(BillType, -1) + " ");
}
SCZM.BLL.Repair.repair_AccessoriesBill bll = new SCZM.BLL.Repair.repair_AccessoriesBill();
DataTable dt = bll.GetList(strWhere.ToString()).Tables[0];
string rowsStr = Utils.ToJson(dt);
StringBuilder jsonStr = new StringBuilder();
jsonStr.Append("{\"status\":\"1\",\"msg\":\"数据获取成功！\",\"info\":" + rowsStr + "}");
context.Response.Write(jsonStr);
}
catch (Exception e)
{
context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起，系统出错：" + Utils.HtmlEncode(e.Message) + "\"}");
}
}
private void SaveData(HttpContext context, string btn)
{
if (btn != "btnSave")
{
context.Response.Write("{\"status\":\"0.2\",\"msg\":\"对不起，您没有操作权限！\"}");
return;
}
string ID = RequestHelper.GetString("ID");
string IntentionId = RequestHelper.GetString("IntentionId");
string GetAccessoriesDate = RequestHelper.GetString("GetAccessoriesDate");
string UserName = RequestHelper.GetString("UserName");
string AllFee = RequestHelper.GetString("AllFee");
string AllFee_actual = RequestHelper.GetString("AllFee_actual");
string Memo = RequestHelper.GetString("Memo");
string detailStr_Accessories = RequestHelper.GetString("detailStr_Accessories");
string BillType = RequestHelper.GetString("BillType");
Model.System.sys_LoginUser loginUserModel = BaseWeb.GetLoginInfo();
SCZM.Model.Repair.repair_AccessoriesBill model = new SCZM.Model.Repair.repair_AccessoriesBill();
SCZM.BLL.Repair.repair_AccessoriesBill bll = new SCZM.BLL.Repair.repair_AccessoriesBill();
model.ID = Utils.StrToInt(ID, 0);
model.IntentionId = Utils.StrToInt(IntentionId, 0);
if (GetAccessoriesDate != "")
{
model.GetAccessoriesDate = Utils.StrToDateTime(GetAccessoriesDate);
}
model.UserName = UserName;
model.AllFee = Utils.StrToDecimal(AllFee, 0);
model.AllFee_actual = Utils.StrToDecimal(AllFee_actual, 0);
model.BillType = Utils.StrToInt(BillType, 0);
model.Memo = Memo;
model.OperaDepId = loginUserModel.DepId;
model.OperaId = loginUserModel.ID;
model.OperaName = loginUserModel.PerName;
model.OperaTime = DateTime.Now;
List <Model.Repair.repair_AccessoriesBill_Accessories> model_detail = new List <Model.Repair.repair_AccessoriesBill_Accessories>();
Model.Repair.repair_AccessoriesBill_Accessories models = new Model.Repair.repair_AccessoriesBill_Accessories();
if (detailStr_Accessories != "")
{
string[] detailRow = detailStr_Accessories.Split('≮');
for (int i = 0; i < detailRow.Length; i++)
{
string[] detailCell = detailRow[i].Split('⊥');
models = new Model.Repair.repair_AccessoriesBill_Accessories();
models.AccessoriesId = Utils.StrToInt(detailCell[0], 0);
models.AccessoriesNat = Utils.StrToInt(detailCell[1], 0);
models.AccessoriesNum = Utils.StrToInt(detailCell[2], 0);
models.AccessoriesFee = Utils.StrToInt(detailCell[3], 0);
models.AccessoriesMemo = detailCell[4];
models.AccessoriesDate = Utils.StrToDateTime(detailCell[5], DateTime.Now);
model_detail.Add(models);
}
model.repair_AccessoriesBill_Accessoriess = model_detail;
}
string operaMessage = "";
string status = "0";
string operaAction = "";
string operaMemo = "";
try
{
if (ID == "")
{
model.ID = bll.Add(model, out operaMessage);
if (model.ID > 0)
{
status = "1";
operaAction = Enums.ActionEnum.Add.ToString();
operaMemo = "新增辅料明细：" + model.ID;
}
}
else
{
if (bll.Update(model, out operaMessage))
{
status = "1";
operaAction = Enums.ActionEnum.Edit.ToString();
operaMemo = "修改辅料明细：" + model.ID;
}
}
if (status == "1")
{
//写入操作日志
BaseWeb.AddOpera(loginUserModel, int.Parse(RequestHelper.GetQueryString("MenuId")), operaAction, operaMemo);
}
context.Response.Write("{\"status\":\"" + status + "\",\"msg\":\"" + operaMessage + "\"}");
return;
}
catch (Exception e)
{
context.Response.Write("{\"status\":\"0\",\"msg\":\"对不起，系统出错：" + Utils.HtmlEncode(e.Message) + "\"}");
return;
}
}
