//设计任务详细查询 public dynamic GetDesignDetailedData(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='ID'> <select>*</select> <from>PMS_DesignTaskDetail</from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'> <field name='ContractCode' cp='equal'></field> <field name='IsEnable' cp='equal'></field> </where> </settings>"); var service = new PMS_DesignTaskDetailService(); var pQuery = query.ToParamQuery(); var result = service.GetDynamicListWithPaging(pQuery); return(result); //return null; //string where=""; //if(string.IsNullOrEmpty(contractCode)){ // where+=string.Format(" and ContractCode='{0}'",contractCode); //} // if(string.IsNullOrEmpty(productID)){ // where+=string.Format(" and PrductID='{0}'",productID); //} //using (var db = Db.Context("Mms")) //{ // string sql = string.Format(@"select * from PMS_DesignTaskDetail where 1=1 {0}", where); // dynamic res = db.Sql(sql).QueryMany<dynamic>(); // return res; //} }
//设计任务明细管理 public ActionResult DesignTaskDetailedIndex(string pID, string contractCode, string productID, string pName, string pModel, string pSpecifications, string MainID, int id = 0, int pState = 0) { ViewData["pID"] = pID; ViewData["projectDetailID"] = productID; ViewData["contractCode"] = contractCode; if (id > 0) { var pQuery = ParamQuery.Instance().Select("top 1 *").AndWhere("ID", id); var result = new PMS_DesignTaskDetailService().GetModel(pQuery); ViewData["DesignTask"] = result == null ? new PMS_DesignTaskDetail() : result; } else { var pQuery = ParamQuery.Instance().Select("top 1 *").AndWhere("IsEnable", "1").AndWhere("ContractCode", contractCode).AndWhere("ProductID", productID).OrderBy("ID desc"); var result = new PMS_DesignTaskDetailService().GetModel(pQuery); ViewData["DesignTask"] = result == null ? new PMS_DesignTaskDetail() : result; } ViewData["pName"] = pName; ViewData["pModel"] = pModel; ViewData["ProductID"] = productID; ViewData["pSpecifications"] = pSpecifications; ViewData["contractCode"] = contractCode; ViewData["MainID"] = MainID; ViewData["pState"] = pState; return(View()); }
public dynamic PostDesignDetailOnSave(List <PMS_DesignTaskDetail> model) { int result = 0; if (model.Count > 0) { if (model[0].ID <= 0) { model[0].DesignTaskCode = MmsHelper.GetOrderNumber("PMS_DesignTaskDetail", "DesignTaskCode", "SJRW", "", ""); 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_DesignTaskDetailService().Insert(model[0]); } else { result = new PMS_DesignTaskDetailService().Update(model[0]); } } return(new { result = result > 0 }); }