public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*,(select TOP 1 PartFigureCode from PRS_Process_BOM where PartCode=MES_WorkingTicket.PartCode) PartFigureCode</select>
<from>MES_WorkingTicket</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'>
<field name='WorkTicketCode' cp='like'></field>
<field name='ApsCode' cp='like'></field>
<field name='TeamName' cp='like'></field>
<field name='WorkshopName' cp='like'></field>
<field name='ProcessName' cp='like'></field>
<field name='WorkStepsName' cp='like'></field>
<field name='EquipmentName' cp='like'></field>
</where>
</settings>");
var service = new MES_WorkingTicketService();
//string WorkshopCodeStr = "'nodata'";
//var WorkshopCodeList = new SYS_WorkGroupService()
// .GetModelList(ParamQuery.Instance()
// .Select("DISTINCT b.DepartID")
// .From("SYS_WorkGroupDetail a LEFT JOIN SYS_WorkGroup b ON a.MainID=b.ID")
// .AndWhere("a.UserCode", MmsHelper.GetUserCode()));
var user = new SYS_BN_UserService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("UserCode", MmsHelper.GetUserCode()));
//if (WorkshopCodeList.Count > 0)
//{
// WorkshopCodeStr = "'" + string.Join("','", WorkshopCodeList.Select(a => a.DepartID)) + "'";
//}
var pQuery = query.ToParamQuery();
//var result = service.GetDynamicListWithPaging(pQuery.AndWhere("WorkshopCode", user.DepartmentCode));
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
public ActionResult Index(int id = 0)
{
var loginer = FormsAuth.GetUserData <LoginerBase>();
SYS_BN_Department department = new SYS_BN_Department();
if (id == 10)
{
var user = new SYS_BN_UserService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("UserCode", MmsHelper.GetUserCode()));
department = new SYS_BN_DepartmentService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("DepartmentCode", user.DepartmentCode));
}
//var dapart=new SYS_BN_DepartmentService().get
var warehouse = new SYS_BN_WarehouseService().GetWarehouseByCode(loginer.UserCode);
uc = new sys_codeService().Getsys_codeByTypeAndID("BillType", id);
ViewBag.uc = uc;
var model = new
{
urls = new
{
query = "/api/Mms/WMS_BN_BillMain",
remove = "/api/Mms/WMS_BN_BillMain/",
billno = "/api/Mms/WMS_BN_BillMain/getnewbillno",
audit = "/api/Mms/WMS_BN_BillMain/audit/",
edit1 = "/Mms/WMS_BN_BillMain/edit/",
edit2 = "/Mms/WMS_BN_BillMain/customerEdit/?id=newid&type=" + id
},
resx = new
{
detailTitle = uc.Text + "明细",
noneSelect = "请先选择一条单据！",
deleteConfirm = "确定要删除选中的单据吗？",
deleteSuccess = "删除成功！",
auditSuccess = "单据已审核！"
},
dataSource = new
{
//dsPurpose = new sys_codeService().GetValueTextListByType("Purpose")
},
form = new
{
BillCode = "",
ContractCode = "",
ProjectName = "",
DepartmentID = department.DepartmentCode ?? "",
DepartmentName = department.DepartmentName ?? "",
SupplierCode = "",
SupplierName = "",
WarehouseCode = "",
WarehouseName = "",
ApproveState = 1
},
idField = "ID"
};
return(View(model));
}
public ActionResult Edit(string id = "")
{
dynamic depart = new SYS_BN_UserService().GetDepartment(MmsHelper.GetUserCode());
string code = string.Empty;
string name = string.Empty;
if (depart != null)
{
code = depart.DepartmentCode;
name = depart.DepartmentName;
}
if (string.IsNullOrEmpty(code))
{
return(JavaScript("请先维护所属车间!"));
}
var data = new MES_WorkshopPurchaseDetailApiController().GetPageData(id);
var model = new
{
urls = new
{
getdata = "/api/Mms/MES_WorkshopPurchaseDetail/GetPageData/", //获取主表数据及数据滚动数据api
edit = "/api/Mms/MES_WorkshopPurchaseDetail/edit/", //数据保存api
audit = "/api/Mms/MES_WorkshopPurchaseDetail/audit/", //审核api
newkey = "/api/Mms/MES_WorkshopPurchaseDetail/GetNewRowId/", //获取新的明细数据的主键(日语叫采番)
storageSave = "/api/Mms/MES_WorkshopPurchaseDetail/PostStorage/" //审核方法
},
resx = new
{
rejected = "已撤消修改！",
editSuccess = "保存成功！",
auditPassed = "单据已通过审核！",
auditReject = "单据已取消审核！"
},
dataSource = new
{
pageData = data
//payKinds = codeService.GetValueTextListByType("PayType")
},
form = new
{
defaults = new MES_WorkshopPurchaseMain().Extend(new { ID = id, WorkshopPurchaseCode = data.form == null ? "系统生成" : data.form.WorkshopPurchaseCode, WorkshopID = code, WorkshopName = name, PurchaseStatus = 1, ApproveState = 1, CreateTime = "", IsEnable = 1 }),
primaryKeys = new string[] { "ID" }
},
tabs = new object[] {
new{
type = "grid",
rowId = "ID",
relationId = "ID",
postFields = new string[] { "ID", "MainID", "Model", "Spec", "Remark", "InventoryCode", "InventoryName", "MeterialName", "WriteModel", "WriteSpec", "PurchaseQuantity" },
defaults = new { ID = "", MainID = id, InventoryCode = "", InventoryName = "", PurchaseQuantity = "", IsEnable = 1 }
}
}
};
return(View(model));
}
public ActionResult Edit(string id = "")
{
var data = new SYS_WorkGroupDetailApiController().GetPageData(id);
dynamic depart = new SYS_BN_UserService().GetDepartment(MmsHelper.GetUserCode());
string code = string.Empty;
string name = string.Empty;
if (depart != null)
{
code = depart.DepartmentCode;
name = depart.DepartmentName;
}
if (string.IsNullOrEmpty(code))
{
return(JavaScript("请先维护所属车间!"));
}
var model = new
{
urls = new
{
getdata = "/api/Mms/SYS_WorkGroupDetail/GetPageData/", //获取主表数据及数据滚动数据api
edit = "/api/Mms/SYS_WorkGroupDetail/edit/", //数据保存api
audit = "/api/Mms/SYS_WorkGroupDetail/audit/", //审核api
newkey = "/api/Mms/SYS_WorkGroupDetail/GetNewRowId/" //获取新的明细数据的主键(日语叫采番)
},
resx = new
{
rejected = "已撤消修改！",
editSuccess = "保存成功！",
auditPassed = "单据已通过审核！",
auditReject = "单据已取消审核！"
},
dataSource = new
{
pageData = data,
//payKinds = codeService.GetValueTextListByType("PayType")
},
form = new
{
defaults = new SYS_WorkGroup().Extend(new { ID = id, TeamCode = data.form == null ? "系统生成" : data.form.TeamCode, TeamName = "", DepartID = code, DepartName = name, IsEnable = 1 }),
primaryKeys = new string[] { "ID" }
},
tabs = new object[] {
new{
type = "grid",
rowId = "ID",
relationId = "ID",
postFields = new string[] { "ID", "MainID", "UserCode", "UserName", "IsEnable" },
defaults = new { ID = "", MainID = id, UserCode = "", UserName = "", IsEnable = "1" }
}
}
};
return(View(model));
}
public ActionResult Index()
{
dynamic depart = new SYS_BN_UserService().GetDepartment(MmsHelper.GetUserCode());
string code = string.Empty;
if (depart != null)
{
code = depart.DepartmentCode;
}
var model = new
{
dataSource = new
{
},
urls = new
{
query = "/api/Mms/APS_ProjectProduceDetial",
newkey = "/api/Mms/APS_ProjectProduceDetial/getnewkey",
edit = "/api/Mms/APS_ProjectProduceDetial/edit",
},
resx = new
{
noneSelect = "请先选择一条数据！",
editSuccess = "保存成功！",
auditSuccess = "单据已审核！"
},
form = new
{
ContractCode = "",
PartCode = "",
ProductName = "",
WorkshopID = code,
WorkshopID2 = "",
EquipmentID = "",
WorkGroupID = "",
PlanedStartTime = "",
PlanedFinishTime = "",
PlanState = "1",
ProductPlanCode = "",
PlanType = "1",
DesignTaskCode = ""
},
defaultRow = new
{
},
setting = new
{
idField = "ID",
postListFields = new string[] { "ID", "ContractCode", "ProjectDetailID", "ProductPlanMainID", "PartCode", "ProcessCode", "WorkshopID", "EquipmentID", "WorkGroupID", "WorkshopName", "EquipmentName", "WorkGroupName", "Quantity", "ManHour", "Unit", "EarliestStartTime", "LatestStartTime", "PlanedStartTime", "EarliestFinishTime", "LatestFinishTime", "PlanedFinishTime", "ActualStartTime", "ActualFinishTime", "FloatingHour", "PlanColor", "PlanState", "PlanType" }
}
};
return(View(model));
}
/// <summary>
/// 采购接单主界面
/// </summary>
/// <returns></returns>
public ActionResult Index2()
{
var code = new sys_codeService();
dynamic depart = new SYS_BN_UserService().GetDepartment(MmsHelper.GetUserCode());
string departcode = string.Empty;
string departname = string.Empty;
if (depart != null)
{
departcode = depart.DepartmentCode;
departname = depart.DepartmentName;
}
var model = new
{
dataSource = new
{
},
urls = new
{
query = "/api/Mms/APS_ProductPurchaseDetail1",
newkey = "/api/Mms/APS_ProductPurchaseDetail1/getnewkey",
edit = "/api/Mms/APS_ProductPurchaseDetail1/edit"
},
resx = new
{
noneSelect = "请先选择一条数据！",
editSuccess = "保存成功！",
auditSuccess = "单据已审核！"
},
form = new
{
WarehouseName = "",
PurchaseDate = "",
ContractCode = "",
ProjectName = "",
SaleMan = MmsHelper.GetUserName(),
UserCode = MmsHelper.GetUserCode(),
DepartmentCode = departcode
},
defaultRow = new
{
},
setting = new
{
idField = "ID",
postListFields = new string[] { "ID", "MainID", "InventoryCode", "SingleProductRequestQuantity", "TotalRequestQuantity", "Remark", "PurchaseState", "IsEnable", "CreatePerson", "CreateTime", "ModifyPerson", "ModifyTime", "PurchaseQuantity", "StockQuantity", "RequestedQuantity", "SaleMan", "DepartmentCode", "DepartmentName", "WarehouseCode", "WarehouseName", "SupplierCode", "SupplierName", "OrderQuantity", "PurchaseFeedback", "PurchaseRemark", "UserCode", "PurchaseDate" }
}
};
return(View(model));
}
public void Edit(dynamic data)
{
var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>
SYS_BN_User
</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>");
var service = new SYS_BN_UserService();
var result = service.Edit(null, listWrapper, data);
}
public ActionResult Index()
{
dynamic depart = new SYS_BN_UserService().GetDepartment(MmsHelper.GetUserCode());
string code = string.Empty;
string name = string.Empty;
if (depart != null)
{
code = depart.DepartmentCode;
name = depart.DepartmentName;
}
if (string.IsNullOrEmpty(code))
{
return(JavaScript("请先维护所属车间!"));
}
var model = new
{
dataSource = new
{
},
urls = new
{
query = "/api/Mms/APS_ProjectProduceTemporaryTask",
newkey = "/api/Mms/APS_ProjectProduceTemporaryTask/getnewkey",
edit = "/api/Mms/APS_ProjectProduceTemporaryTask/edit",
audit1 = "/api/Mms/APS_ProjectProduceTemporaryTask/GetAudit1"
},
resx = new
{
noneSelect = "请先选择一条数据！",
editSuccess = "保存成功！",
auditSuccess = "单据已审核！"
},
form = new
{
ContractCode = ""
},
defaultRow = new
{
BillCode = "系统生成"
},
setting = new
{
idField = "ID",
postListFields = new string[] { "ID", "TemporaryTaskDec", "ContractCode", "ProjectDetailID", "ProductPlanMainID", "PartCode", "ProcessCode", "ProcessLineCode", "WorkshopID", "WorkshopName", "EquipmentID", "EquipmentName", "WorkGroupID", "WorkGroupName", "Quantity", "ManHour", "Unit", "EarliestStartTime", "LatestStartTime", "PlanedStartTime", "EarliestFinishTime", "LatestFinishTime", "PlanedFinishTime", "ActualStartTime", "ActualFinishTime", "FloatingHour", "PlanColor", "PlanState", "PlanType", "IsEnable", "CreatePerson", "CreateTime", "ModifyPerson", "ModifyTime", "ApproveState", "ApprovePerson", "ApproveDate", "ApproveRemark", "ApsCode", "BillCode" }
}
};
return(View(model));
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ID'>
<select>*</select>
<from>SYS_BN_User</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'>
<field name='UserName' cp='like'></field>
<field name='DepartmentCode' cp='equal'></field>
<field name='IsEnable' cp='equal'></field>
</where>
</settings>");
var service = new SYS_BN_UserService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
public ActionResult Index()
{
var loginer = FormsAuth.GetUserData <LoginerBase>();
SYS_BN_Department department = new SYS_BN_Department();
var user = new SYS_BN_UserService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("UserCode", MmsHelper.GetUserCode()));
department = new SYS_BN_DepartmentService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("DepartmentCode", user.DepartmentCode));
var model = new
{
urls = new
{
query = "/api/Mms/MES_MaterialReturnMain",
remove = "/api/Mms/MES_MaterialReturnMain/",
billno = "/api/Mms/MES_MaterialReturnMain/getnewbillno",
audit = "/api/Mms/MES_MaterialReturnMain/audit/",
edit1 = "/Mms/MES_MaterialReturnMain/edit/"
},
resx = new
{
detailTitle = "车间退料明细",
noneSelect = "请先选择一条单据！",
deleteConfirm = "确定要删除选中的单据吗？",
deleteSuccess = "删除成功！",
auditSuccess = "单据已审核！"
},
dataSource = new
{
//dsPurpose = new sys_codeService().GetValueTextListByType("Purpose")
},
form = new
{
BillCode = "",
DepartmentID = department.DepartmentCode ?? "",
DepartmentName = department.DepartmentName ?? ""
},
idField = "ID"
};
return(View(model));
}
public ActionResult Index()
{
var user = new SYS_BN_UserService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("UserCode", MmsHelper.GetUserCode()));
string workshopName = new SYS_BN_DepartmentService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("DepartmentCode", user.DepartmentCode ?? "")).DepartmentName ?? "";
var model = new
{
urls = new
{
query = "/api/Mms/MES_WorkshopBatching",
remove = "/api/Mms/MES_WorkshopBatching/",
billno = "/api/Mms/MES_WorkshopBatching/getnewbillno",
audit = "/api/Mms/MES_WorkshopBatching/audit/",
edit1 = "/Mms/MES_WorkshopBatching/edit/"
},
resx = new
{
detailTitle = "单据明细",
noneSelect = "请先选择一条单据！",
deleteConfirm = "确定要删除选中的单据吗？",
deleteSuccess = "删除成功！",
auditSuccess = "单据已审核！"
},
dataSource = new
{
//dsPurpose = new sys_codeService().GetValueTextListByType("Purpose")
},
form = new
{
BatchingCode = "",
ContractCode = "",
DepartmentName = workshopName,
//WorkshopCode = "",
},
idField = "BatchingCode"
};
return(View(model));
}
public ActionResult Index()
{
var user = MmsHelper.GetUserCode();
var department = new SYS_BN_UserService().GetDepartment(user);
var model = new
{
urls = new
{
query = "/api/Mms/SYS_WorkGroup",
remove = "/api/Mms/SYS_WorkGroup/",
billno = "/api/Mms/SYS_WorkGroup/getnewbillno",
audit = "/api/Mms/SYS_WorkGroup/audit/",
edit1 = "/Mms/SYS_WorkGroup/edit/"
},
resx = new
{
detailTitle = "班组管理明细",
noneSelect = "请先选择一条单据！",
deleteConfirm = "确定要删除选中的单据吗？",
deleteSuccess = "删除成功！",
auditSuccess = "单据已审核！"
},
dataSource = new
{
//dsPurpose = new sys_codeService().GetValueTextListByType("Purpose")
},
form = new
{
TeamCode = "",
DepartID = department.DepartmentCode,
DepartName = department.DepartmentName,
TeamName = ""
},
idField = "ID"
};
return(View(model));
}
public ActionResult Edit(string id = "")
{
var data = new MES_MaterialReturnDetailApiController().GetPageData(id);
var dpartment = new SYS_BN_UserService().GetDepartmentInfo(MmsHelper.GetUserCode());
var departid = "";
var departname = "";
if (dpartment.DepartmentCode != null)
{
departid = dpartment.DepartmentCode.ToString();
departname = dpartment.DepartmentName;
}
string dtNow = DateTime.Now.ToString("yyyy-MM-dd");
var model = new
{
urls = new
{
getdata = "/api/Mms/MES_MaterialReturnDetail/GetPageData/", //获取主表数据及数据滚动数据api
edit = "/api/Mms/MES_MaterialReturnDetail/edit/", //数据保存api
audit = "/api/Mms/MES_MaterialReturnDetail/audit/", //审核api
newkey = "/api/Mms/MES_MaterialReturnDetail/GetNewRowId/", //获取新的明细数据的主键(日语叫采番)
storageSave = "/api/Mms/MES_MaterialReturnDetail/PostStorage/"
},
resx = new
{
rejected = "已撤消修改！",
editSuccess = "保存成功！",
auditPassed = "单据已通过审核！",
auditReject = "单据已取消审核！"
},
dataSource = new
{
pageData = data
//payKinds = codeService.GetValueTextListByType("PayType")
},
form = new
{
defaults = new MES_MaterialReturnMain().Extend(new
{
ID = id,
BillCode = data.form == null ? "系统生成" : data.form.BillCode,
PickBillCode = "",
DepartmentID = dpartment.DepartmentCode ?? "",
DepartmentName = dpartment.DepartmentName ?? "",
ReturnDate = dtNow,
ContractCode = "",
ProjectName = "",
WarehouseCode = "",
WarehouseName = "",
Billstate = 1,
IsEnable = 1
}),
primaryKeys = new string[] { "ID" }
},
tabs = new object[] {
new{
type = "grid",
rowId = "ID",
relationId = "ID",
/*
* Unit VARCHAR(20) NULL
* Model VARCHAR(20) NULL
* Material VARCHAR(20) NUL
*/
postFields = new string[] { "ID", "MainID", "ContractCode", "ProjectName", "InventoryCode", "InventoryName", "ReturnQuantity", "IsEnable", "Unit", "Model", "Material" },
defaults = new { ID = "", MainID = id, ContractCode = "", ProjectName = "", InventoryCode = "", InventoryName = "", ReturnQuantity = "", IsEnable = 1, Unit = "", Model = "", Material = "" }
}
}
};
return(View(model));
}
public ActionResult customerEdit(string id = "", string type = "")
{
uc = new sys_codeService().Getsys_codeByTypeAndID("BillType", int.Parse(type));
ViewBag.uc = uc;
var loginer = FormsAuth.GetUserData <LoginerBase>();
var user = new SYS_BN_UserService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("UserCode", loginer.UserCode));
//var department = new SYS_BN_UserService().GetDepartmentInfo(MmsHelper.GetUserCode());
var department = new SYS_BN_DepartmentService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("DepartmentCode", user.DepartmentCode));
SYS_BN_Warehouse warehouse = new SYS_BN_Warehouse();
if (department.DepartmentCode == "0107")
{
warehouse = new SYS_BN_WarehouseService().GetModel(ParamQuery.Instance().AndWhere("IsEnable", 1).AndWhere("UserCode", MmsHelper.GetUserCode()));
}
else
{
warehouse = new SYS_BN_WarehouseService().GetModel(ParamQuery.Instance().AndWhere("ISEnable", 1).AndWhere("WarehouseName", department.DepartmentName));
}
//var department=new SYS_BN_DepartmentService().GetIDNameList(MmsHelper.GetUserCode())
warehouse = warehouse ?? new SYS_BN_Warehouse();
ViewBag.user = warehouse.WarehouseCode == null ? 0 : 1;
var data = new WMS_BN_BillDetailApiController().GetPageData(id);
string billCode = new WMS_BN_BillMainService().GetBillCodeByID(id);
//string documentNo = MmsHelper.GetOrderNumber("WMS_BN_BillMain", "BillCode", uc.Description, "", "");
var model = new
{
urls = new
{
getdata = "/api/Mms/WMS_BN_BillDetail/GetPageData/", //获取主表数据及数据滚动数据api
edit = "/api/Mms/WMS_BN_BillDetail/edit/", //数据保存api
audit = "/api/Mms/WMS_BN_BillDetail/audit/", //审核api
newkey = "/api/Mms/WMS_BN_BillDetail/GetNewRowId/", //获取新的明细数据的主键(日语叫采番)
storageSave = "/api/Mms/WMS_BN_BillDetail/PostStorage/"
},
resx = new
{
rejected = "已撤消修改！",
editSuccess = "保存成功！",
auditPassed = "单据已通过审核！",
auditReject = "单据已取消审核！"
},
dataSource = new
{
pageData = data,
DepartmentID = department.DepartmentCode,
DepartmentName = department.DepartmentName,
WarehouseCode = warehouse.WarehouseCode,
//payKinds = codeService.GetValueTextListByType("PayType")
},
form = new
{
defaults = new WMS_BN_BillMain().Extend(new { ID = data.scrollKeys.current, BillCode = data.form == null ? "系统生成" : data.form.BillCode, BillType = uc.Value, ContractCode = "", DepartmentID = "", DepartmentName = "", SupplierCode = "", WarehouseCode = warehouse.WarehouseCode, WarehouseName = warehouse.WarehouseName, ApproveState = "1", ApprovePerson = "", ApproveDate = "", ApproveRemark = "", Remark = "", CreatePerson = MmsHelper.GetUserName(), CreateTime = DateTime.Now, ModifyPerson = MmsHelper.GetUserName(), ModifyTime = DateTime.Now }),
primaryKeys = new string[] { "ID" }
},
tabs = new object[] {
new{
type = "grid",
rowId = "ID",
relationId = "ID",
postFields = new string[] { "ID", "BillCode", "OrderBillCode", "InventoryCode", "InventoryName", "Specs", "Unit", "MateNum", "ConfirmNum", "UnitPrice", "TotalPrice", "PackageCode", "BatchCode", "PBillCode", "AccountabilityCode", "Remark", "CreatePerson", "CreateTime", "ModifyPerson", "ModifyTime", "IsEnable" },
defaults = new { ID = "", BillCode = billCode, InventoryCode = "", InventoryName = "", Unit = "", MateNum = "", ConfirmNum = "", PackageCode = "", BatchCode = "", PBillCode = "", AccountabilityCode = "", Remark = "", CreatePerson = "", CreateTime = "", ModifyPerson = "", ModifyTime = "", IsEnable = 1 }
}
}
};
return(View("Edit", model));
}
public void Edit(dynamic data)
{
dynamic depart = new SYS_BN_UserService().GetDepartment(MmsHelper.GetUserCode());
string code = string.Empty;
string name = string.Empty;
if (depart != null)
{
code = depart.DepartmentCode;
name = depart.DepartmentName;
}
var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>
APS_ProjectProduceTemporaryTask
</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>");
var service = new APS_ProjectProduceTemporaryTaskService();
if (data.list.inserted.ToString() != "[]")
{
var dno = MmsHelper.GetOrderNumber("APS_ProjectProduceTemporaryTask", "BillCode", "LLRW", "", "");
var fno = dno.Substring(0, 10);
var con = dno.Substring(10, 3);
foreach (JToken row in data["list"]["inserted"].Children())
{
var pQuery = ParamQuery.Instance().Select("ApproveState").AndWhere("ID", row["ID"]);
var re = new APS_ProjectProduceTemporaryTaskService().GetModel(pQuery);
if (re != null && re.ApproveState == "1")
{
MmsHelper.ThrowHttpExceptionWhen(true, "以审核不能保存", 0);
return;
}
row["BillCode"] = fno + con;
int intCon = Convert.ToInt32(con);
intCon++;
var zeros = 3 - intCon.ToString().Length;
con = "";
for (int i = 1; i <= zeros; i++)
{
con += "0";
}
con += intCon.ToString();
row["LaunchWorkshopID"] = code;
row["LaunchWorkshopName"] = name;
row["IsEnable"] = 1;
}
}
if (data.list.deleted.ToString() != "[]")
{
foreach (JToken row in data["list"]["deleted"].Children())
{
var pQuery = ParamQuery.Instance().Select("ApproveState").AndWhere("ID", row["ID"]);
var re = new APS_ProjectProduceTemporaryTaskService().GetModel(pQuery);
if (re != null && re.ApproveState == "1")
{
MmsHelper.ThrowHttpExceptionWhen(true, "以审核不能删除", 0);
return;
}
row["IsEnable"] = 0;
}
}
var result = service.Edit(null, listWrapper, data);
}
public void Edit(dynamic data)
{
dynamic depart = new SYS_BN_UserService().GetDepartment(MmsHelper.GetUserCode());
string code = string.Empty;
string name = string.Empty;
if (depart != null)
{
code = depart.DepartmentCode;
name = depart.DepartmentName;
}
if (data.form["TeamCode"] == "系统生成")
{
if (data.form["TeamName"] == "")
{
MmsHelper.ThrowHttpExceptionWhen(true, "班组名称不能为空！", 0);
return;
}
string documentNo = MmsHelper.GetOrderNumber("SYS_WorkGroup", "BillCode", code, "", "");
data.form["BillCode"] = documentNo;
documentNo = documentNo.Replace(DateTime.Now.ToString("yyMMdd") + "0", "");
data.form["TeamCode"] = documentNo;
}
foreach (JToken tab in data["tabs"].Children())
{
foreach (JProperty item in tab.Children())
{
if (item.Name == "deleted")
{
continue;
}
foreach (var row in item.Value.Children())
{
var pQuery = ParamQuery.Instance().Select("ID").AndWhere("UserCode", row["UserCode"]).AndWhere("IsEnable", 1);
var re = new SYS_WorkGroupDetailService().GetModel(pQuery);
if (re != null)
{
if (re.ID > 0)
{
MmsHelper.ThrowHttpExceptionWhen(true, "员工" + row["UserName"] + "已在别的班组！", 0);
return;
}
}
}
}
}
var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>
SYS_WorkGroup
</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>
");
var tabsWrapper = new List <RequestWrapper>();
tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>SYS_WorkGroupDetail</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>"));
var service = new SYS_WorkGroupService();
var result = service.EditPage(data, formWrapper, tabsWrapper);
}
public ActionResult Edit(string id = "")
{
//string billCode = new MES_MaterialPickMainService().GetBillCodeByID(id);
var data = new MES_MaterialPickDetailApiController().GetPageData(id);
//string documentNo = MmsHelper.GetOrderNumber("MES_MaterialPickMain", "BillCode", "CJLL", "", "");
var loginer = FormsAuth.GetUserData <LoginerBase>();
var dpartment = new SYS_BN_UserService().GetDepartmentInfo(loginer.UserCode);
SYS_BN_Warehouse warehouse = new SYS_BN_WarehouseService().GetModel(ParamQuery.Instance().AndWhere("ISEnable", 1).AndWhere("WarehouseName", dpartment.DepartmentName));
ViewBag.IsWarehouse = warehouse == null ? 0 : 1;
warehouse = warehouse ?? new SYS_BN_Warehouse();
string departid = "";
var departname = "";
if (dpartment != null)
{
departid = dpartment.DepartmentCode;
departname = dpartment.DepartmentName;
}
string dtNow = DateTime.Now.ToString("yyyy-MM-dd");
var model = new
{
urls = new
{
getdata = "/api/Mms/MES_MaterialPickDetail/GetPageData/", //获取主表数据及数据滚动数据api
edit = "/api/Mms/MES_MaterialPickDetail/edit/", //数据保存api
audit = "/api/Mms/MES_MaterialPickDetail/audit/", //审核api
newkey = "/api/Mms/MES_MaterialPickDetail/GetNewRowId/", //获取新的明细数据的主键(日语叫采番)
storageSave = "/api/Mms/MES_MaterialPickDetail/PostStorage/"
},
resx = new
{
rejected = "已撤消修改！",
editSuccess = "保存成功！",
auditPassed = "单据已通过审核！",
auditReject = "单据已取消审核！"
},
dataSource = new
{
pageData = data,
//payKinds = codeService.GetValueTextListByType("PayType")
},
form = new
{
defaults = new MES_MaterialPickMain().Extend(new
{
ID = id,
BillCode = data.form == null ? "系统生成" : data.form.BillCode,
DepartmentID = departid,
DepartmentName = departname,
PickingDate = dtNow,
IsEnable = 1,
BillState = 1,
ContractCode = "",
ProjectName = "",
WarehouseCode = warehouse.WarehouseCode,
WarehouseName = warehouse.WarehouseName
}),
primaryKeys = new string[] { "ID" }
},
tabs = new object[] {
new{
type = "grid",
rowId = "ID",
relationId = "ID",
postFields = new string[] { "ID", "MainID", "ContractCode", "ProjectName", "InventoryCode", "InventoryName", "RequiredQuantity", "IsEnable", "Model", "Unit", "Material" },
defaults = new { ID = "", MainID = id, ContractCode = "", ProjectName = "", InventoryCode = "", InventoryName = "", RequiredQuantity = "", IsEnable = 1, Model = "", Unit = "", Material = "" }
}
}
};
return(View(model));
}
