public List <Model.Document> getAll_Document(Model.Criteria.Document criteria) { //string connStr = Properties.Settings.Default.InventoryControl_ConnectionString; //SqlConnection conn = Common.DataHelper.getSQLServerConnectionObject(connStr); DataSet ds = new DataSet(); String sql; sql = "Select * From document where doc_id=" + criteria.doc_id; Class.clsDB db = new Class.clsDB(); ds = db.ExecuteDataSet(sql); db.Close(); //SqlDataAdapter adp = new SqlDataAdapter("usp_Permission_Read", conn); //adp.SelectCommand.CommandType = CommandType.StoredProcedure; //adp.SelectCommand.Parameters.Add(new SqlParameter("@PRJ_Code", criteria.PRJ_Code)); //adp.SelectCommand.Parameters.Add(new SqlParameter("@UserAccount", criteria.UserAccount)); //adp.SelectCommand.Parameters.Add(new SqlParameter("@PAG_Code", criteria.PAG_Code)); // adp.Fill(ds); return(ds.Tables[0].AsEnumerable().Select(s => new Model.Document { doc_id_int = s.Field <int>("doc_id"), doc_name = s.Field <string>("doc_name"), secure_approve = s.Field <string>("secure_approve"), secure_prepare = s.Field <string>("secure_prepare"), approve_problem = s.Field <string>("approve_problem"), content = s.Field <string>("content") }).ToList()); }
public List <Model.M_Account> getAccount(Model.Criteria.M_AccountCriteria criteria, ref int rsTotalRecord) { try { DataSet ds = new DataSet(); String sql; sql = "Select * From account"; Class.clsDB db = new Class.clsDB(); ds = db.ExecuteDataSet(sql); var result = ds.Tables[0].AsEnumerable().Select(s => new Model.M_Account { title = s.Field <string>("title"), name = s.Field <string>("name"), surname = s.Field <string>("surname"), username = s.Field <string>("username"), password = s.Field <string>("password"), email = s.Field <string>("email"), }).ToList(); return(result); } catch (Exception ex) { throw ex; } finally { } }
public List <Model.Account> getEmail_Level2() { //string connStr = Properties.Settings.Default.InventoryControl_ConnectionString; //SqlConnection conn = Common.DataHelper.getSQLServerConnectionObject(connStr); DataSet ds = new DataSet(); String sql; sql = "Select * From account where level='2'"; Class.clsDB db = new Class.clsDB(); ds = db.ExecuteDataSet(sql); db.Close(); //SqlDataAdapter adp = new SqlDataAdapter("usp_Permission_Read", conn); //adp.SelectCommand.CommandType = CommandType.StoredProcedure; //adp.SelectCommand.Parameters.Add(new SqlParameter("@PRJ_Code", criteria.PRJ_Code)); //adp.SelectCommand.Parameters.Add(new SqlParameter("@UserAccount", criteria.UserAccount)); //adp.SelectCommand.Parameters.Add(new SqlParameter("@PAG_Code", criteria.PAG_Code)); // adp.Fill(ds); return(ds.Tables[0].AsEnumerable().Select(s => new Model.Account { Title = s.Field <string>("Title"), Name = s.Field <string>("Name"), Surname = s.Field <string>("Surname"), Email = s.Field <string>("Email"), }).ToList()); }
public List <Model.Account> getEmail() { DataSet ds = new DataSet(); String sql; sql = "Select * From account"; Class.clsDB db = new Class.clsDB(); ds = db.ExecuteDataSet(sql); return(ds.Tables[0].AsEnumerable().Select(s => new Model.Account { Title = s.Field <string>("Title"), Name = s.Field <string>("Name"), Surname = s.Field <string>("Surname"), Email = s.Field <string>("Email"), }).ToList()); }
public List <MODEL.jobDetail> getJobDetail(MODEL.Criteria.jobDetail criteria) { DataSet ds = new DataSet(); String sql; sql = "Select * From job_detail where show_=1"; Class.clsDB db = new Class.clsDB(); ds = db.ExecuteDataSet(sql); db.Close(); return(ds.Tables[0].AsEnumerable().Select(s => new MODEL.jobDetail { job_id = s.Field <string>("job_id"), //place_get_job = s.Field<string>("place_get_job"), //container_type = s.Field<string>("container_type"), //container_dim = s.Field<string>("container_dim"), }).ToList()); }
public DataTable GetCustomer() { DataTable table; try { DataSet set = new DataSet(); string strSQL = "Select * From supplier order by supp_short_name "; Class.clsDB sdb1 = new Class.clsDB(); set = sdb1.ExecuteDataSet(strSQL); sdb1.Close(); table = set.Tables[0]; } catch (Exception exception1) { throw exception1; } return(table); }
public DataTable ExecuteDatatable(string sql) { try { DataSet ds = new DataSet(); Class.clsDB db = new Class.clsDB(); ds = db.ExecuteDataSet(sql); db.Close(); return(ds.Tables[0]); } catch (Exception ex) { throw ex; } finally { } }
public DataTable getDocument_By_DocId(string doc_id) { try { DataSet ds = new DataSet(); String sql; sql = "Select * From document where doc_id = '" + doc_id + "'"; Class.clsDB db = new Class.clsDB(); ds = db.ExecuteDataSet(sql); db.Close(); return(ds.Tables[0]); } catch (Exception ex) { throw ex; } finally { } }
public DataTable NotPrice() { try { DataSet ds = new DataSet(); String sql; sql = "select no,price from temp where price = 0"; Class.clsDB db = new Class.clsDB(); ds = db.ExecuteDataSet(sql); db.Close(); return(ds.Tables[0]); } catch (Exception ex) { throw ex; } finally { } }
public DataTable CountUnder() { try { DataSet ds = new DataSet(); String sql; sql = "select count(*) as c from temp2under where price > 0"; Class.clsDB db = new Class.clsDB(); ds = db.ExecuteDataSet(sql); db.Close(); return(ds.Tables[0]); } catch (Exception ex) { throw ex; } finally { } }
public DataTable getDataTemp2under() { try { DataSet ds = new DataSet(); String sql; sql = "Select * From Temp2under"; Class.clsDB db = new Class.clsDB(); ds = db.ExecuteDataSet(sql); db.Close(); return(ds.Tables[0]); } catch (Exception ex) { throw ex; } finally { } }
public DataTable BindFilename() { try { DataSet ds = new DataSet(); String sql; sql = "select * from tb_file_name "; Class.clsDB db = new Class.clsDB(); ds = db.ExecuteDataSet(sql); db.Close(); return(ds.Tables[0]); } catch (Exception ex) { throw ex; } finally { } }
public DataTable getAccount_Level1() { try { DataSet ds = new DataSet(); String sql; sql = "Select * From account where level = '1'"; Class.clsDB db = new Class.clsDB(); ds = db.ExecuteDataSet(sql); db.Close(); return(ds.Tables[0]); } catch (Exception ex) { throw ex; } finally { } }
public DataTable getAccount_By_Email(Model.Criteria.M_AccountCriteria criteria) { try { DataSet ds = new DataSet(); String sql; sql = "Select * From account where email='" + criteria.email + "'"; Class.clsDB db = new Class.clsDB(); ds = db.ExecuteDataSet(sql); db.Close(); return(ds.Tables[0]); } catch (Exception ex) { throw ex; } finally { } }
public DataTable GetCustomerByID(string id) { DataTable table; try { if (id == "") { id = "0"; } DataSet set = new DataSet(); string strSQL = "Select * From supplier Where supp_code = " + id + " order by supp_short_name "; Class.clsDB sdb1 = new Class.clsDB(); set = sdb1.ExecuteDataSet(strSQL); sdb1.Close(); table = set.Tables[0]; } catch (Exception exception1) { throw exception1; } return(table); }