public int InsertSYS_Region(SYS_Region sys_region) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_region.Name, false)); para.Add(_DbHelper.CreateParameter(FIELD_CODE, sys_region.Code, false)); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Region_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_RegionDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public Model.UserModel GetOneUser(string sqlWhere) { string sql = string.Format("select * from users where 1=1 {0}", sqlWhere); using (SqlDataReader sdr = MSSqlHelper.ExecuteReader(MSSqlHelper.ConStr, System.Data.CommandType.Text, sql, null)) { if (sdr.Read()) { Model.UserModel user = new Model.UserModel(); user.ID = sdr.GetInt32(0); user.UserName = sdr.GetString(1); user.Password = sdr.GetString(2); user.Role = sdr.GetInt32(3); return(user); } else { return(null); } } }
public List <Model.ManufacturerModel> GetEntities(string sqlWhere) { string sql = string.Format("select * from manufacturer where 1=1 {0}", sqlWhere); List <Model.ManufacturerModel> listManufacturer = new List <Model.ManufacturerModel>(); //Using 限定对象使用的范围在花括号里面,出了花括号后释放资源 using (SqlDataReader odr = MSSqlHelper.ExecuteReader(MSSqlHelper.ConStr, CommandType.Text, sql, null)) { while (odr.Read()) { Model.ManufacturerModel manufacturer = new Model.ManufacturerModel(); manufacturer.ID = odr.GetInt32(0); manufacturer.Name = odr.IsDBNull(1) ? "" : odr.GetString(1); manufacturer.Person = odr.IsDBNull(2) ? "" : odr.GetString(2); manufacturer.Telphone = odr.IsDBNull(3) ? "" : odr.GetString(3); manufacturer.Address = odr.IsDBNull(4) ? "" : odr.GetString(4); manufacturer.Status = odr.IsDBNull(5) ? "" : odr.GetString(5); listManufacturer.Add(manufacturer); } } return(listManufacturer); }
public List <Model.CustomerModel> GetEntities(string sqlWhere) { string sql = string.Format("select * from customer where 1=1 {0}", sqlWhere); List <CustomerModel> listCustomers = new List <CustomerModel>(); //Using 限定对象使用的范围在花括号里面,出了花括号后释放资源 using (SqlDataReader odr = MSSqlHelper.ExecuteReader(MSSqlHelper.ConStr, CommandType.Text, sql, null)) { while (odr.Read()) { CustomerModel Customer = new CustomerModel(); Customer.ID = odr.GetInt32(0); Customer.Name = odr.IsDBNull(1) ? "" : odr.GetString(1); Customer.Birthday = odr.IsDBNull(2) ? "" : odr.GetString(2); Customer.Address = odr.IsDBNull(3) ? "" : odr.GetString(3); Customer.Telphone = odr.IsDBNull(4) ? "" : odr.GetString(4); Customer.TotalMoney = odr.IsDBNull(5) ? 0M : odr.GetDecimal(5); Customer.Mark = odr.IsDBNull(6) ? "" : odr.GetString(6); listCustomers.Add(Customer); } } return(listCustomers); }
public List <Model.PurchaseOrdersModel> GetEntities(string sqlWhere) { string sql = string.Format("select * from purchaseOrders where 1=1 {0}", sqlWhere); List <Model.PurchaseOrdersModel> listPurchaseOrders = new List <Model.PurchaseOrdersModel>(); using (SqlDataReader odr = MSSqlHelper.ExecuteReader(MSSqlHelper.ConStr, System.Data.CommandType.Text, sql, null)) { while (odr.Read()) { Model.PurchaseOrdersModel purchaseOrderModel = new Model.PurchaseOrdersModel(); purchaseOrderModel.ID = odr.GetInt32(0); purchaseOrderModel.OrderNumber = odr.IsDBNull(1) ? "" : odr.GetString(1); purchaseOrderModel.SupplierName = odr.IsDBNull(2) ? "" : odr.GetString(2); purchaseOrderModel.Person = odr.IsDBNull(3) ? "" : odr.GetString(3); purchaseOrderModel.Tel = odr.IsDBNull(4) ? "" : odr.GetString(4); purchaseOrderModel.Address = odr.IsDBNull(5) ? "" : odr.GetString(5); purchaseOrderModel.Contract = odr.IsDBNull(6) ? "" : odr.GetString(6); //purchaseOrderModel.Status = odr.IsDBNull(7) ? "" : odr.GetString(7); purchaseOrderModel.OrderDate = odr.IsDBNull(8) ? DateTime.Now : odr.GetDateTime(8); listPurchaseOrders.Add(purchaseOrderModel); } } return(listPurchaseOrders); }