public void bind(string strWhere) { List<ExtendModule.InstrumentAndConsumables> listinstrument = new List<ExtendModule.InstrumentAndConsumables>(); ExtendBLL.InstrumentAndConsumables beconsum = new ExtendBLL.InstrumentAndConsumables(); listinstrument = beconsum.GetExtendModelList(" Type = 'lowvalue' " + strWhere + " order by ID desc "); LabMS.BLL.Lab blab = new LabMS.BLL.Lab(); List<LabMS.Model.Lab> mLab = new List<LabMS.Model.Lab>(); ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary(); List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>(); listCClass = eDictionary.GetItemListByDClass("haocaileibie"); foreach (ExtendModule.InstrumentAndConsumables i in listinstrument) { mLab = blab.GetModelList(" Lab_Code='" + i.StockLocation + "'"); if (mLab.Count > 0) { i.StockLocation = mLab[0].Lab_Name; } listCClass = eDictionary.GetModelList(" Code='" + i.Source + "' "); if (listCClass.Count > 0) { i.Source = listCClass[0].Name; } listCClass = eDictionary.GetModelList(" Code='" + i.Arrow + "' "); if (listCClass.Count > 0) { i.Arrow = listCClass[0].Name; } } gvInstrument.DataSource = listinstrument; gvInstrument.DataBind(); }
public void bind(string strWhere) { List<ExtendModule.InstrumentAndConsumables> listeconsummodule = new List<ExtendModule.InstrumentAndConsumables>(); ExtendBLL.InstrumentAndConsumables beconsum = new ExtendBLL.InstrumentAndConsumables(); listeconsummodule = beconsum.GetExtendStatisticsModelList(" Type = 'xiaohaopin' " + strWhere); GridViewCStatistics.DataSource = listeconsummodule; GridViewCStatistics.DataBind(); }
public void bindDDL(ExtendModule.InstrumentAndConsumables instrument) { ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary(); List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>(); tbCreatedDate.Text = DateTime.Today.ToLongDateString(); listCClass = eDictionary.GetItemListByDClass("haocaileibie"); ddlCClass.DataSource = listCClass; ddlCClass.DataTextField = "Name"; ddlCClass.DataValueField = "Code"; ddlCClass.DataBind(); listCClass = eDictionary.GetItemListByDClass("shebeilaiyuan"); ddlSource.DataSource = listCClass; ddlSource.DataTextField = "Name"; ddlSource.DataValueField = "Code"; ddlSource.DataBind(); listCClass = eDictionary.GetItemListByDClass("shiyongfangxiang"); ddlArrow.DataSource = listCClass; ddlArrow.DataTextField = "Name"; ddlArrow.DataValueField = "Code"; ddlArrow.DataBind(); listCClass = eDictionary.GetItemListByDClass("jingfeikemu"); ddlFundsSubject.DataSource = listCClass; ddlFundsSubject.DataTextField = "Name"; ddlFundsSubject.DataValueField = "Code"; ddlFundsSubject.DataBind(); listCClass = eDictionary.GetItemListByDClass("dangwei"); ddlModle.DataSource = listCClass; ddlModle.DataTextField = "Name"; ddlModle.DataValueField = "Code"; ddlModle.DataBind(); ExtendBLL.InstrumentAndConsumables eConsum = new ExtendBLL.InstrumentAndConsumables(); int iMaxCID = eConsum.GetMaxId(); MaxCID.Value = iMaxCID.ToString("D10"); tbInstrumentNum.Text = iMaxCID.ToString("D10"); tbLocation.Text = instrument.LabName; tbLocationCode.Text = instrument.StockLocation; }
public void bind(string strWhere) { List<ExtendModule.InstrumentAndConsumables> listevaluables = new List<InstrumentAndConsumables>(); ExtendBLL.InstrumentAndConsumables bevaluables = new ExtendBLL.InstrumentAndConsumables(); listevaluables = bevaluables.GetExtendModelList(" Type = 'guizhongyiqi' " + strWhere + " order by ID desc "); LabMS.BLL.Lab blab = new LabMS.BLL.Lab(); List<LabMS.Model.Lab> mLab = new List<LabMS.Model.Lab>(); ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary(); List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>(); listCClass = eDictionary.GetItemListByDClass("haocaileibie"); foreach (ExtendModule.InstrumentAndConsumables i in listevaluables) { mLab = blab.GetModelList(" Lab_Code='" + i.StockLocation + "'"); if (mLab.Count > 0) { i.StockLocation = mLab[0].Lab_Name; } listCClass = eDictionary.GetModelList(" DClass='shebeilaiyuan' and Code='" + i.Source + "' "); if (listCClass.Count > 0) { i.Source = listCClass[0].Name; } listCClass = eDictionary.GetModelList(" DClass='shiyongfangxiang' and Code='" + i.Arrow + "' "); if (listCClass.Count > 0) { i.Arrow = listCClass[0].Name; } listCClass = eDictionary.GetModelList(" DClass='shebeizhuangtai' and Code='" + i.PresentSituation + "' "); if (listCClass.Count > 0) { i.PresentSituation = listCClass[0].Name; } } GridViewValuables.DataSource = listevaluables; GridViewValuables.DataBind(); }
ExtendModule.InstrumentAndConsumables checkQueryString(string strID) { ExtendBLL.InstrumentAndConsumables bconsum = new ExtendBLL.InstrumentAndConsumables(); string strWhere = " Type = 'lowvalue' and ID =" + strID; List<ExtendModule.InstrumentAndConsumables> listinstrument = bconsum.GetExtendModelList(strWhere); if (listinstrument.Count <= 0) { return null; } return listinstrument[0]; }
ExtendModule.InstrumentAndConsumables checkQueryString(string strID) { ExtendBLL.InstrumentAndConsumables bvaluables = new ExtendBLL.InstrumentAndConsumables(); string strWhere = " Type = 'guizhongyiqi' and ID =" + strID; List<ExtendModule.InstrumentAndConsumables> listvaluables = bvaluables.GetExtendModelList(strWhere); if (listvaluables.Count <= 0) { return null; } return listvaluables[0]; }