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);
}
