//设计任务详细查询
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
});
}
