Example #1
0
        public List<LabMS.Model.SuppliesRecipients> ExtendGetModuleList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select s.[ID],EncodedWarehouse,Numbers,[Name],Words,Arrow,QuantityRecipients,"+
                                   "Recipients,Laboratory,EncodedTime,UnitPrice,TotalAmount,Comment,Operator,"+
                                   "OperatDate, Teacher_Name, l.Location_Name as lname1, l2.Lab_Name as lname2");
            strSql.Append(" FROM SuppliesRecipients s, Teacher t, Location l, Lab l2 ");
            strSql.Append(" where s.Recipients = t.Teacher_Code and l.ID = s.EncodedWarehouse and"+
                                   " l2.Lab_Code = s.Laboratory");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" and " + strWhere);
            }
            DataSet ds = DbHelperSQL.Query(strSql.ToString());

            List<LabMS.Model.SuppliesRecipients> modelList = new List<LabMS.Model.SuppliesRecipients>();
            int rowsCount = ds.Tables[0].Rows.Count;
            if (rowsCount > 0)
            {
                LabMS.Model.SuppliesRecipients model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new LabMS.Model.SuppliesRecipients();
                    model.ID= long.Parse(ds.Tables[0].Rows[n]["ID"].ToString());
                    model.EncodedWarehouse = ds.Tables[0].Rows[n]["lname1"].ToString();
                    model.Numbers = ds.Tables[0].Rows[n]["Numbers"].ToString();
                    model.Name = ds.Tables[0].Rows[n]["Name"].ToString();
                    model.Words = ds.Tables[0].Rows[n]["Words"].ToString();
                    model.Arrow = ds.Tables[0].Rows[n]["Arrow"].ToString();
                    model.QuantityRecipients = ds.Tables[0].Rows[n]["QuantityRecipients"].ToString();
                    model.Recipients = ds.Tables[0].Rows[n]["Teacher_Name"].ToString();
                    model.Laboratory = ds.Tables[0].Rows[n]["lname2"].ToString();
                    if (ds.Tables[0].Rows[n]["EncodedTime"].ToString() != "")
                    {
                        model.EncodedTime = DateTime.Parse(ds.Tables[0].Rows[n]["EncodedTime"].ToString());
                    }
                    model.UnitPrice = ds.Tables[0].Rows[n]["UnitPrice"].ToString();
                    model.TotalAmount = ds.Tables[0].Rows[n]["TotalAmount"].ToString();
                    model.Comment = ds.Tables[0].Rows[n]["Comment"].ToString();
                    model.Operator = ds.Tables[0].Rows[n]["Operator"].ToString();
                    if (ds.Tables[0].Rows[n]["OperatDate"].ToString() != "")
                    {
                        model.OperatDate = DateTime.Parse(ds.Tables[0].Rows[n]["OperatDate"].ToString());
                    }
                    modelList.Add(model);
                }
            }
            return modelList;
        }
Example #2
0
 /// <summary>
 /// ��������б�
 /// </summary>
 public List<LabMS.Model.SuppliesRecipients> GetModelList(string strWhere)
 {
     DataSet ds = dal.GetList(strWhere);
     List<LabMS.Model.SuppliesRecipients> modelList = new List<LabMS.Model.SuppliesRecipients>();
     int rowsCount = ds.Tables[0].Rows.Count;
     if (rowsCount > 0)
     {
         LabMS.Model.SuppliesRecipients model;
         for (int n = 0; n < rowsCount; n++)
         {
             model = new LabMS.Model.SuppliesRecipients();
             //model.ID=ds.Tables[0].Rows[n]["ID"].ToString();
             model.EncodedWarehouse=ds.Tables[0].Rows[n]["EncodedWarehouse"].ToString();
             model.Numbers=ds.Tables[0].Rows[n]["Numbers"].ToString();
             model.Name=ds.Tables[0].Rows[n]["Name"].ToString();
             model.Words=ds.Tables[0].Rows[n]["Words"].ToString();
             model.Arrow=ds.Tables[0].Rows[n]["Arrow"].ToString();
             model.QuantityRecipients=ds.Tables[0].Rows[n]["QuantityRecipients"].ToString();
             model.Recipients=ds.Tables[0].Rows[n]["Recipients"].ToString();
             model.Laboratory=ds.Tables[0].Rows[n]["Laboratory"].ToString();
             if(ds.Tables[0].Rows[n]["EncodedTime"].ToString()!="")
             {
                 model.EncodedTime=DateTime.Parse(ds.Tables[0].Rows[n]["EncodedTime"].ToString());
             }
             model.UnitPrice=ds.Tables[0].Rows[n]["UnitPrice"].ToString();
             model.TotalAmount=ds.Tables[0].Rows[n]["TotalAmount"].ToString();
             model.Comment=ds.Tables[0].Rows[n]["Comment"].ToString();
             model.Operator=ds.Tables[0].Rows[n]["Operator"].ToString();
             if(ds.Tables[0].Rows[n]["OperatDate"].ToString()!="")
             {
                 model.OperatDate=DateTime.Parse(ds.Tables[0].Rows[n]["OperatDate"].ToString());
             }
             modelList.Add(model);
         }
     }
     return modelList;
 }