public ActionResult FAApplyAdd(string list, string record, string pri, T_GM_ApplyFixedAsset am)
{
List <string> a = cw.JsontoList(list);
List <string> b = cw.JsontoList(pri);
List <string> c = cw.JsontoList(record);
T_CH_Operation_list auditprocess = new T_CH_Operation_list();
var cf = DB.V_CH_Checkfuncflow.Where(w => w.ID == am.AuditProcess).ToList().FirstOrDefault();
if (a.Count > 0 && a[0] != "")
{
am.GID = Guid.NewGuid().ToString();
am.No_Date = DateTime.Now;
am.OperateTime = DateTime.Now;
am.Operator = user.EmployeeId;
am.AuditProcess = cf.Name;
DB.T_GM_ApplyFixedAsset.Add(am);
int i = 0;
decimal t, f;
auditprocess.ID = am.GID;
auditprocess.Check_funcID = cf.CheckfuncID;
auditprocess.Check_flowID = cf.ID;
auditprocess.CreateTime = DateTime.Now;
auditprocess.State = 1;
auditprocess.Url = Url.Action("FAApplyAudit", "Share", new { gid = am.GID });
auditprocess.Creator = user.EmployeeId;
DB.T_CH_Operation_list.Add(auditprocess);
foreach (var item in a)
{
if (c[i] != "" && b[i] != "" && c[i] != "null" && b[i] != "null")
{
var detail = new T_GM_DM();
detail.Remark = am.GID;
detail.MFlID = item;
decimal.TryParse(c[i], out t);
decimal.TryParse(b[i], out f);
detail.Num = t;
detail.Price = f;
detail.NO = am.ApplyNo;
detail.Type = "SQF";
i++;
DB.T_GM_DM.Add(detail);
}
else
{
X.Msg.Alert("警告", "您输入数量或价格为空！！！").Show();
return(this.Direct());
}
}
DB.SaveChanges();
return(this.Direct());
}
else
{
X.Msg.Alert("警告", "您尚未添加任何物料！！！").Show();
return(this.Direct());
}
}
public ActionResult VRSubmit(VacationApply vacation)
{
DirectResult r = new DirectResult();
string orid = vacation.ID;
var prelists = from o in entities.T_HR_Vacation
where o.VPDelete == true && o.LastID == orid
select o;
foreach (T_HR_Vacation item in prelists)
{
T_HR_Vacation prelist = entities.T_HR_Vacation.Find(item.ID);
prelist.VPDelete = false;
}
T_HR_Vacation orlist = entities.T_HR_Vacation.Find(orid);
orlist.VPDelete = true;
orlist.EditOrDelete = "Delete";
vacation.ID = Guid.NewGuid().ToString();
vacation.OperationListID = Guid.NewGuid().ToString();
vacation.Valid = false;
vacation.CreaterName = new LoginUser().EmployeeId;
vacation.CreateTime = DateTime.Now;
vacation.VPEdit = false;
vacation.VPDelete = true;
vacation.EditOrDelete = "";
vacation.LastID = orid;
T_CH_Operation_list newList = new T_CH_Operation_list();
newList.ID = vacation.OperationListID;
newList.State = (int)CheckState.Checking;//审核中
newList.Check_flowID = vacation.CheckFlowId;
newList.Check_funcID = vacation.FuncId;
newList.CreateTime = DateTime.Now;
newList.Creator = new LoginUser().EmployeeId;
newList.Url = Url.Action("CheckVacation", "Vacation", new { id = vacation.ID });
entities.T_HR_Vacation.Add(vacation.ToDB(1));
entities.T_CH_Operation_list.Add(newList);
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "保存成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
return(r);
}
public ActionResult MApplyAdd(string list, string record, string pri, T_GM_ApplyMaterial am)
{
List <string> a = cw.JsontoList(list);
List <string> b = cw.JsontoList(pri);
List <string> c = cw.JsontoList(record);
List <decimal> num = cw.StrtoDec(c);
List <decimal> price = cw.StrtoDec(b);
if (!cw.IsPositiveNumArr(num))
{
return(this.Direct(false, "数量不能为负数"));
}
if (a.Count > 0 && a[0] != "" && a[0] != "null" && a.Count == num.Count && a.Count == price.Count)
{
T_CH_Operation_list auditprocess = new T_CH_Operation_list();
var cf = DB.V_CH_Checkfuncflow.Where(w => w.ID == am.CheckProcess).ToList().FirstOrDefault();
am.GID = Guid.NewGuid().ToString();
am.CheckProcess = cf.Name;
am.ApplyMan = user.EmployeeId;
//am.ApplyMState = "deploying";
am.ApplyTime = DateTime.Now;
DB.T_GM_ApplyMaterial.Add(am);
auditprocess.ID = am.GID;
auditprocess.Check_funcID = cf.CheckfuncID;
auditprocess.Check_flowID = cf.ID;
auditprocess.CreateTime = DateTime.Now;
auditprocess.State = 1;
auditprocess.Url = Url.Action("MApplyAudit", "Share", new { gid = am.GID });
auditprocess.Creator = user.EmployeeId;
DB.T_CH_Operation_list.Add(auditprocess);
int i = 0;
foreach (var item in a)
{
var detail = new T_GM_DM();
detail.Remark = am.GID;
detail.MFlID = item;
detail.Num = num[i];
detail.Price = price[i];
detail.NO = am.ApplyMaterialNo;
detail.Type = "SQM";
i++;
DB.T_GM_DM.Add(detail);
}
}
else
{
return(this.Direct());
}
DB.SaveChanges();
return(this.Direct());
}
/// <summary>
/// 获取附属离职详细信息，包括审核状态和审核备注
/// </summary>
/// <param name="id">离职ID</param>
/// <returns>异常返回null</returns>
public VacationApply GetPreVacationDetail(string id)
{
V_HR_VacationWithDepName va;
PreID = id;
using (Entities db = new Entities())
{
va = db.V_HR_VacationWithDepName.Find(id);
T_CH_Operation_list op = db.T_CH_Operation_list.Find(GetPreOperationListID);
var task = from o in db.V_CH_TaskOperation
where o.OperationID == GetPreOperationListID
select o;
if (va != null && task.Any())
{
PreID = va.ID;
PreStaffID = va.StaffID;
PreName = va.Name;
PreDepartment = va.Department;
PreVPType = va.VPType;
PreStartTime = Convert.ToDateTime(va.StartTime);
PreEndTime = Convert.ToDateTime(va.EndTime);
PreStartTimeStr = PreStartTime.ToString("yyyy-MM-dd HH:mm");
PreEndTimeStr = PreEndTime.ToString("yyyy-MM-dd HH:mm");
PreTimeSpan = Convert.ToDecimal(va.TimeSpan);
PreVPReason = va.VPReason;
PreValid = Convert.ToBoolean(va.Valid);
PreRemark = va.Remark;
PreCreaterName = va.CreaterName;
PreCreateTime = Convert.ToDateTime(va.CreateTime);
PreEditorName = va.EditorName;
PreEditeTime = Convert.ToDateTime(va.EditeTime);
PreOperationListID = va.OperationListID;
PreLastID = va.LastID;
PreVPEdit = Convert.ToBoolean(va.VPEdit);
PreVPDelete = Convert.ToBoolean(va.VPDelete);
PreEditOrDelete = va.EditOrDelete;
PreState = op.State;
PreDescriptionForCheck = "";
foreach (V_CH_TaskOperation items in task)
{
PreDescriptionForCheck += items.Description;
}
PreCheckFlowId = op.Check_flowID;
}
else
{
return(null);
}
return(this);
}
}
/// <summary>
/// 获取附属详细信息，包括审核状态和审核备注
/// </summary>
/// <param name="id">ID</param>
/// <returns>异常返回null</returns>
public BTApply GetPreBusinessTripDetail(string id)
{
V_HR_BTWithDepName bt;
PreID = id;
using (Entities db = new Entities())
{
bt = db.V_HR_BTWithDepName.Find(id);
T_CH_Operation_list op = db.T_CH_Operation_list.Find(GetPreOperationListID);
var task = from o in db.V_CH_TaskOperation
where o.OperationID == GetPreOperationListID
select o;
if (bt != null && task.Any())
{
PreID = bt.ID;
PreStaffID = bt.StaffID;
PreName = bt.Name;
PreDepartment = bt.Department;
PreBTPlace = bt.BTPlace;
PreStartTime = Convert.ToDateTime(bt.StartTime);
PreEndTime = Convert.ToDateTime(bt.EndTime);
PreStartTimeStr = PreStartTime.ToString("yyyy-MM-dd HH:mm");
PreEndTimeStr = PreEndTime.ToString("yyyy-MM-dd HH:mm");
PreTimeSpan = bt.TimeSpan;
PreBTReason = bt.BTReason;
PreValid = Convert.ToBoolean(bt.Valid);
PreRemark = bt.Remark;
PreCreaterName = bt.CreaterName;
PreCreateTime = Convert.ToDateTime(bt.CreateTime);
PreEditorName = bt.EditorName;
PreEditeTime = Convert.ToDateTime(bt.EditeTime);
PreOperationListID = bt.OperationListID;
PreLastID = bt.LastID;
PreBTEdit = Convert.ToBoolean(bt.BTEdit);
PreBTDelete = Convert.ToBoolean(bt.BTDelete);
PreEditOrDelete = bt.EditOrDelete;
PreState = op.State;
PreDescriptionForCheck = "";
foreach (V_CH_TaskOperation items in task)
{
PreDescriptionForCheck += items.Description;
}
PreCheckFlowId = op.Check_flowID;
}
else
{
return(null);
}
return(this);
}
}
/// <summary>
/// 获取离职详细信息，包括审核状态和审核备注
/// </summary>
/// <param name="id">离职ID</param>
/// <returns>异常返回null</returns>
public DimissionApply GetDimissionDetail(string id)
{
V_HR_Dimission di;
ID = id;
using (Entities db = new Entities())
{
di = db.V_HR_Dimission.Find(id);
T_CH_Operation_list op = db.T_CH_Operation_list.Find(GetOperationListID);
var task = from o in db.V_CH_TaskOperation
where o.OperationID == GetOperationListID
select o;
if (di != null && task.Any())
{
ID = di.ID;
StaffID = di.StaffID;
Name = di.Name;
Department = di.Department;
DimissionTime = Convert.ToDateTime(di.DimissionTime);
DimissionType = di.DimissionType;
DimissionReason = di.DimissionReason;
ReasonType = di.ReasonType;
Num = Convert.ToInt32(di.Num);
IsValid = Convert.ToBoolean(di.IsValid);
Remark = di.Remark;
CreaterName = di.CreaterName;
CreateTime = Convert.ToDateTime(di.CreateTime);
CreateTimeStr = CreateTime.ToString("yyyy-MM-dd HH:mm:ss");
EditorName = di.EditorName;
EditeTime = Convert.ToDateTime(di.EditeTime);
OperationListID = di.OperationListID;
State = op.State;
DescriptionForCheck = "";
foreach (V_CH_TaskOperation item in task)
{
DescriptionForCheck += item.Description;
}
CheckFlowId = op.Check_flowID;
}
else
{
return(null);
}
return(this);
}
}
/// <summary>
/// 获取详细信息，包括审核状态和审核备注
/// </summary>
/// <param name="id">ID</param>
/// <returns>异常返回null</returns>
public OWApply GetOWDetail(string id)
{
V_HR_OWApplyWithDepName di;
ID = id;
using (Entities db = new Entities())
{
di = db.V_HR_OWApplyWithDepName.Find(id);
T_CH_Operation_list op = db.T_CH_Operation_list.Find(GetOperationListID);
var task = from o in db.V_CH_TaskOperation
where o.OperationID == GetOperationListID
select o;
if (di != null && task.Any())
{
ID = di.ID;
StaffID = di.StaffID;
Name = di.Name;
Department = di.Department;
StartTime = Convert.ToDateTime(di.StartTime);
EndTime = Convert.ToDateTime(di.EndTime);
StartTimeStr = StartTime.ToString("yyyy-MM-dd HH:mm:ss");
EndTimeStr = EndTime.ToString("yyyy-MM-dd HH:mm:ss");
TimeSpan = Convert.ToDecimal(di.TimeSpan);
CheckTimeSpan = Convert.ToDecimal(di.CheckTimeSpan);
Valid = Convert.ToBoolean(di.Valid);
Remark = di.Remark;
CreaterName = di.CreaterName;
CreateTime = Convert.ToDateTime(di.CreateTime);
EditorName = di.EditorName;
EditeTime = Convert.ToDateTime(di.EditeTime);
OperationListID = di.OperationListID;
State = op.State;
DescriptionForCheck = "";
foreach (V_CH_TaskOperation item in task)
{
DescriptionForCheck += item.Description;
}
CheckFlowId = op.Check_flowID;
}
else
{
return(null);
}
return(this);
}
}
public ActionResult AddOrEditVacation(VacationApply vacation)
{
try
{
vacation.StartTime = Convert.ToDateTime(vacation.StartTimeStr);//计算TimeSpan
vacation.EndTime = Convert.ToDateTime(vacation.EndTimeStr);
}
catch (FormatException fe)
{
X.Msg.Alert("警告", "日期不正确，请检查！").Show();
return(this.Direct());
}
if (vacation.StartTime.Year == vacation.EndTime.Year && vacation.StartTime.Month == vacation.EndTime.Month && vacation.StartTime <= vacation.EndTime)
{
DirectResult r = new DirectResult();
T_HR_Vacation vacationupdate = entities.T_HR_Vacation.Find(vacation.ID);
if (vacationupdate == null)//为空为添加
{
vacation.ID = Guid.NewGuid().ToString();
vacation.OperationListID = Guid.NewGuid().ToString();
vacation.Valid = true;
vacation.CreaterName = new LoginUser().EmployeeId;
vacation.CreateTime = DateTime.Now;
vacation.VPEdit = false;
vacation.VPDelete = false;
T_CH_Operation_list newList = new T_CH_Operation_list();
newList.ID = vacation.OperationListID;
newList.State = (int)CheckState.Checking;//审核中
newList.Check_flowID = vacation.CheckFlowId;
newList.Check_funcID = vacation.FuncId;
newList.CreateTime = DateTime.Now;
newList.Creator = new LoginUser().EmployeeId;
newList.Url = Url.Action("CheckVacation", "Vacation", new { id = vacation.ID });
entities.T_HR_Vacation.Add(vacation.ToDB(1));
entities.T_CH_Operation_list.Add(newList);
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "保存成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
}
else//否则为修改
{
vacation.EditorName = new LoginUser().EmployeeId;
vacation.EditeTime = DateTime.Now;
vacationupdate.Valid = false;
vacation.ID = Guid.NewGuid().ToString();
vacation.OperationListID = Guid.NewGuid().ToString();
vacation.Valid = true;
vacation.VPEdit = false;
vacation.VPDelete = false;
T_CH_Operation_list newList = new T_CH_Operation_list();
newList.ID = vacation.OperationListID;
newList.State = (int)CheckState.Checking;//审核中
newList.Check_flowID = vacation.CheckFlowId;
newList.Check_funcID = vacation.FuncId;
newList.CreateTime = DateTime.Now;
newList.Creator = new LoginUser().EmployeeId;
newList.Url = Url.Action("CheckVacation", "Vacation", new { id = vacation.ID });
entities.T_HR_Vacation.Add(vacation.ToDB(2));
entities.T_CH_Operation_list.Add(newList);
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "修改成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
}
return(r);
}
else
{
X.Msg.Alert("警告", "请假不可跨月！").Show();
return(this.Direct());
}
}
public ActionResult MEXWarehouseSave(string list, string record, string pri, string check, T_GM_EXWarehouse am)
{
DecResualt dr = new DecResualt();
dr = cw.Judge(list, pri, record);
switch (dr.JresualtName)
{
case JudgeResualt.IsNumNegative:
return(this.Direct(false, "数量不能为负数"));
case JudgeResualt.IsPriceNegative:
return(this.Direct(false, "价格不能为负数"));
case JudgeResualt.IsIllegal:
return(this.Direct());
case JudgeResualt.IsLegal:
break;
default:
return(this.Direct(false, "非法操作"));
}
T_CH_Operation_list auditprocess = new T_CH_Operation_list();
//var cf = DB.V_CH_Checkfuncflow.Where(w => w.ID == check).ToList().FirstOrDefault();
var de = DB.T_GM_ApplyMaterial.Find(am.RefrenceNo);
var te = DB.T_GM_TempDetailMaterial.Where(m => m.Remark == am.RefrenceNo);
var stock = DB.T_GM_MaterialStock.Where(m => m.WarehouseID == am.EXWarehouse);
am.IMWarehouse = DB.V_GM_DetailProject.First(l => l.ProjectNo == de.ProjectNo).WarehouseID;
am.OperationListID = Guid.NewGuid().ToString();
am.Operator = user.EmployeeId;
am.OperationTime = DateTime.Now;
//am.EXTypeID=2;
DB.T_GM_EXWarehouse.Add(am);
auditprocess.ID = am.OperationListID;
auditprocess.Check_funcID = "-1"; //cf.CheckfuncID;
auditprocess.Check_flowID = "-1"; //cf.ID;
auditprocess.CreateTime = DateTime.Now;
auditprocess.State = (int)CheckState.Approved;
auditprocess.Url = Url.Action("MEXWarehouseAudit", "Share", new { gid = am.OperationListID });
auditprocess.Creator = user.EmployeeId;
DB.T_CH_Operation_list.Add(auditprocess);
int i = 0;
foreach (var item in dr.Material)
{
var detail = new T_GM_DM();
detail.Remark = am.OperationListID;
detail.MFlID = item;
var test = te.Where(m => m.MFlID == item).ToList().First();
test.Num -= dr.Num[i];
if (test.Num < 0)
{
return(this.Direct(false, "调库的数量超过申请单里剩余物料的数量！！！"));
}
DB.T_GM_TempDetailMaterial.Attach(test);
DB.Entry(test).State = EntityState.Modified;
var stocknum = stock.FirstOrDefault(m => m.MaterialID == item);
if (stocknum == null)
{
return(this.Direct(false, "物料" + item + "的数量超过仓库里剩余物料的数量！！！"));
}
stocknum.PurchaseAmount -= dr.Num[i];
if (stocknum.PurchaseAmount < 0)
{
return(this.Direct(false, "物料" + item + "的数量超过仓库里剩余物料的数量！！！"));
}
DB.T_GM_MaterialStock.Attach(stocknum);
DB.Entry(stocknum).State = EntityState.Modified;
detail.Type = "CGM";
detail.Num = dr.Num[i];
detail.Price = dr.Price[i];
detail.NO = am.EXID;
DB.T_GM_DM.Add(detail);
i++;
}
DB.SaveChanges();
if (cw.check(am.RefrenceNo))
{
de.ApplyMState = "deploying";
DB.T_GM_ApplyMaterial.Attach(de);
DB.Entry(de).State = EntityState.Modified;
DB.SaveChanges();
X.Msg.Alert("提示", "订单已配置完成，请等待审核", "parent.App.win.close();").Show();
return(this.Direct());
}
else
{
X.Msg.Alert("提示", "调拨单已配置成功！", "parent.App.win.close();").Show();
}
return(this.Direct());
}
//don't worry about modify the Apply_No,though modify opreation would use the trigger and modify the num,
//they can't use modify without audit,audit Apply_No isn't pass,they can't use Purchase_No
//只有通过审核的申请单才可以进行配置，尽管申请单号有多个，但通过审核的申请单号只有一个
public ActionResult MPurchaseSave(string list, string record, string pri, T_GM_PurchaseMaterial am)
{
DecResualt dr = new DecResualt();
dr = cw.Judge(list, pri, record);
switch (dr.JresualtName)
{
case JudgeResualt.IsNumNegative:
return(this.Direct(false, "数量不能为负数"));
case JudgeResualt.IsPriceNegative:
return(this.Direct(false, "价格不能为负数"));
case JudgeResualt.IsIllegal:
return(this.Direct());
case JudgeResualt.IsLegal:
break;
default:
return(this.Direct(false, "非法操作"));
}
T_CH_Operation_list auditprocess = new T_CH_Operation_list();
var cf = DB.V_CH_Checkfuncflow.Where(w => w.ID == am.CheckProcess).ToList().FirstOrDefault();
var de = DB.T_GM_ApplyMaterial.Find(am.AMGID);
var te = DB.T_GM_TempDetailMaterial.Where(m => m.Remark == am.AMGID);
am.GID = Guid.NewGuid().ToString();
am.Operator = user.EmployeeId;
am.OperateTime = DateTime.Now;
am.CheckProcess = cf.Name;
DB.T_GM_PurchaseMaterial.Add(am);
auditprocess.ID = am.GID;
auditprocess.Check_funcID = cf.CheckfuncID;
auditprocess.Check_flowID = cf.ID;
auditprocess.CreateTime = DateTime.Now;
auditprocess.State = 1;
auditprocess.Url = Url.Action("MPurchaseAudit", "Share", new { gid = am.GID });
auditprocess.Creator = user.EmployeeId;
DB.T_CH_Operation_list.Add(auditprocess);
int i = 0;
foreach (var item in dr.Material)
{
var detail = new T_GM_DM();
detail.Remark = am.GID;
detail.MFlID = item;
var test = te.Where(m => m.MFlID == item).ToList().First();
test.Num -= dr.Num[i];
if (test.Num < 0)
{
//X.Msg.Alert("警告", "采购的数量超过申请单里剩余物料的数量！！！").Show();
return(this.Direct(false, "采购的数量超过申请单里剩余物料的数量！！！"));
}
DB.T_GM_TempDetailMaterial.Attach(test);
DB.Entry(test).State = EntityState.Modified;
detail.Type = "CGM";
detail.Num = dr.Num[i];
detail.Price = dr.Price[i];
detail.NO = am.PurchaseMNo;
DB.T_GM_DM.Add(detail);
i++;
}
DB.SaveChanges();
if (cw.check(am.AMGID))
{
de.ApplyMState = "deploying";
DB.T_GM_ApplyMaterial.Attach(de);
DB.Entry(de).State = EntityState.Modified;
DB.SaveChanges();
X.Msg.Alert("提示", "订单已配置完成，请等待审核", "parent.App.win.close();").Show();
return(this.Direct());
}
return(this.Direct());
}
public ActionResult ModifySubmit(string list, string record, string price, string gid)
{
List <string> a = cw.JsontoList(list);
List <string> b = cw.JsontoList(price);
List <string> c = cw.JsontoList(record);
T_CH_Operation_list auditprocess = new T_CH_Operation_list();
var am_old = DB.T_GM_PurchaseMaterial.Find(gid);
var de = DB.T_GM_ApplyMaterial.Find(am_old.AMGID);
var te = DB.T_GM_TempDetailMaterial.Where(m => m.Remark == am_old.AMGID);
var am = new T_GM_PurchaseMaterial();
var cf = DB.V_CH_Checkfuncflow.Where(w => w.Name == am_old.CheckProcess).ToList().FirstOrDefault();
if (a.Count > 0 && a[0] != "")
{
am_old.OrderStatu = "modified once";
DB.T_GM_PurchaseMaterial.Attach(am_old);
DB.Entry(am_old).State = EntityState.Modified;
am.GID = Guid.NewGuid().ToString();
am.PurchaseMNo = am_old.PurchaseMNo;
am.SupplierID = am_old.SupplierID;
am.OrderType = am_old.OrderType;
am.OperateTime = DateTime.Now;
am.Operator = am_old.Operator;
am.AMGID = am_old.AMGID;
am.ProjectNo = am_old.ProjectNo;
am.CheckProcess = am_old.CheckProcess;
am.Remark = am_old.Remark;
am.ReceiptMethod = am_old.ReceiptMethod;
DB.T_GM_PurchaseMaterial.Add(am);
int i = 0;
decimal t, f;
auditprocess.ID = am.GID;
auditprocess.Check_funcID = cf.CheckfuncID;
auditprocess.Check_flowID = cf.ID;
auditprocess.CreateTime = DateTime.Now;
auditprocess.State = 1;
auditprocess.Url = Url.Action("MPurchaseAudit", "Share", new { gid = am.GID });
auditprocess.Creator = user.EmployeeId;
DB.T_CH_Operation_list.Add(auditprocess);
foreach (var item in a)
{
if (c[i] != "" && b[i] != "" && c[i] != "null" && b[i] != "null")
{
var detail = new T_GM_DM();
detail.Remark = am.GID;
detail.MFlID = item;
decimal.TryParse(c[i], out t);
decimal.TryParse(b[i], out f);
var test = te.Where(m => m.MFlID == item).ToList().First();
test.Num -= t;
if (test.Num < 0)
{
//X.Msg.Alert("警告", "采购的数量超过申请单里剩余物料的数量！！！").Show();
return(this.Direct(false, "采购的数量超过申请单里剩余物料的数量！！！"));
}
DB.T_GM_TempDetailMaterial.Attach(test);
DB.Entry(test).State = EntityState.Modified;
detail.Num = t;
detail.Price = f;
detail.NO = am.PurchaseMNo;
detail.Type = "CGM";
i++;
DB.T_GM_DM.Add(detail);
}
else
{
X.Msg.Alert("警告", "您输入数量或价格为空！！！").Show();
return(this.Direct());
}
}
DB.SaveChanges();
if (cw.check(am.AMGID))
{
de.ApplyMState = "deploying";
DB.T_GM_ApplyMaterial.Attach(de);
DB.Entry(de).State = EntityState.Modified;
DB.SaveChanges();
X.Msg.Alert("提示", "订单已配置完成，请等待审核", "parent.App.window3.close();").Show();
return(this.Direct());
}
return(this.Direct());
}
else
{
X.Msg.Alert("警告", "您尚未添加任何物料！！！").Show();
return(this.Direct());
}
}
public ActionResult AddOrEditOWApply(OWApply owapply)
{
owapply.StartTime = Convert.ToDateTime(owapply.StartTimeStr);
owapply.EndTime = Convert.ToDateTime(owapply.EndTimeStr);
if (owapply.StartTime < owapply.EndTime)
{
DirectResult r = new DirectResult();
T_HR_OverWorkApply owapplyupdate = entities.T_HR_OverWorkApply.Find(owapply.ID);
if (owapplyupdate == null)//为空为添加
{
owapply.ID = Guid.NewGuid().ToString();
owapply.OperationListID = Guid.NewGuid().ToString();
owapply.Valid = true;
owapply.CreaterName = new LoginUser().EmployeeId;
owapply.CreateTime = DateTime.Now;
T_CH_Operation_list newList = new T_CH_Operation_list();
newList.ID = owapply.OperationListID;
newList.State = (int)CheckState.Checking;//审核中
newList.Check_flowID = owapply.CheckFlowId;
newList.Check_funcID = owapply.FuncId;
newList.CreateTime = DateTime.Now;
newList.Creator = new LoginUser().EmployeeId;
newList.Url = Url.Action("CheckOverWorkApply", "OverWorkApply", new { id = owapply.ID });
entities.T_HR_OverWorkApply.Add(owapply.ToDB(1));
entities.T_CH_Operation_list.Add(newList);
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "保存成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
}
else//否则为修改
{
owapply.EditorName = new LoginUser().EmployeeId;
owapply.EditeTime = DateTime.Now;
owapplyupdate.Valid = false;
owapply.ID = Guid.NewGuid().ToString();
owapply.OperationListID = Guid.NewGuid().ToString();
owapply.Valid = true;
T_CH_Operation_list newList = new T_CH_Operation_list();
newList.ID = owapply.OperationListID;
newList.State = (int)CheckState.Checking;;//审核中
newList.Check_flowID = owapply.CheckFlowId;
newList.Check_funcID = owapply.FuncId;
newList.CreateTime = DateTime.Now;
newList.Creator = new LoginUser().EmployeeId;
newList.Url = Url.Action("CheckOverWorkApply", "OverWorkApply", new { id = owapply.ID });
entities.T_HR_OverWorkApply.Add(owapply.ToDB(2));
entities.T_CH_Operation_list.Add(newList);
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "保存成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
}
return(r);
}
else
{
X.Msg.Alert("警告", "调休加班时段错误！").Show();
return(this.Direct());
}
}
public ActionResult BudgetEdit(T_GM_Budget am, string list, string record, string pri)
{
T_CH_Operation_list auditprocess = new T_CH_Operation_list();
var cf = DB.V_CH_Checkfuncflow.Where(w => w.Name == am.AuditProgress).ToList().FirstOrDefault();
auditprocess.ID = Guid.NewGuid().ToString();
auditprocess.Check_funcID = cf.CheckfuncID;
auditprocess.Check_flowID = cf.ID;
auditprocess.CreateTime = DateTime.Now;
auditprocess.State = 1;
auditprocess.Url = Url.Action("ProjectBudgetAudit", "Share", new { gid = auditprocess.ID });
auditprocess.Creator = user.EmployeeId;
DB.T_CH_Operation_list.Add(auditprocess);
var am_new = new T_GM_Budget();
am_new.GID = auditprocess.ID;
am_new.AgentDate = DateTime.Now;
am_new.AgentMan = user.EmployeeId;
am_new.AuditProgress = cf.Name;
am_new.ClientName = am.ClientName;
am_new.CostMoney = am.CostMoney;
am_new.Extra = am.Extra;
am_new.LaborCost = am.LaborCost;
am_new.LaborOffer = am.LaborOffer;
am_new.MaterialCost = am.MaterialCost;
am_new.MaterialOffer = am.MaterialOffer;
am_new.OfferDate = am.OfferDate;
am_new.OfferMoney = am.OfferMoney;
am_new.OtherFeeCost = am.OtherFeeCost;
am_new.OtherFeeOffer = am.OtherFeeOffer;
am_new.ProjectName = am.ProjectName;
am_new.ProjectNo = am.ProjectNo;
am_new.QuotationNo = am.QuotationNo;
am_new.TaxRate = am.TaxRate;
am_new.Version = am.Version + 1;
am_new.RateMargin = am.RateMargin;
am_new.NetMargin = am.NetMargin;
var uploadfile = this.GetCmp <FileUploadField>("ModifyAttachmentPath");
int filesize = uploadfile.PostedFile.ContentLength;
string fileoldname = uploadfile.FileName;
if (filesize > 20 * 1024 * 1024)
{
X.Msg.Alert("提示", "上传文件过大，大小必须低于20M").Show();
return(this.Direct());
}
if (uploadfile.HasFile)
{
string filenewname = Guid.NewGuid().ToString() + Path.GetExtension(fileoldname);
string logicpath = "~/AttachFile/ProjectBudget/" + filenewname;
string filepath = Server.MapPath(logicpath);
am_new.AttachmentPath = logicpath;
uploadfile.PostedFile.SaveAs(filepath);
}
DB.T_GM_Budget.Add(am_new);
#region 添加物料
List <string> a = cw.JsontoList(list);
List <string> b = cw.JsontoList(pri);
List <string> c = cw.JsontoList(record);
List <decimal> num = cw.StrtoDec(c);
List <decimal> price = cw.StrtoDec(b);
if (!cw.IsPositiveNumArr(num))
{
return(this.Direct(false, "数量不能为负数"));
}
if (a.Count > 0 && a[0] != "" && a[0] != "null" && a.Count == num.Count && a.Count == price.Count)
{
int i = 0;
foreach (var item in a)
{
var detail = new T_GM_DM();
detail.Remark = am_new.GID;
detail.MFlID = item;
detail.Num = num[i];
detail.Price = price[i];
detail.NO = am.ProjectNo;
detail.Type = "BJD";
i++;
DB.T_GM_DM.Add(detail);
}
}
else
{
return(this.Direct());
}
#endregion
am = DB.T_GM_Budget.Find(am.GID);
am.BudgetStatus = "modified once";
DB.T_GM_Budget.Attach(am);
DB.Entry(am).State = EntityState.Modified;
DB.SaveChanges();
DirectResult re = new DirectResult();
re.IsUpload = true;
return(re);
}
public ActionResult BESubmit(BTApply businesstrip)
{
try
{
businesstrip.StartTime = Convert.ToDateTime(businesstrip.StartTimeStr);//计算TimeSpan
businesstrip.EndTime = Convert.ToDateTime(businesstrip.EndTimeStr);
}
catch (FormatException fe)
{
X.Msg.Alert("警告", "日期不正确，请检查！").Show();
return(this.Direct());
}
if (businesstrip.StartTime.Year == businesstrip.EndTime.Year && businesstrip.StartTime.Month == businesstrip.EndTime.Month && businesstrip.StartTime <= businesstrip.EndTime)
{
DirectResult r = new DirectResult();
string orid = businesstrip.ID;
var prelists = from o in entities.T_HR_BusinessTrip
where o.BTEdit == true && o.LastID == orid
select o;
foreach (T_HR_BusinessTrip item in prelists)
{
T_HR_BusinessTrip prelist = entities.T_HR_BusinessTrip.Find(item.ID);
prelist.BTEdit = false;
}
T_HR_BusinessTrip orlist = entities.T_HR_BusinessTrip.Find(orid);
orlist.BTEdit = true;
orlist.EditOrDelete = "Edit";
businesstrip.ID = Guid.NewGuid().ToString();
businesstrip.OperationListID = Guid.NewGuid().ToString();
businesstrip.Valid = false;
businesstrip.CreaterName = new LoginUser().EmployeeId;
businesstrip.CreateTime = DateTime.Now;
businesstrip.BTEdit = true;
businesstrip.BTDelete = false;
businesstrip.EditOrDelete = "";
businesstrip.LastID = orid;
//businesstrip.TimeSpan = GetTimeSpan(businesstrip.StartTime, businesstrip.EndTime);
//businesstrip.TiaoxiuHours = GetTH(businesstrip.StartTime, businesstrip.EndTime);
T_CH_Operation_list newList = new T_CH_Operation_list();
newList.ID = businesstrip.OperationListID;
newList.State = (int)CheckState.Checking;//审核中
newList.Check_flowID = businesstrip.CheckFlowId;
newList.Check_funcID = businesstrip.FuncId;
newList.CreateTime = DateTime.Now;
newList.Creator = new LoginUser().EmployeeId;
newList.Url = Url.Action("CheckBusinessTrip", "BusinessTrip", new { id = businesstrip.ID });
entities.T_HR_BusinessTrip.Add(businesstrip.ToDB(1));
entities.T_CH_Operation_list.Add(newList);
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "保存成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
return(r);
}
else
{
X.Msg.Alert("警告", "请假不可跨月！").Show();
return(this.Direct());
}
}
public ActionResult OrdinaryMApplyAdd(string list, string record, string pri, T_GM_ApplyMaterial am)
{
var re = DB.V_GM_DetailProject.Where(w => w.ProjectNo == am.ProjectNo).ToList().FirstOrDefault();
am.FPMGID = re.UID;
string wareid = re.WarehouseID;
#region 添加物料
List <string> a = cw.JsontoList(list); //编号
List <string> b = cw.JsontoList(pri); //价格
List <string> c = cw.JsontoList(record); //数量
List <decimal> num = cw.StrtoDec(c);
List <decimal> price = cw.StrtoDec(b);
var te = DB.T_GM_TempDetailMaterial.Where(m => m.Remark == am.FPMGID);
if (!cw.IsPositiveNumArr(num))
{
return(this.Direct(false, "数量不能为负数"));
}
if (a.Count > 0 && a[0] != "" && a[0] != "null" && a.Count == num.Count && a.Count == price.Count)
{
T_CH_Operation_list auditprocess = new T_CH_Operation_list();
var cf = DB.V_CH_Checkfuncflow.Where(w => w.ID == am.CheckProcess).ToList().FirstOrDefault();
am.GID = Guid.NewGuid().ToString();
am.CheckProcess = cf.Name;
am.ApplyMan = user.EmployeeId;
//am.ApplyMState = "deploying";
am.ApplyTime = DateTime.Now;
DB.T_GM_ApplyMaterial.Add(am);
auditprocess.ID = am.GID;
auditprocess.Check_funcID = cf.CheckfuncID;
auditprocess.Check_flowID = cf.ID;
auditprocess.CreateTime = DateTime.Now;
auditprocess.State = 1;
auditprocess.Url = Url.Action("MApplyAudit", "Share", new { gid = am.GID });
auditprocess.Creator = user.EmployeeId;
DB.T_CH_Operation_list.Add(auditprocess);
int i = 0;
foreach (var item in a)
{
var detail = new T_GM_DM();
detail.Remark = am.GID;
detail.MFlID = item;
var test = te.Where(m => m.MFlID == item).ToList().First();
test.Num -= num[i];
//var storage = DB.T_GM_MaterialStock.Where(m => m.MaterialID == item).Where(m => m.WarehouseID == wareid).ToList().FirstOrDefault();
decimal flag = 1; //--修改 物料申请不需要考虑库存
//if (storage!=null)
//{
// flag = (test.Num ?? 0) - storage.CurAmount;
//}
//else
//{
flag = test.Num ?? 0;
//}
if (flag < 0)
{
return(this.Direct(false, "申请的数量超过项目所需物资数量！！！"));
}
DB.T_GM_TempDetailMaterial.Attach(test);
DB.Entry(test).State = EntityState.Modified;
detail.Num = num[i];
detail.Price = price[i];
detail.NO = am.ApplyMaterialNo;
detail.Type = "SQM";
i++;
DB.T_GM_DM.Add(detail);
}
}
else
{
return(this.Direct());
}
#endregion
DB.SaveChanges();
return(this.Direct());
}
public ActionResult FAPurchaseSave(string list, string record, string price, string spid, T_GM_PurchaseFixedAsset am)
{
List <string> a = cw.JsontoList(list);
List <string> c = cw.JsontoList(record);
List <string> b = cw.JsontoList(price);
T_CH_Operation_list auditprocess = new T_CH_Operation_list();
var cf = DB.V_CH_Checkfuncflow.Where(w => w.ID == am.AuditProcess).ToList().FirstOrDefault();
var de = DB.T_GM_ApplyFixedAsset.Find(am.ApplyNo);
var te = DB.T_GM_TempDetailMaterial.Where(m => m.Remark == am.ApplyNo);
if (a.Count > 0 && cf != null)
{
am.GID = Guid.NewGuid().ToString();
am.AuditProcess = cf.Name;
am.Operator = user.EmployeeId;
am.OperateTime = DateTime.Now;
am.SupplierID = spid;
DB.T_GM_PurchaseFixedAsset.Add(am);
auditprocess.ID = am.GID;
auditprocess.Check_funcID = cf.CheckfuncID;
auditprocess.Check_flowID = cf.ID;
auditprocess.CreateTime = DateTime.Now;
auditprocess.State = 1;
auditprocess.Url = Url.Action("FAPurchaseAudit", "Share", new { gid = am.GID });
auditprocess.Creator = user.EmployeeId;
DB.T_CH_Operation_list.Add(auditprocess);
}
else
{
X.Msg.Alert("警告", "您尚未添加任何物料").Show();
return(this.Direct());
}
int i = 0;
decimal t, f;
foreach (var item in a)
{
if (c[i] != "" && b[i] != "" && c[i] != "null" && b[i] != "null")
{
var detail = new T_GM_DM();
detail.Remark = am.GID;
detail.MFlID = item;
decimal.TryParse(c[i], out t);
decimal.TryParse(b[i], out f);
var test = te.Where(m => m.MFlID == item).ToList().First();
test.Num -= t;
if (test.Num < 0)
{
//X.Msg.Alert("警告", "采购的数量超过申请单里剩余物料的数量！！！").Show();
return(this.Direct(false, "采购的数量超过申请单里剩余物料的数量！！！"));
}
DB.T_GM_TempDetailMaterial.Attach(test);
DB.Entry(test).State = EntityState.Modified;
detail.Type = "CGF";
detail.Num = t;
detail.Price = f;
detail.NO = am.PurchaseFNo;
DB.T_GM_DM.Add(detail);
i++;
}
else
{
X.Msg.Alert("警告", "物料数量不能为空").Show();
return(this.Direct());
}
}
DB.SaveChanges();
if (cw.check(am.ApplyNo))
{
de.Status = "deploying";
DB.T_GM_ApplyFixedAsset.Attach(de);
DB.Entry(de).State = EntityState.Modified;
DB.SaveChanges();
X.Msg.Alert("提示", "订单已配置完成,请耐心等待审核", "parent.App.window3.close();").Show();
return(this.Direct());
}
return(this.Direct());
}
public ActionResult AddOrEditBusinessTrip(BTApply businesstrip)
{
try
{
businesstrip.StartTime = Convert.ToDateTime(businesstrip.StartTimeStr);//计算TimeSpan
businesstrip.EndTime = Convert.ToDateTime(businesstrip.EndTimeStr);
}
catch (FormatException fe)
{
X.Msg.Alert("警告", "日期不正确，请检查！").Show();
return(this.Direct());
}
if (businesstrip.StartTime.Year == businesstrip.EndTime.Year && businesstrip.StartTime.Month == businesstrip.EndTime.Month && businesstrip.StartTime <= businesstrip.EndTime)
{
DirectResult r = new DirectResult();
T_HR_BusinessTrip businesstripupdate = entities.T_HR_BusinessTrip.Find(businesstrip.ID);
if (businesstripupdate == null)//为空为添加
{
//businesstrip.StartTime = Convert.ToDateTime(businesstrip.StartTimeStr);//计算TimeSpan
//businesstrip.EndTime = Convert.ToDateTime(businesstrip.EndTimeStr);
businesstrip.ID = Guid.NewGuid().ToString();
businesstrip.OperationListID = Guid.NewGuid().ToString();
businesstrip.Valid = true;
businesstrip.CreaterName = new LoginUser().EmployeeId;
businesstrip.CreateTime = DateTime.Now;
businesstrip.BTEdit = false;
businesstrip.BTDelete = false;
//businesstrip.TimeSpan = GetTimeSpan(businesstrip.StartTime, businesstrip.EndTime);
T_CH_Operation_list newList = new T_CH_Operation_list();
newList.ID = businesstrip.OperationListID;
newList.State = (int)CheckState.Checking;//审核中
newList.Check_flowID = businesstrip.CheckFlowId;
newList.Check_funcID = businesstrip.FuncId;
newList.CreateTime = DateTime.Now;
newList.Creator = new LoginUser().EmployeeId;
newList.Url = Url.Action("CheckBusinessTrip", "BusinessTrip", new { id = businesstrip.ID });
entities.T_HR_BusinessTrip.Add(businesstrip.ToDB(1));
entities.T_CH_Operation_list.Add(newList);
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "保存成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
}
else//否则为修改
{
//businesstrip.StartTime = Convert.ToDateTime(businesstrip.StartTimeStr);//计算TimeSpan
//businesstrip.EndTime = Convert.ToDateTime(businesstrip.EndTimeStr);
businesstrip.EditorName = new LoginUser().EmployeeId;
businesstrip.EditeTime = DateTime.Now;
businesstripupdate.Valid = false;
businesstrip.ID = Guid.NewGuid().ToString();
businesstrip.OperationListID = Guid.NewGuid().ToString();
businesstrip.Valid = true;
businesstrip.BTEdit = false;
businesstrip.BTDelete = false;
//businesstrip.TimeSpan = GetTimeSpan(businesstrip.StartTime, businesstrip.EndTime);
T_CH_Operation_list newList = new T_CH_Operation_list();
newList.ID = businesstrip.OperationListID;
newList.State = (int)CheckState.Checking;//审核中
newList.Check_flowID = businesstrip.CheckFlowId;
newList.Check_funcID = businesstrip.FuncId;
newList.CreateTime = DateTime.Now;
newList.Creator = new LoginUser().EmployeeId;
newList.Url = Url.Action("CheckBusinessTrip", "BusinessTrip", new { id = businesstrip.ID });
entities.T_HR_BusinessTrip.Add(businesstrip.ToDB(2));
entities.T_CH_Operation_list.Add(newList);
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "修改成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
}
return(r);
}
else
{
X.Msg.Alert("警告", "出差申请不可跨月！").Show();
return(this.Direct());
}
}
public bool Save(Controller controller, FileUtility fileUtility)
{
if (fileUtility.File.ContentLength != 0)
{
if (!fileUtility.SavaData())
{
return(false);
}
}
using (Entities db = new Entities())
{
try
{
T_US_DailyWorkReport workReport = new T_US_DailyWorkReport()
{
ID = Guid.NewGuid().ToString(),
AttachFile = AttachFile,
CreateTime = DateTime.Now,
Creator = new LoginUser().EmployeeId,
OperationID = Guid.NewGuid().ToString(),
Date = Date,
ProgressPercentage = ProgressPercentage,
ProjectID = ProjectID,
ProjectNo = ProjectNo,
ProjectName = ProjectName,
ProjectSite = ProjectSite,
Remark = Remark
};
db.T_US_DailyWorkReport.Add(workReport);
T_CH_Operation_list operation = new T_CH_Operation_list()
{
Check_flowID = CheckFlowId,
Check_funcID = CheckFucId,
CreateTime = DateTime.Now,
Creator = new LoginUser().EmployeeId,
ID = workReport.OperationID,
State = (int)CheckState.Checking,
Url = controller.Url.Action("Check", "DailyWorkReport", new { id = workReport.ID })
};
db.T_CH_Operation_list.Add(operation);
foreach (var hour in WorkHourses)
{
T_US_WorkHours workHours = new T_US_WorkHours()
{
DailyReportID = workReport.ID,
DutyHours = hour.DutyHours,
EmployeeID = hour.EmployeeID,
EmployeeName = hour.EmployeeName,
ExtraHours = hour.ExtraHours,
ID = Guid.NewGuid().ToString()
};
db.T_US_WorkHours.Add(workHours);
}
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public ActionResult ModifySubmit(string list, string record, string price, string gid)
{
//X.GetCmp<ComboBox>("");
List <string> a = cw.JsontoList(list);
List <string> b = cw.JsontoList(price);
List <string> c = cw.JsontoList(record);
T_CH_Operation_list auditprocess = new T_CH_Operation_list();
var am_old = DB.T_GM_ResidualM.Find(gid);
var am = new T_GM_ResidualM();
var cf = DB.V_CH_Checkfuncflow.Where(w => w.Name == am_old.AuditProcess).ToList().FirstOrDefault();
if (a.Count > 0 && a[0] != "")
{
am_old.Remark = "modified once";
DB.T_GM_ResidualM.Attach(am_old);
DB.Entry(am_old).State = EntityState.Modified;
am.GID = Guid.NewGuid().ToString();
am.SupplierID = am_old.SupplierID;
am.ResidualType = am_old.ResidualType;
am.ResidualNo = am_old.ResidualNo;
am.OperateTime = DateTime.Now;
am.Operator = am_old.Operator;
am.BackDate = DateTime.Now;
am.ProjectNo = am_old.ProjectNo;
am.AuditProcess = am_old.AuditProcess;
DB.T_GM_ResidualM.Add(am);
int i = 0;
decimal t, f;
auditprocess.ID = am.GID;
auditprocess.Check_funcID = cf.CheckfuncID;
auditprocess.Check_flowID = cf.ID;
auditprocess.CreateTime = DateTime.Now;
auditprocess.State = 1;
auditprocess.Url = Url.Action("MResidualAudit", "Share", new { id = am.GID });
auditprocess.Creator = user.EmployeeId;
DB.T_CH_Operation_list.Add(auditprocess);
foreach (var item in a)
{
if (c[i] != "" && b[i] != "" && c[i] != "null" && b[i] != "null")
{
var detail = new T_GM_DM();
detail.Remark = am.GID;
detail.MFlID = item;
decimal.TryParse(c[i], out t);
decimal.TryParse(b[i], out f);
detail.Num = t;
detail.Price = f;
detail.NO = am.ResidualNo;
detail.Type = "THM";
i++;
DB.T_GM_DM.Add(detail);
}
else
{
X.Msg.Alert("警告", "您输入数量或价格为空！！！").Show();
return(this.Direct());
}
}
DB.SaveChanges();
}
else
{
X.Msg.Alert("提示", "您尚未添加任何物料！！！").Show();
}
return(this.Direct());
}
//[VisitAuthorize(Read = false, Delete = false, Create = true, Update = true)]
public ActionResult MResidualSubmit(string list, string record, string pri, T_GM_ResidualM rm)
{
try
{
List <string> a = cw.JsontoList(list);
List <string> c = cw.JsontoList(record);
List <string> b = cw.JsontoList(pri);
T_CH_Operation_list auditprocess = new T_CH_Operation_list();
var cf = DB.V_CH_Checkfuncflow.Where(w => w.CheckfuncName == checkname).Where(w => w.ID == rm.AuditProcess).ToList().FirstOrDefault();
int i = 0;
decimal t, f;
if (a.Count > 0 && a[0] != "" && cf != null)
{
rm.GID = Guid.NewGuid().ToString();
rm.AuditProcess = cf.Name;
rm.Operator = user.EmployeeId;
rm.OperateTime = DateTime.Now;
rm.BackDate = DateTime.Now;
DB.T_GM_ResidualM.Add(rm);
auditprocess.ID = rm.GID;
auditprocess.Check_funcID = cf.CheckfuncID;
auditprocess.Check_flowID = cf.ID;
auditprocess.CreateTime = DateTime.Now;
auditprocess.State = 1;
auditprocess.Url = Url.Action("MResidualAudit", "Share", new { id = rm.GID });
auditprocess.Creator = user.EmployeeId;
DB.T_CH_Operation_list.Add(auditprocess);
foreach (var item in a)
{
if (c[i] != "" && b[i] != "" && c[i] != "null" && b[i] != "null")
{
T_GM_DM dm = new T_GM_DM();
decimal.TryParse(c[i], out t);
decimal.TryParse(b[i], out f);
dm.NO = rm.ResidualNo;
dm.Type = "THM";
dm.Num = t;
dm.Price = f;
dm.MFlID = a[i];
dm.Remark = rm.GID;
i++;
DB.T_GM_DM.Add(dm);
}
else
{
X.Msg.Alert("警告", "数量或价格不能为空").Show();
return(this.Direct());
}
}
DB.SaveChanges();
return(this.Direct());
}
else
{
X.Msg.Alert("提示", "你尚未选择任何材料").Show();
return(this.Direct());
}
}
catch (Exception e)
{
return(this.Direct(false, e.Message));
}
}
//[VisitAuthorize(Read = false, Delete = false, Create = true, Update = true)]
public ActionResult FAStorageSubmit(string list, string record, string pri, string wid, T_GM_StorageFixedAsset rm)
{
List <string> a = cw.JsontoList(list);
List <string> c = cw.JsontoList(record);
List <string> b = cw.JsontoList(pri);
var te = DB.T_GM_TempDetailMaterial.Where(w => w.Remark == rm.PFAGID);
var de = DB.T_GM_PurchaseFixedAsset.Find(rm.PFAGID);
T_CH_Operation_list auditprocess = new T_CH_Operation_list();
var cf = DB.V_CH_Checkfuncflow.Where(w => w.CheckfuncName == checkname).Where(w => w.ID == rm.AuditProcess).ToList().FirstOrDefault();
int i = 0;
decimal t, f;
if (a.Count > 0 && a[0] != "")
{
rm.GID = Guid.NewGuid().ToString();
rm.AuditProcess = cf.Name;
rm.WarehouseID = wid;
rm.Operator = user.EmployeeId;
rm.OperateTime = DateTime.Now;
rm.No_Date = DateTime.Now;
DB.T_GM_StorageFixedAsset.Add(rm);
auditprocess.ID = rm.GID;
auditprocess.Check_funcID = cf.CheckfuncID;
auditprocess.Check_flowID = cf.ID;
auditprocess.CreateTime = DateTime.Now;
auditprocess.State = 1;
auditprocess.Url = Url.Action("Variable", "Share", new { id = rm.GID });//"/gyproject/Share/Variable?id=" + rm.StorageNo + "&title=固定资产入库审核";
auditprocess.Creator = user.EmployeeId;
DB.T_CH_Operation_list.Add(auditprocess);
foreach (var item in a)
{
if (c[i] != "" && b[i] != "" && c[i] != "null" && b[i] != "null")
{
T_GM_DM dm = new T_GM_DM();
decimal.TryParse(c[i], out t);
decimal.TryParse(b[i], out f);
var test = te.Where(m => m.MFlID == item).ToList().First();
test.Num -= t;
if (test.Num < 0)
{
//X.Msg.Alert("警告", "收货实际数量超过采购数量！！！").Show();
return(this.Direct(false, "收货实际数量超过采购数量！！！"));
}
DB.T_GM_TempDetailMaterial.Attach(test);
DB.Entry(test).State = EntityState.Modified;
dm.NO = rm.StorageNo;
dm.Type = "SHF";
dm.Num = t;
dm.Price = f;
dm.MFlID = a[i];
dm.Remark = rm.GID;
i++;
DB.T_GM_DM.Add(dm);
}
else
{
X.Msg.Alert("警告", "物料数量不能为空").Show();
return(this.Direct());
}
}
DB.SaveChanges();
bool fl = true;
foreach (var item in DB.T_GM_TempDetailMaterial.Where(m => m.Remark == rm.PFAGID).ToList())
{
if (item.Num != 0)
{
fl = false;
break;
}
}
if (fl)
{
de.Status = "delivering";
DB.T_GM_PurchaseFixedAsset.Attach(de);
DB.Entry(de).State = EntityState.Modified;
DB.SaveChanges();
X.Msg.Alert("提示", "此采购单货物已完全送达，等待审核中", "parent.App.window2.close();").Show();
return(this.Direct());
}
}
else
{
X.Msg.Alert("警告", "物料数量不能为空").Show();
}
return(this.Direct());
}
//[VisitAuthorize(Read=false,Delete=false,Create=true,Update=true)]
/// <summary>
/// 注意看注释
/// </summary>
/// <param name="list"></param>
/// <param name="record"></param>
/// <param name="pri"></param>
/// <param name="wid"></param>
/// <param name="rm"></param>
/// <returns></returns>
public ActionResult MReceiptSubmit(string list, string record, string pri, T_GM_ReceiptMaterial rm, string AuditProcess)
{
List <string> a = cw.JsontoList(list);
List <string> c = cw.JsontoList(record);
List <string> b = cw.JsontoList(pri);
//这里是多张收货单确定一张采购单，与1张申请单配置多张采购单相反，
//所以数据库中收货表要取采购单的GID才能找到对应记录，而不是订单号
var te = DB.T_GM_TempDetailMaterial.Where(w => w.Remark == rm.PMNo);
var de = DB.T_GM_PurchaseMaterial.Find(rm.PMNo);
string IMNo = "IMW" + DateTime.Now.ToString("yyyyMMdd") + SerialNum.NewSerialNum();
string IMOpId = Guid.NewGuid().ToString();
int i = 0;
decimal t, f, totalprice = 0;
if (a.Count > 0 && a[0] != "")
{
//rm.ReceiptPlace = wid;
rm.ConfirmMan = user.EmployeeId;
rm.ConfirmTime = DateTime.Now;
rm.OperationLstId = IMOpId;
foreach (var item in a)
{
if (c[i] != "" && b[i] != "" && c[i] != "null" && b[i] != "null")
{
T_GM_DM dm = new T_GM_DM();
T_GM_DM IMWMat = new T_GM_DM();
decimal.TryParse(c[i], out t);
decimal.TryParse(b[i], out f);
var test = te.FirstOrDefault(m => m.MFlID == item);
if (test != null)
{
test.Num -= t;
if (test.Num < 0)
{
//X.Msg.Alert("警告","" ).Show();
return(this.Direct(false, "收货实际数量超过采购数量！！！"));
}
DB.T_GM_TempDetailMaterial.Attach(test);
DB.Entry(test).State = EntityState.Modified;
//入库物料
IMWMat.NO = IMNo;
IMWMat.Type = "PURIM";
IMWMat.Price = f;
IMWMat.MFlID = a[i];
IMWMat.Num = t;
IMWMat.Remark = IMOpId;
DB.T_GM_DM.Add(IMWMat);
}
//收货的物料
dm.NO = rm.ReceivePMNo;
dm.Type = "SHM";
dm.Num = t;
dm.Price = f;
dm.MFlID = a[i];
dm.Remark = rm.ReceivePMNo;
DB.T_GM_DM.Add(dm);
i++;
totalprice += t * f;
}
else
{
X.Msg.Alert("警告", "您输入数量或价格为空！！！").Show();
return(this.Direct());
}
}
rm.RMTotalPrice = totalprice;
DB.T_GM_ReceiptMaterial.Add(rm);
var project = DB.V_GM_DetailProject.FirstOrDefault(l => l.ProjectNo == rm.ProjectNo);
if (project == null)
{
return(this.Direct());
}
T_GM_IMWarehouse imw = new T_GM_IMWarehouse();
imw.IMDate = DateTime.Now;
imw.IMTypeID = 3;
imw.IMID = IMNo;
imw.IMWarehouseID = project.WarehouseID;
imw.ProjectID = rm.ProjectNo;
imw.RefrenceNo = rm.ReceivePMNo;
imw.Operator = user.EmployeeId;
imw.OperationTime = DateTime.Now;
imw.OperationListID = IMOpId;
DB.T_GM_IMWarehouse.Add(imw);
T_CH_Operation_list auditprocess = new T_CH_Operation_list();
var cf = DB.V_CH_Checkfuncflow.Where(w => w.CheckfuncName == checkname).Where(w => w.ID == AuditProcess).ToList().FirstOrDefault();
auditprocess.ID = imw.OperationListID;
auditprocess.Check_funcID = cf.CheckfuncID;
auditprocess.Check_flowID = cf.ID;
auditprocess.CreateTime = DateTime.Now;
auditprocess.State = 1;
auditprocess.Url = Url.Action("CheckIMAction", "IMWarehouse", new { id = IMNo });
auditprocess.Creator = user.EmployeeId;
DB.T_CH_Operation_list.Add(auditprocess);
DB.SaveChanges();
if (cw.check(rm.PMNo))
{
de.OrderStatu = "delivered";
DB.T_GM_PurchaseMaterial.Attach(de);
DB.Entry(de).State = EntityState.Modified;
DB.SaveChanges();
X.Msg.Alert("提示", "此采购单货物已完全送达", "parent.App.win.close();").Show();
return(this.Direct());
}
}
else
{
X.Msg.Alert("警告", "物料数量不能为空").Show();
}
X.Msg.AddScript("parent.App.win.close();");
return(this.Direct());
}
public ActionResult ModifySubmit(string list, string record, string price, string gid)
{
List <string> a = cw.JsontoList(list);
List <string> b = cw.JsontoList(price);
List <string> c = cw.JsontoList(record);
T_CH_Operation_list auditprocess = new T_CH_Operation_list();
var am_old = DB.T_GM_ApplyMaterial.Find(gid);
var am = new T_GM_ApplyMaterial();
var cf = DB.V_CH_Checkfuncflow.Where(w => w.Name == am_old.CheckProcess).ToList().FirstOrDefault();
if (a.Count > 0 && a[0] != "")
{
am_old.ApplyMState = "modified once";
DB.T_GM_ApplyMaterial.Attach(am_old);
DB.Entry(am_old).State = EntityState.Modified;
am.GID = Guid.NewGuid().ToString();
am.PrepaidDay = am_old.PrepaidDay;
am.Tel = am_old.Tel;
am.ApplyTime = DateTime.Now;
am.ApplyMan = am_old.ApplyMan;
am.FPMGID = am_old.FPMGID;
am.ApplyMaterialNo = am_old.ApplyMaterialNo;
am.CheckProcess = am_old.CheckProcess;
am.ProjectNo = am_old.ProjectNo;
am.Remark = am_old.Remark;
DB.T_GM_ApplyMaterial.Add(am);
int i = 0;
decimal t, f;
auditprocess.ID = am.GID;
auditprocess.Check_funcID = cf.CheckfuncID;
auditprocess.Check_flowID = cf.ID;
auditprocess.CreateTime = DateTime.Now;
auditprocess.State = 1;
auditprocess.Url = Url.Action("MApplyAudit", "Share", new { gid = am.GID });
auditprocess.Creator = user.EmployeeId;
DB.T_CH_Operation_list.Add(auditprocess);
foreach (var item in a)
{
if (c[i] != "" && b[i] != "" && c[i] != "null" && b[i] != "null")
{
var detail = new T_GM_DM();
detail.Remark = am.GID;
detail.MFlID = item;
decimal.TryParse(c[i], out t);
decimal.TryParse(b[i], out f);
detail.Num = t;
detail.Price = f;
detail.NO = am.ApplyMaterialNo;
detail.Type = "SQM";
i++;
DB.T_GM_DM.Add(detail);
}
else
{
X.Msg.Alert("警告", "您输入数量或价格为空！！！").Show();
return(this.Direct());
}
}
DB.SaveChanges();
//X.MessageBox.Alert("消息", "操作成功！", "history.go(-1);parent.location.reload();").Show();
return(this.Direct());
}
else
{
X.Msg.Alert("警告", "您尚未添加任何物料！！！").Show();
return(this.Direct());
}
}
public ActionResult AddOrEditDimission(DimissionApply dimission)
{
var dt = (from o in entities.T_HR_Dimission
where o.StaffID == dimission.StaffID && o.IsValid == true
select o).ToList();
if (!dt.Any())
{
DirectResult r = new DirectResult();
T_HR_Dimission dimissionupdate = entities.T_HR_Dimission.Find(dimission.ID);
if (dimissionupdate == null)//为空为添加
{
dimission.ID = Guid.NewGuid().ToString();
dimission.OperationListID = Guid.NewGuid().ToString();
dimission.Num = GetDimissionNum(dimission.StaffID);
dimission.IsValid = true;
dimission.CreaterName = new LoginUser().EmployeeId;
dimission.CreateTime = DateTime.Now;
T_CH_Operation_list newList = new T_CH_Operation_list();
newList.ID = dimission.OperationListID;
newList.State = 1;//审核中
newList.Check_flowID = dimission.CheckFlowId;
newList.Check_funcID = dimission.FuncId;
newList.CreateTime = DateTime.Now;
newList.Creator = new LoginUser().EmployeeId;
newList.Url = Url.Action("CheckDimission", "Dimission", new { id = dimission.ID });
entities.T_HR_Dimission.Add(dimission.ToT_HR_Dimission(1));
entities.T_CH_Operation_list.Add(newList);
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "保存成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
}
else//否则为修改
{
dimission.EditorName = new LoginUser().EmployeeId;
dimission.EditeTime = DateTime.Now;
dimission.ID = Guid.NewGuid().ToString();
dimission.OperationListID = Guid.NewGuid().ToString();
dimission.IsValid = true;
dimissionupdate.IsValid = false;
T_CH_Operation_list newList = new T_CH_Operation_list();
newList.ID = dimission.OperationListID;
newList.State = (int)CheckState.Checking;;//审核中
newList.Check_flowID = dimission.CheckFlowId;
newList.Check_funcID = dimission.FuncId;
newList.CreateTime = DateTime.Now;
newList.Creator = new LoginUser().EmployeeId;
newList.Url = Url.Action("CheckDimission", "Dimission", new { id = dimission.ID });
entities.T_HR_Dimission.Add(dimission.ToT_HR_Dimission(2));
entities.T_CH_Operation_list.Add(newList);
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "保存成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
}
return(r);
}
else
{
X.Msg.Alert("警告", "该员工已存在离职记录，不可重复添加！").Show();
return(this.Direct());
}
}
