public virtual bool EditSupplierPurchase(SupplierPurchaseInfo entity, RBACUserInfo UserPrivilege)
{
if (RBAC.CheckPrivilege(UserPrivilege, "aa55fc69-156e-45fe-84fa-f0df964cd3e0"))
{
return(MyDAL.EditSupplierPurchase(entity));
}
else
{
throw new TradePrivilegeException("没有权限，权限代码：aa55fc69-156e-45fe-84fa-f0df964cd3e0错误");
}
}
public virtual bool AddSupplierPurchase(SupplierPurchaseInfo entity, RBACUserInfo UserPrivilege)
{
if (RBAC.CheckPrivilege(UserPrivilege, "59ac1c26-ba95-42c9-b418-fae8465f6e94"))
{
return(MyDAL.AddSupplierPurchase(entity));
}
else
{
throw new TradePrivilegeException("没有权限，权限代码：59ac1c26-ba95-42c9-b418-fae8465f6e94错误");
}
}
public virtual SupplierPurchaseInfo GetSupplierPurchaseByID(int ID)
{
SupplierPurchaseInfo entity = null;
SqlDataReader RdrList = null;
try
{
string SqlList;
SqlList = "SELECT * FROM Supplier_Purchase WHERE Purchase_ID = " + ID;
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.Read())
{
entity = new SupplierPurchaseInfo();
entity.Purchase_ID = Tools.NullInt(RdrList["Purchase_ID"]);
entity.Purchase_TypeID = Tools.NullInt(RdrList["Purchase_TypeID"]);
entity.Purchase_SupplierID = Tools.NullInt(RdrList["Purchase_SupplierID"]);
entity.Purchase_Title = Tools.NullStr(RdrList["Purchase_Title"]);
entity.Purchase_DeliveryTime = Tools.NullDate(RdrList["Purchase_DeliveryTime"]);
entity.Purchase_State = Tools.NullStr(RdrList["Purchase_State"]);
entity.Purchase_City = Tools.NullStr(RdrList["Purchase_City"]);
entity.Purchase_County = Tools.NullStr(RdrList["Purchase_County"]);
entity.Purchase_Address = Tools.NullStr(RdrList["Purchase_Address"]);
entity.Purchase_Intro = Tools.NullStr(RdrList["Purchase_Intro"]);
entity.Purchase_Addtime = Tools.NullDate(RdrList["Purchase_Addtime"]);
entity.Purchase_Status = Tools.NullInt(RdrList["Purchase_Status"]);
entity.Purchase_IsActive = Tools.NullInt(RdrList["Purchase_IsActive"]);
entity.Purchase_ActiveReason = Tools.NullStr(RdrList["Purchase_ActiveReason"]);
entity.Purchase_Trash = Tools.NullInt(RdrList["Purchase_Trash"]);
entity.Purchase_ValidDate = Tools.NullDate(RdrList["Purchase_ValidDate"]);
entity.Purchase_Attachment = Tools.NullStr(RdrList["Purchase_Attachment"]);
entity.Purchase_Site = Tools.NullStr(RdrList["Purchase_Site"]);
entity.Purchase_IsRecommend = Tools.NullInt(RdrList["Purchase_IsRecommend"]);
entity.Purchase_IsPublic = Tools.NullInt(RdrList["Purchase_IsPublic"]);
entity.Purchase_CateID = Tools.NullInt(RdrList["Purchase_CateID"]);
entity.Purchase_SysUserID = Tools.NullInt(RdrList["Purchase_SysUserID"]);
}
return(entity);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual bool EditSupplierPurchase(SupplierPurchaseInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT * FROM Supplier_Purchase WHERE Purchase_ID = " + entity.Purchase_ID;
DtAdd = DBHelper.Query(SqlAdd);
try
{
if (DtAdd.Rows.Count > 0)
{
DrAdd = DtAdd.Rows[0];
DrAdd["Purchase_ID"] = entity.Purchase_ID;
DrAdd["Purchase_TypeID"] = entity.Purchase_TypeID;
DrAdd["Purchase_SupplierID"] = entity.Purchase_SupplierID;
DrAdd["Purchase_Title"] = entity.Purchase_Title;
DrAdd["Purchase_DeliveryTime"] = entity.Purchase_DeliveryTime;
DrAdd["Purchase_State"] = entity.Purchase_State;
DrAdd["Purchase_City"] = entity.Purchase_City;
DrAdd["Purchase_County"] = entity.Purchase_County;
DrAdd["Purchase_Address"] = entity.Purchase_Address;
DrAdd["Purchase_Intro"] = entity.Purchase_Intro;
DrAdd["Purchase_Addtime"] = entity.Purchase_Addtime;
DrAdd["Purchase_Status"] = entity.Purchase_Status;
DrAdd["Purchase_IsActive"] = entity.Purchase_IsActive;
DrAdd["Purchase_ActiveReason"] = entity.Purchase_ActiveReason;
DrAdd["Purchase_Trash"] = entity.Purchase_Trash;
DrAdd["Purchase_ValidDate"] = entity.Purchase_ValidDate;
DrAdd["Purchase_Attachment"] = entity.Purchase_Attachment;
DrAdd["Purchase_Site"] = entity.Purchase_Site;
DrAdd["Purchase_IsRecommend"] = entity.Purchase_IsRecommend;
DrAdd["Purchase_IsPublic"] = entity.Purchase_IsPublic;
DrAdd["Purchase_CateID"] = entity.Purchase_CateID;
DrAdd["Purchase_SysUserID"] = entity.Purchase_SysUserID;
DBHelper.SaveChanges(SqlAdd, DtAdd);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
DtAdd.Dispose();
}
return(true);
}
public virtual IList <SupplierPurchaseInfo> GetSupplierPurchases(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <SupplierPurchaseInfo> entitys = null;
SupplierPurchaseInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Supplier_Purchase";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <SupplierPurchaseInfo>();
while (RdrList.Read())
{
entity = new SupplierPurchaseInfo();
entity.Purchase_ID = Tools.NullInt(RdrList["Purchase_ID"]);
entity.Purchase_TypeID = Tools.NullInt(RdrList["Purchase_TypeID"]);
entity.Purchase_SupplierID = Tools.NullInt(RdrList["Purchase_SupplierID"]);
entity.Purchase_Title = Tools.NullStr(RdrList["Purchase_Title"]);
entity.Purchase_DeliveryTime = Tools.NullDate(RdrList["Purchase_DeliveryTime"]);
entity.Purchase_State = Tools.NullStr(RdrList["Purchase_State"]);
entity.Purchase_City = Tools.NullStr(RdrList["Purchase_City"]);
entity.Purchase_County = Tools.NullStr(RdrList["Purchase_County"]);
entity.Purchase_Address = Tools.NullStr(RdrList["Purchase_Address"]);
entity.Purchase_Intro = Tools.NullStr(RdrList["Purchase_Intro"]);
entity.Purchase_Addtime = Tools.NullDate(RdrList["Purchase_Addtime"]);
entity.Purchase_Status = Tools.NullInt(RdrList["Purchase_Status"]);
entity.Purchase_IsActive = Tools.NullInt(RdrList["Purchase_IsActive"]);
entity.Purchase_ActiveReason = Tools.NullStr(RdrList["Purchase_ActiveReason"]);
entity.Purchase_Trash = Tools.NullInt(RdrList["Purchase_Trash"]);
entity.Purchase_ValidDate = Tools.NullDate(RdrList["Purchase_ValidDate"]);
entity.Purchase_Attachment = Tools.NullStr(RdrList["Purchase_Attachment"]);
entity.Purchase_Site = Tools.NullStr(RdrList["Purchase_Site"]);
entity.Purchase_IsRecommend = Tools.NullInt(RdrList["Purchase_IsRecommend"]);
entity.Purchase_IsPublic = Tools.NullInt(RdrList["Purchase_IsPublic"]);
entity.Purchase_CateID = Tools.NullInt(RdrList["Purchase_CateID"]);
entity.Purchase_SysUserID = Tools.NullInt(RdrList["Purchase_SysUserID"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
