public ActionResult Index() { var code = new sys_codeService(); 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 WorkshopCode = ""; var deptInfo = new SYS_BN_DepartmentService().GetDeptInfoByUCode(MmsHelper.GetUserCode()); if (WorkshopCodeList.Count > 0) { WorkshopCode = WorkshopCodeList.FirstOrDefault().DepartID; } //ViewBag.WorkshopCode = WorkshopCode; ViewBag.WorkshopCode = deptInfo.DepartmentCode; var model = new { dataSource = new { }, urls = new { query = "/api/Mms/MES_WorkingTicket", newkey = "/api/Mms/MES_WorkingTicket/getnewkey", edit = "/api/Mms/MES_WorkingTicket/edit" }, resx = new { noneSelect = "请先选择一条数据!", editSuccess = "保存成功!", auditSuccess = "单据已审核!" }, form = new { WorkTicketCode = "", ApsCode = "", TeamName = "", WorkshopName = deptInfo == null?"": deptInfo.DepartmentName, ProcessName = "", WorkStepsName = "", EquipmentName = "", ApproveState = "" }, defaultRow = new { IsEnable = 1 }, setting = new { idField = "ID", postListFields = new string[] { "ID", "WorkTicketCode", "TicketLevel", "ApsCode", "WorkStepsID", "IsEnable", "WorkshopCode", "WorkshopName", "TeamCode", "TeamName", "CreateTime", "CreatePerson", "ModifyTime", "ModifyPerson", "ActualStartTime", "ActualFinishTime", "ApproveState", "ApprovePerson", "ApproveTime", "ProcessCode", "ProcessName", "WorkStepsName", "WorkStepsLineCode", "WorkStepsContent", "EquipmentCode", "EquipmentName", "TurnTargetName", "TurnTargetCode", "PartCode", "WorkQuantity", "ApproveRemark" } } }; return(View(model)); }
public void Audit(string id, JObject data) { var pUpdate = ParamUpdate.Instance() .Update("SYS_WorkGroup") .Column("ApproveState", data["status"]) .Column("ApproveRemark", data["comment"]) .Column("ApprovePerson", FormsAuth.GetUserData().UserName) .Column("ApproveDate", DateTime.Now) .AndWhere("ID", id); var service = new SYS_WorkGroupService(); var rowsAffected = service.Update(pUpdate); MmsHelper.ThrowHttpExceptionWhen(rowsAffected < 0, "单据审核失败[BillNo={0}],请重试或联系管理员!", id); }
public dynamic GetPageData(string id) { var masterService = new SYS_WorkGroupService(); var pQuery = ParamQuery.Instance().AndWhere("ID", id); var pQuery2 = ParamQuery.Instance().AndWhere("MainID", id); var result = new { //主表数据 form = masterService.GetModel(pQuery), scrollKeys = masterService.ScrollKeys("ID", id), //明细数据 tab0 = new SYS_WorkGroupDetailService().GetDynamicList(pQuery2) }; return(result); }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='ID'> <select>*</select> <from>SYS_WorkGroup</from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' > <field name='TeamCode' cp='equal'></field> <field name='TeamName' cp='equal'></field> <field name='DepartName' cp='equal'></field> </where> </settings>"); var service = new SYS_WorkGroupService(); //dynamic depart = new SYS_BN_UserService().GetDepartment(MmsHelper.GetUserCode()); //if (depart == null) //{ // return null; //} //var pQuery = query.ToParamQuery().AndWhere("DepartName", depart.DepartmentName); var pQuery = query.ToParamQuery(); var result = service.GetDynamicListWithPaging(pQuery.AndWhere("IsEnable", 1)); return(result); }
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); }