예제 #1
0
        //SQLiteConnection sqlconnection = new SQLiteConnection(@"Data Source=.\Data.db;Initial Catalog=T_Company;Persist Security Info=True;");
        public ObservableCollection<CompanyModel> GetCompanyList(string Condition)
        {
            ObservableCollection<CompanyModel> list = new ObservableCollection<CompanyModel>();
            string DeviceId = System.Configuration.ConfigurationManager.AppSettings["DeviceId"];
            string sql = "select ID,CompanyName,EnglishName,RoomNum,BeamNum,FloorNum,CompanyInfo from dt_Company where DeviceId ="+DeviceId+" "  + Condition+ " order by FloorNum,RoomNum";

            DataSet ds = SQLiteHelper.Query(sql);
            if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
            {
                return list;
            }
            if (ds.Tables[0].Rows.Count > 0)
            {
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    CompanyModel cm = new CompanyModel();
                    cm.CompanyID = Int32.Parse(dr["ID"].ToString());
                    cm.CompanyName_CN = dr["CompanyName"].ToString();
                    cm.CompanyName_EN = dr["EnglishName"].ToString();
                    cm.CompanyRoomNum = dr["RoomNum"].ToString();
                    cm.CompanyBuild = dr["BeamNum"].ToString() + @"栋";
                    cm.CompanyFloor = dr["FloorNum"].ToString();
                    cm.CompanyContent = dr["CompanyInfo"].ToString();
                    list.Add(cm);
                }
            }
            return list;
        }
예제 #2
0
 public void LoadListData(string sql)
 {
     CompanyModel companymodel = new CompanyModel();
     companylist = searchbll.GetCompanyList(sql);
     this.listbox_Search.ItemsSource = companylist;
     EnderCompany();
 }