public void Delete(string id) { var service = new mms_drainpipeductService(); var result = service.Delete(ParamDelete.Instance().AndWhere("BillNo", id)); MmsHelper.ThrowHttpExceptionWhen(result <= 0, "信息删除失败[BillNo={0}],请重试或联系管理员!", id); }
public void Delete(string id) { var service = new mms_inspectionwellService(); var result = service.Delete(ParamDelete.Instance().AndWhere("BillNo", id).From("MANHOLE")); MmsHelper.ThrowHttpExceptionWhen(result <= 0, "信息删除失败[BillNo={0}],请重试或联系管理员!", id); }
public int PostOnSave(List <PMS_BN_Project> model) { List <string> strList = new PMS_BN_ProjectService().GetCnotractCode(); if (model.Count < 0) { return(0); } else { int result = 0; if (model[0].ProjectID <= 0) { //if (model[0].ContractCode) bool isContain = strList.Contains(model[0].ContractCode); if (!isContain) { model[0].CreateTime = DateTime.Now; model[0].ModifyTime = model[0].CreateTime; model[0].CreatePerson = MmsHelper.GetUserCode(); model[0].ModifyPerson = model[0].CreatePerson; result = new PMS_BN_ProjectService().Insert(model[0]); } else { MmsHelper.ThrowHttpExceptionWhen(false, "合同编号重复,请确认数据!", 0); } } else { result = new PMS_BN_ProjectService().Update(model[0]); } return(result); } }
public void Audit(string id, dynamic data) { var status = data["status"].ToString(); var comment = data["comment"].ToString(); var result = new MmsService().Audit(typeof(mms_drainpipeduct).Name, id, status, comment); MmsHelper.ThrowHttpExceptionWhen(result < 0, "信息审核失败[BillNo={0}],请重试或联系管理员!", id); }
public virtual void Audit(string id, JObject data) { var status = data["status"].ToString(); var comment = data["comment"].ToString(); var result = new MmsService().Audit(typeof(TMasterModel).Name, id, status, comment); MmsHelper.ThrowHttpExceptionWhen(result < 0, "单据审核失败[Object_ID={0}],请重试或联系管理员!", id); }
public void Audit(string id, JObject data) { var pUpdate = ParamUpdate.Instance() .Update("SYS_BOM") .Column("ApproveState", data["status"]) .Column("ApproveRemark", data["comment"]) .Column("ApprovePerson", FormsAuth.GetUserData().UserName) .Column("ApproveDate", DateTime.Now) .AndWhere("ID", id); var service = new SYS_BOMService(); var rowsAffected = service.Update(pUpdate); MmsHelper.ThrowHttpExceptionWhen(rowsAffected < 0, "单据审核失败[BillNo={0}],请重试或联系管理员!", id); }
public void Audit(dynamic data) { var pUpdate = ParamUpdate.Instance() .Update("MES_WorkshopPurchaseMain") .Column("ApproveState", data.form.status.ToString()) .Column("ApproveRemark", data.form.comment.ToString()) .Column("ApprovePerson", FormsAuth.GetUserData().UserName) .Column("ApproveDate", DateTime.Now) .AndWhere("ID", data.form.ID.ToString()); var service = new MES_WorkshopPurchaseMainService(); var rowsAffected = service.Update(pUpdate); MmsHelper.ThrowHttpExceptionWhen(rowsAffected < 0, "单据审核失败[BillNo={0}],请重试或联系管理员!"); }
protected override void OnAfterHandleExcel(ref System.Data.DataTable dtSheet) { foreach (DataRow item in dtSheet.Rows) { string dName = item["WarehouseName"].ToString(); string sql = string.Format(@"select ID from SYS_BN_Warehouse where WarehouseName='{0}'", dName); int hID = db.Sql(sql).QuerySingle <int>(); if (hID == 0) { MmsHelper.ThrowHttpExceptionWhen(true, "仓库名:" + dName + "错误,请检查数据", ""); return; } item["WarehouseCode"] = hID; } base.OnAfterHandleExcel(ref dtSheet); }
public void Edit(dynamic data) { var service = new MES_WorkshopPurchaseMainService(); if (data.form["WorkshopPurchaseCode"] != "系统生成") { var pQuery = ParamQuery.Instance().Select("*").AndWhere("ID", data.form["ID"]); MES_WorkshopPurchaseMain model = service.GetModel(pQuery); if (model.ApproveState != null && model.ApproveState == "2") { MmsHelper.ThrowHttpExceptionWhen(true, "已发布的不能修改!"); return; } } var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> MES_WorkshopPurchaseMain </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>MES_WorkshopPurchaseDetail</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); if (data.form["WorkshopPurchaseCode"] == "系统生成") { string documentNo = MmsHelper.GetOrderNumber("MES_WorkshopPurchaseMain", "WorkshopPurchaseCode", "CJQG", "", ""); data.form["WorkshopPurchaseCode"] = documentNo; } var result = service.EditPage(data, formWrapper, tabsWrapper); }
public void Edit(dynamic data) { var id = data.form["ID"].ToString(); var pQuery = ParamQuery.Instance().Select("*").AndWhere("ID", id); var re = new PRS_ProcessRouteModelMainService().GetModelList(pQuery); if (re.Count > 0 && re[0].BillState == 1) { MmsHelper.ThrowHttpExceptionWhen(true, "已审核数据不能修改!"); return; } var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> PRS_ProcessRouteModelMain </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>PRS_ProcessRouteModelDetail</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); var service = new PRS_ProcessRouteModelMainService(); if (data.form["ProcessRouteCode"] == "系统生成") { string documentNo = MmsHelper.GetLSNumber("PRS_ProcessRouteModelMain", "ProcessRouteCode", "GYMX", "", ""); data.form["ProcessRouteCode"] = documentNo; } var result = service.EditPage(data, formWrapper, tabsWrapper); }
// 删除 DELETE api/mms/send public virtual void Delete(string id) { var result = masterService.Delete(ParamDelete.Instance().Where("BillNo", id)); MmsHelper.ThrowHttpExceptionWhen(result <= 0, "单据删除失败[BillNo={0}],请重试或联系管理员!", id); }
public void Edit(dynamic data) { var serviceMain = new WMS_BN_TakeStockMainService(); var formWrapperMain = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> WMS_BN_TakeStockMain </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var formWrapperDetail = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> WMS_BN_TakeStockDetail </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); //.GetNewKey("ID", "maxplus"); //判断当前是否首次保存首次保存产生单号 //var currentID = data["form"]["ID"]; //var pQuery = ParamQuery.Instance().AndWhere("ID", currentID); //var currentInfo = serviceMain.GetModel(pQuery); //dynamic qm = new //{ // month = data["form"]["TakeStockYear"], // year = data["form"]["TakeStockYear"] //}; //if (currentInfo == null) //{ // var code = serviceMain.GetMaxBillCode(qm); // data["form"]["BillCode"] = code; //} //判断是否是新增,是的话就判断一个月只能保存一条盘点数据 dynamic qm = new { month = data["form"]["TakeStockMonth"], year = data["form"]["TakeStockYear"] }; if (qm.month != null || qm.year != null) { if (serviceMain.GetTakeStock(Convert.ToInt32(qm.year), Convert.ToInt32(qm.month)) > 0) { MmsHelper.ThrowHttpExceptionWhen(true, "一个月只能生成一次盘点!", ""); } } var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(formWrapperDetail); var service = new WMS_BN_TakeStockDetailService(); var result = service.EditPage(data, formWrapperMain, tabsWrapper); }
public void Edit(dynamic data) { var service = new MES_MaterialPickMainService(); if (data.form["BillCode"] != "系统生成") { var pQuery = ParamQuery.Instance().Select("*").AndWhere("ID", data.form["ID"]); MES_MaterialPickMain model = service.GetModel(pQuery); if (model.BillState != null && model.BillState == 2) { MmsHelper.ThrowHttpExceptionWhen(true, "已发布的不能修改!"); return; } } var ids = "("; foreach (JToken tab in data["tabs"].Children()) { foreach (JProperty item in tab.Children()) { if (item.Name == "deleted") { foreach (var row in item.Value.Children()) { ids += "'" + row["ID"] + "',"; } item.Value = "[]"; } } } if (ids != "(") { ids = ids.Remove(ids.Length - 1, 1); ids += ")"; using (var db = Db.Context("Mms")) { string sql1 = string.Format("update MES_MaterialPickDetail set IsEnable=0 where ID in {0} ", ids); db.Sql(sql1).Execute(); } } var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> MES_MaterialPickMain </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>MES_MaterialPickDetail</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); if (data.form["BillCode"] == "系统生成") { string documentNo = MmsHelper.GetOrderNumber("MES_MaterialPickMain", "BillCode", "CJLL", "", ""); data.form["BillCode"] = documentNo; } var result = service.EditPage(data, formWrapper, tabsWrapper); }
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 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); }