public ActionResult WorkListInfo()
{
int pid = CommonMethod.GetInt(Request["pid"]);
var projectName = "";
if (pid != 0)
{
var model = ProjectManageDBOperate.GetModelById(pid);
if (model != null)
{
projectName = "->[" + model.Name + "/" + model.FullName + "]";
}
}
ViewBag.ProjectName = projectName;
ViewBag.ProjectId = pid;
var user = CookieOperate.AccountCookie;
ViewBag.Project = ProjectManageDBOperate.GetList(0, user.AccountId).Select(a => new SelectListItem()
{
Value = a.Id.ToString(), Text = a.Name + "-" + a.FullName
});
//ViewBag.Member = CustomerMemberDBOperate.GetList(user.CompanyId).Select(a => new SelectListItem() { Value = a.Id.ToString(), Text = a.Name });
//ViewBag.WorkListStatus = CommonMethod.GetEnumItems<WorkListStatusEnum>().Select(a => new SelectListItem() { Value = a.Key.ToString(), Text = a.Value });
return(View());
}
public JsonResult WorkListInfoEdit(string str, int projectId, string name, int id)
{
ResultInfo result = new ResultInfo();
var account = CookieOperate.AccountCookie;
var list = JsonConvert.DeserializeObject <List <WorkListEdit> >(str);
var project = ProjectManageDBOperate.GetModelById(projectId);
var cusMember = CustomerMemberDBOperate.GetModelById(account.AccountId);
var workList = new WorkList()
{
ProjectId = projectId,
ProjectName = project.Name,
CompanyId = CommonMethod.GetInt(ConfigSetting.eeeYoooId),
CompanyName = ConfigSetting.eeeYoooName,
CusMemberId = account.AccountId,
CusCompanyId = cusMember.CusCompanyId,
Name = name,
Id = id,
Status = WorkListStatusEnum.NotStart.ToString(),
Guid = Guid.NewGuid().ToString(),
CreateBy = account.AccountName
};
var flag = WorkListBLL.AddWorkList(workList, list);
if (flag)
{
result.Message = "操作成功"; result.IsSuccess = true;
}
else
{
result.Message = "操作成功";
}
return(Json(result));
}
public JsonResult ProjectManageList(QueryBase query)
{
string payway = CommonMethod.GetString(Request["PayWay"]);
string status = CommonMethod.GetString(Request["Status"]);
query.CusMemberId = CookieOperate.AccountCookie.AccountId;
var totalcount = 0;
var list = ProjectManageDBOperate.GetPagerList(query, payway, status, out totalcount);
var payways = CommonMethod.GetEnumItems <ProjectPayWayEnum>();
var statuss = CommonMethod.GetEnumItems <ProjectStatusEnum>();
var operate = CommonMethod.GetIntEnumItems <OpereateTypeEnum>();
var dev = CommonMethod.GetIntEnumItems <DevTypeEnum>();
list.ForEach(a =>
{
a.StatusTxt = statuss.FirstOrDefault(b => b.Key == a.Status).Value;
a.PayWayTxt = payways.FirstOrDefault(b => b.Key == a.PayWay).Value;
var o = operate.FirstOrDefault(b => b.Key == a.OpereateType);
if (!string.IsNullOrEmpty(o.Value))
{
a.OpereateTypeTxt = o.Value;
}
var d = operate.FirstOrDefault(b => b.Key == a.DevType);
if (!string.IsNullOrEmpty(d.Value))
{
a.DevTypeTxt = d.Value;
}
});
PagerList <ProjectManage> pagerList = new PagerList <ProjectManage>();
pagerList.rows = list;
pagerList.total = totalcount;
return(Json(pagerList));
}
public JsonResult ProjectManageGetModel(int id)
{
ResultInfo <ProjectManage> info = new ResultInfo <ProjectManage>();
var data = ProjectManageDBOperate.GetModelById(id);
info.Data = data;
return(Json(info));
}
public JsonResult ProjectManageDelete(int id, int IsDeleted)
{
ResultInfo info = new ResultInfo();
var flag = false;
flag = ProjectManageDBOperate.DeleteProjectManage(new ProjectManage()
{
ModifyBy = CookieOperate.AccountCookie.Mobile,
Id = id, IsDeleted = IsDeleted
});
if (flag)
{
info.Message = "删除成功"; info.IsSuccess = true;
}
return(Json(info));
}
public static bool CreateBill(PayVoucherCreateModel model)
{
var project = ProjectManageDBOperate.GetModelById(model.ProjectId);
var res = CreateBillDetail(model);
#region 账单信息填充
var bill = res.Item1;
bill.ProjectName = project.Name;
bill.ProjectId = project.Id;
bill.CusCompanyId = project.CusCompanyId;
bill.CusMemberId = project.CusMemberId;
#endregion
#region 账单详情
var billDetail = res.Item2;
billDetail.ForEach(a => { a.ProjectName = bill.ProjectName; a.CusCompanyId = bill.CusCompanyId; a.CusMemberId = bill.CusMemberId; });
#endregion
return(BillDBOperate.AddBill(bill, billDetail));
}
public JsonResult ProjectManageAddModel(ProjectManage model)
{
ResultInfo info = new ResultInfo();
var flag = false;
var user = CookieOperate.AccountCookie;
var cusMember = CustomerMemberDBOperate.GetModelById(user.AccountId);
model.CusCompanyId = cusMember.CusCompanyId;
model.FullName = model.Name;
model.EndTime = DateTime.MaxValue;
model.CusMemberId = user.AccountId;
model.PayWay = ProjectPayWayEnum.UnKnown.ToString();
model.Status = ProjectStatusEnum.NotStart.ToString();
model.CreateBy = user.Mobile;
model.CreateDate = DateTime.Now;
model.RelStartTime = model.StartTime;
model.RelEndTime = model.EndTime;
model.LastPayDate = model.EndTime;
model.CompanyId = CommonMethod.GetInt(ConfigSetting.eeeYoooId);
model.Source = SourceEnum.PC.ToString();
if (model.Id <= 0)
{
flag = ProjectManageDBOperate.AddProjectManage(model);
info.IsSuccess = flag;
if (flag)
{
info.Message = "保存成功";
}
}
else
{
flag = ProjectManageDBOperate.ModifyProjectManage(model);
info.IsSuccess = flag;
if (flag)
{
info.Message = "保存成功";
}
}
return(Json(info));
}
public static bool ImportExcel(DataTable dt, CompanyUser user, int projectId, string status, out string message)
{
message = string.Empty;
try
{
//工单名称
var workName = dt.Columns[1].ColumnName.Trim();
var project = ProjectManageDBOperate.GetModelById(projectId);
if (project == null)
{
message = "项目编号有误,请核实"; return(false);
}
var guid = Guid.NewGuid().ToString();
if (WorkListDBOperate.GetCountByName(workName) > 0)
{
message = "工单名称已存在,请重新编辑"; return(false);
}
WorkList work = new WorkList()
{
Name = workName,
CreateBy = user.UserName,
CreateDate = DateTime.Now,
Length = 0,
Status = status,
CompanyId = user.CompanyId,
CompanyName = user.CompanyName,
ProjectId = projectId,
ProjectName = project.Name,
CusCompanyId = project.CusCompanyId,
CusMemberId = project.CusMemberId,
Guid = guid,
};
var list = new List <WorkListDetail>();
for (int i = 1; i < dt.Rows.Count; i++)
{
var dr = dt.Rows[i];
var detail = new WorkListDetail()
{
Infos = dr[1].ToString().Trim(),
RoleCode = dr[0].ToString(), //== "消费者" ? DetailRole.Customer.ToString() : DetailRole.Admin.ToString(),
CreateBy = user.UserName,
WorkId = guid,
Index = i,
Guid = Guid.NewGuid().ToString()
};
if (string.IsNullOrEmpty(detail.Infos))
{
continue;
}
else if (detail.Infos.Length > 100)
{
message += (i + 2).ToString() + ",";
}
list.Add(detail);
}
if (!string.IsNullOrEmpty(message))
{
message = "数据第[" + message.Substring(0, message.Length - 1) + "]条内容字数超过100字";
return(false);
}
return(WorkListDBOperate.Import(work, list, out message));
}
catch (Exception ex)
{
message = ex.Message;
}
return(false);
}
