public int GetUserCount(IEnumerable <SearchCondition> condition)
{
SqlConnection conn;
int count = 0;
using (conn = SqlHelper.CreateConntion())
{
conn.Open();
count = DAL.GetUserCount(condition, conn);
conn.Close();
}
return(count);
}
public IList <CategoryInfo> GetPageCategory(IEnumerable <SearchCondition> condition, int page, int pagesize)
{
SqlConnection conn;
IList <CategoryInfo> category;
using (conn = SqlHelper.CreateConntion())
{
conn.Open();
category = categoryDal.GetPageCategory(condition, page, pagesize, conn);
conn.Close();
return(category);
}
}
public IList <UserInfo> GetPageUser(IEnumerable <SearchCondition> condition, int page, int pagesize)
{
SqlConnection conn;
IList <UserInfo> l;
using (conn = SqlHelper.CreateConntion())
{
conn.Open();
l = DAL.GetPageUser(condition, page, pagesize, conn);
conn.Close();
return(l);
}
}
public int InsertCategory(CategoryInfo category)
{
SqlConnection conn;
int count = 0;
using (conn = SqlHelper.CreateConntion())
{
conn.Open();
count = categoryDal.InsertCategory(category, conn);
conn.Close();
}
return(count);
}
public int DeleteCategory(Guid categoryId)
{
SqlConnection conn;
int count = 0;
using (conn = SqlHelper.CreateConntion())
{
conn.Open();
count = categoryDal.DeleteCategoryById(categoryId, conn);
conn.Close();
}
return(count);
}
public CategoryInfo GetCategoryById(Guid categoryId)
{
SqlConnection conn;
IList <CategoryInfo> category;
SearchCondition[] condition = new SearchCondition[] { new SearchCondition {
con = "id=@id", param = "@id", value = categoryId.ToString()
} };
using (conn = SqlHelper.CreateConntion())
{
conn.Open();
category = categoryDal.GetCategory(condition, conn);
if (category.Count > 0)
{
return(category[0]);
}
conn.Close();
return(null);
}
}
public CheckBillInfo GetCheckBillById(Guid id)
{
SqlConnection conn;
IList <CheckBillInfo> l;
SearchCondition[] condition = new SearchCondition[] { new SearchCondition {
con = "id=@id", param = "@id", value = categoryId.ToString()
} };
using (conn = SqlHelper.CreateConntion())
{
conn.Open();
l = DAL.GetCheckBill(condition, conn);
if (l.Count > 0)
{
return(l[0]);
}
conn.Close();
return(null);
}
}
public ProductInfo GetProductById(Guid productId)
{
SqlConnection conn;
IList <ProductInfo> l;
SearchCondition[] condition = new SearchCondition[] { new SearchCondition {
con = "id=@id", param = "@id", value = productBillId.ToString()
} };
using (conn = SqlHelper.CreateConntion())
{
conn.Open();
l = DAL.GetProduct(condition, conn);
if (l.Count > 0)
{
return(l[0]);
}
conn.Close();
return(null);
}
}
public int InsertUser(UserInfo user)
{
SqlConnection conn;
int count = 0;
using (conn = SqlHelper.CreateConntion())
{
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
count = DAL.InsertUser(user, trans);
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
}
conn.Close();
}
return(count);
}
public int UpdateStock(StockInfo stock)
{
SqlConnection conn;
int count = 0;
using (conn = SqlHelper.CreateConntion())
{
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
count = DAL.UpdateStock(stock, trans);
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
}
conn.Close();
}
return(count);
}
public int UpdateCheckBill(CheckBillInfo checkbill, bool changebody)
{
SqlConnection conn;
int count = 0;
using (conn = SqlHelper.CreateConntion())
{
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
count = DAL.UpdateCheckBill(checkbill, changebody, trans);
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
}
conn.Close();
}
return(count);
}
public int DeleteCheckBill(Guid id)
{
SqlConnection conn;
int count = 0;
using (conn = SqlHelper.CreateConntion())
{
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
count = DAL.DeleteCheckBill(id, trans);
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
}
conn.Close();
}
return(count);
}
public WareHouseInfo GetWareHouseById(Guid wareHouseId)
{
SqlConnection conn;
IList <WareHouseInfo> l;
SearchCondition[] condition = new SearchCondition[] {
new SearchCondition {
con = "id=@id", param = "@id", value = wareHouseId.ToString()
}
};
using (conn = SqlHelper.CreateConntion())
{
conn.Open();
l = DAL.GetWareHouse(condition, conn);
if (l.Count > 0)
{
return(l[0]);
}
conn.Close();
return(null);
}
}
