public void bind(string strCode, string strLocation, string strCondition) { LabMS.BLL.InstrumentAndConsumables bconsum = new LabMS.BLL.InstrumentAndConsumables(); if (strCondition.Trim().Equals("")) { strCondition = ""; } else { strCondition = " and " + strCondition; } string strWhere = " Type = '" + strCode + "'and SpaceLocation= '" + strLocation + "' and Quantity>0 " + strCondition + " order by ID desc "; if (strLocation.Equals("@ALL@")) { strWhere = " Type = '" + strCode + "'and Quantity>0 " + strCondition + " order by ID desc "; } List<LabMS.Model.InstrumentAndConsumables> listmconsum = bconsum.GetModelList(strWhere); GridViewDic.DataSource = listmconsum; GridViewDic.DataBind(); }
public bool isNumbersLegal(string strNumbers, string strType) { LabMS.BLL.InstrumentAndConsumables bconsum = new LabMS.BLL.InstrumentAndConsumables(); List<LabMS.Model.InstrumentAndConsumables> listmconsum = new List<LabMS.Model.InstrumentAndConsumables>(); listmconsum = bconsum.GetModelList("Numbers='" + strNumbers + "' and Type='" + strType + "'"); if (listmconsum.Count > 0) { return false; } return true; }