/// <summary> /// 获取工步名称列表 /// </summary> /// <param name="model"></param> /// <returns></returns> public async Task <List <t_gule_step_infoVM> > GetStepList(t_gule_step_infoVM model) { string strStep = string.Format(@"select distinct t.step_number,t.step_name from t_gule_step_info t ,t_co_package c where t.model_code=c.cell_model and t.polarity=C.POLARITY and t.polarity='{0}' and c.packagenumber='{1}' order by t.step_number", model.POLARITY, model.package); return(await base.SqlQuery <t_gule_step_infoVM>(strStep, new { })); }
/// <summary> /// / /// </summary> /// <param name="model"></param> /// <returns></returns> public async Task <t_gule_step_infoVM> GetStepListAllByStepName(t_gule_step_infoVM model) { string strStep = string.Format(@"select * from t_gule_step_info t ,t_co_package c where t.model_code=c.cell_model and t.polarity=C.POLARITY and t.polarity='{0}' and c.packagenumber='{1}' and t.STEP_NAME='{2}' order by t.step_number", model.POLARITY, model.package, model.STEP_NAME); return(await base.SqlQuerySingleAsync <t_gule_step_infoVM>(strStep, new { })); }
/// <summary> ///校验物料信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public async Task <bool> CheckMartter(t_gule_step_infoVM model) { var resule = (await this.GetStepListAll(model)).Where(m => m.ITEM_CODE == model.ITEM_CODE).FirstOrDefault(); if (resule != null) { //&&m.POWDER_UPPER<=model.POWDER_Value&& model.POWDER_Value >= m.POWDER_LOWER if (resule.POWDER_UPPER >= model.POWDER_Value && model.POWDER_Value >= resule.POWDER_LOWER) { return(true); } } return(false); }
/// <summary> /// 获取工步名称列表 /// </summary> /// <param name="model"></param> /// <returns></returns> public async Task <MessageModel <List <t_gule_step_infoVM> > > GetStepList(t_gule_step_infoVM model) { MessageModel <List <t_gule_step_infoVM> > message = new MessageModel <List <t_gule_step_infoVM> >(); var result = await _dal.GetStepList(model); if (result.Count <= 0) { message.success = false; message.msg = "获取信息失败"; return(message); } message.success = true; message.msg = "获取信息成功"; message.response = result; return(message); }
public async Task <MessageModel <List <t_gule_step_infoVM> > > GetStepList(t_gule_step_infoVM jsondata) { return(await _agitationServices.GetStepList(jsondata)); }