public virtual IList <DeliveryWayInfo> GetDeliveryWays(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <DeliveryWayInfo> entitys = null;
DeliveryWayInfo entity = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "Delivery_Way";
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 <DeliveryWayInfo>();
while (RdrList.Read())
{
entity = new DeliveryWayInfo();
entity.Delivery_Way_ID = Tools.NullInt(RdrList["Delivery_Way_ID"]);
entity.Delivery_Way_SupplierID = Tools.NullInt(RdrList["Delivery_Way_SupplierID"]);
entity.Delivery_Way_Name = Tools.NullStr(RdrList["Delivery_Way_Name"]);
entity.Delivery_Way_Sort = Tools.NullInt(RdrList["Delivery_Way_Sort"]);
entity.Delivery_Way_InitialWeight = Tools.NullInt(RdrList["Delivery_Way_InitialWeight"]);
entity.Delivery_Way_UpWeight = Tools.NullInt(RdrList["Delivery_Way_UpWeight"]);
entity.Delivery_Way_FeeType = Tools.NullInt(RdrList["Delivery_Way_FeeType"]);
entity.Delivery_Way_Fee = Tools.NullDbl(RdrList["Delivery_Way_Fee"]);
entity.Delivery_Way_InitialFee = Tools.NullDbl(RdrList["Delivery_Way_InitialFee"]);
entity.Delivery_Way_UpFee = Tools.NullDbl(RdrList["Delivery_Way_UpFee"]);
entity.Delivery_Way_Status = Tools.NullInt(RdrList["Delivery_Way_Status"]);
entity.Delivery_Way_Cod = Tools.NullInt(RdrList["Delivery_Way_Cod"]);
entity.Delivery_Way_Img = Tools.NullStr(RdrList["Delivery_Way_Img"]);
entity.Delivery_Way_Url = Tools.NullStr(RdrList["Delivery_Way_Url"]);
entity.Delivery_Way_Intro = Tools.NullStr(RdrList["Delivery_Way_Intro"]);
entity.Delivery_Way_Site = Tools.NullStr(RdrList["Delivery_Way_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex) {
throw ex;
}
finally {
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual bool EditDeliveryWay(DeliveryWayInfo entity, RBACUserInfo UserPrivilege)
{
if (RBAC.CheckPrivilege(UserPrivilege, "58d92d67-4e0b-4a4c-bd5c-6062c432554d"))
{
return(MyDAL.EditDeliveryWay(entity));
}
else
{
throw new TradePrivilegeException("没有权限，权限代码：58d92d67-4e0b-4a4c-bd5c-6062c432554d错误");
}
}
public virtual bool AddDeliveryWay(DeliveryWayInfo entity, RBACUserInfo UserPrivilege)
{
if (RBAC.CheckPrivilege(UserPrivilege, "8632585c-0447-4003-a97d-48cade998a05"))
{
return(MyDAL.AddDeliveryWay(entity));
}
else
{
throw new TradePrivilegeException("没有权限，权限代码：8632585c-0447-4003-a97d-48cade998a05错误");
}
}
public virtual IList <DeliveryWayInfo> GetDeliveryWaysByDistrict(string state, string city, string county)
{
IList <DeliveryWayInfo> entitys = null;
DeliveryWayInfo entity = null;
string SqlList;
SqlDataReader RdrList = null;
try
{
SqlList = "select * from Delivery_Way where Delivery_Way_ID in (select District_DeliveryWayID from Delivery_Way_District where (District_State='' or District_State='" + state + "') and (District_City='' or District_City='" + city + "') and (District_County='' or District_County='" + county + "')) and Delivery_Way_Status=1 order by Delivery_Way_Sort asc";
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <DeliveryWayInfo>();
while (RdrList.Read())
{
entity = new DeliveryWayInfo();
entity.Delivery_Way_ID = Tools.NullInt(RdrList["Delivery_Way_ID"]);
entity.Delivery_Way_SupplierID = Tools.NullInt(RdrList["Delivery_Way_SupplierID"]);
entity.Delivery_Way_Name = Tools.NullStr(RdrList["Delivery_Way_Name"]);
entity.Delivery_Way_Sort = Tools.NullInt(RdrList["Delivery_Way_Sort"]);
entity.Delivery_Way_InitialWeight = Tools.NullInt(RdrList["Delivery_Way_InitialWeight"]);
entity.Delivery_Way_UpWeight = Tools.NullInt(RdrList["Delivery_Way_UpWeight"]);
entity.Delivery_Way_FeeType = Tools.NullInt(RdrList["Delivery_Way_FeeType"]);
entity.Delivery_Way_Fee = Tools.NullDbl(RdrList["Delivery_Way_Fee"]);
entity.Delivery_Way_InitialFee = Tools.NullDbl(RdrList["Delivery_Way_InitialFee"]);
entity.Delivery_Way_UpFee = Tools.NullDbl(RdrList["Delivery_Way_UpFee"]);
entity.Delivery_Way_Status = Tools.NullInt(RdrList["Delivery_Way_Status"]);
entity.Delivery_Way_Cod = Tools.NullInt(RdrList["Delivery_Way_Cod"]);
entity.Delivery_Way_Img = Tools.NullStr(RdrList["Delivery_Way_Img"]);
entity.Delivery_Way_Url = Tools.NullStr(RdrList["Delivery_Way_Url"]);
entity.Delivery_Way_Intro = Tools.NullStr(RdrList["Delivery_Way_Intro"]);
entity.Delivery_Way_Site = Tools.NullStr(RdrList["Delivery_Way_Site"]);
entitys.Add(entity);
entity = null;
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public void EditDeliveryWay()
{
int Delivery_Way_ID = tools.CheckInt(Request.Form["Delivery_Way_ID"]);
string Delivery_Way_Name = tools.CheckStr(Request.Form["Delivery_Way_Name"]);
int Delivery_Way_Sort = tools.CheckInt(Request.Form["Delivery_Way_Sort"]);
int Delivery_Way_InitialWeight = tools.CheckInt(Request.Form["Delivery_Way_InitialWeight"]);
int Delivery_Way_UpWeight = tools.CheckInt(Request.Form["Delivery_Way_UpWeight"]);
int Delivery_Way_FeeType = tools.CheckInt(Request.Form["Delivery_Way_FeeType"]);
double Delivery_Way_Fee = tools.CheckFloat(Request.Form["Delivery_Way_Fee"]);
double Delivery_Way_InitialFee = tools.CheckFloat(Request.Form["Delivery_Way_InitialFee"]);
double Delivery_Way_UpFee = tools.CheckFloat(Request.Form["Delivery_Way_UpFee"]);
int Delivery_Way_Status = tools.CheckInt(Request.Form["Delivery_Way_Status"]);
int Delivery_Way_Cod = tools.CheckInt(Request.Form["Delivery_Way_Cod"]);
string Delivery_Way_Img = tools.CheckStr(Request.Form["Delivery_Way_Img"]);
string Delivery_Way_Url = tools.CheckStr(Request.Form["Delivery_Way_Url"]);
string Delivery_Way_Intro = Request.Form["Delivery_Way_Intro"];
if (Delivery_Way_Name.Length == 0)
{
Public.Msg("error", "错误信息", "请填写配送方式名称", false, "{back}"); return;
}
DeliveryWayInfo entity = new DeliveryWayInfo();
entity.Delivery_Way_ID = Delivery_Way_ID;
entity.Delivery_Way_Name = Delivery_Way_Name;
entity.Delivery_Way_Sort = Delivery_Way_Sort;
entity.Delivery_Way_InitialWeight = Delivery_Way_InitialWeight;
entity.Delivery_Way_UpWeight = Delivery_Way_UpWeight;
entity.Delivery_Way_FeeType = Delivery_Way_FeeType;
entity.Delivery_Way_Fee = Delivery_Way_Fee;
entity.Delivery_Way_InitialFee = Delivery_Way_InitialFee;
entity.Delivery_Way_UpFee = Delivery_Way_UpFee;
entity.Delivery_Way_Status = Delivery_Way_Status;
entity.Delivery_Way_Cod = Delivery_Way_Cod;
entity.Delivery_Way_Img = Delivery_Way_Img;
entity.Delivery_Way_Url = Delivery_Way_Url;
entity.Delivery_Way_Intro = Delivery_Way_Intro;
entity.Delivery_Way_Site = Public.GetCurrentSite();
if (MyBLL.EditDeliveryWay(entity, Public.GetUserPrivilege()))
{
Public.Msg("positive", "操作成功", "操作成功", true, "delivery_way_list.aspx");
}
else
{
Public.Msg("error", "错误信息", "操作失败，请稍后重试", false, "{back}");
}
}
public virtual bool EditDeliveryWay(DeliveryWayInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT * FROM Delivery_Way WHERE Delivery_Way_ID = " + entity.Delivery_Way_ID;
DtAdd = DBHelper.Query(SqlAdd);
try {
if (DtAdd.Rows.Count > 0)
{
DrAdd = DtAdd.Rows[0];
DrAdd["Delivery_Way_ID"] = entity.Delivery_Way_ID;
DrAdd["Delivery_Way_SupplierID"] = entity.Delivery_Way_SupplierID;
DrAdd["Delivery_Way_Name"] = entity.Delivery_Way_Name;
DrAdd["Delivery_Way_Sort"] = entity.Delivery_Way_Sort;
DrAdd["Delivery_Way_InitialWeight"] = entity.Delivery_Way_InitialWeight;
DrAdd["Delivery_Way_UpWeight"] = entity.Delivery_Way_UpWeight;
DrAdd["Delivery_Way_FeeType"] = entity.Delivery_Way_FeeType;
DrAdd["Delivery_Way_Fee"] = entity.Delivery_Way_Fee;
DrAdd["Delivery_Way_InitialFee"] = entity.Delivery_Way_InitialFee;
DrAdd["Delivery_Way_UpFee"] = entity.Delivery_Way_UpFee;
DrAdd["Delivery_Way_Status"] = entity.Delivery_Way_Status;
DrAdd["Delivery_Way_Cod"] = entity.Delivery_Way_Cod;
DrAdd["Delivery_Way_Img"] = entity.Delivery_Way_Img;
DrAdd["Delivery_Way_Url"] = entity.Delivery_Way_Url;
DrAdd["Delivery_Way_Intro"] = entity.Delivery_Way_Intro;
DrAdd["Delivery_Way_Site"] = entity.Delivery_Way_Site;
DBHelper.SaveChanges(SqlAdd, DtAdd);
}
else
{
return(false);
}
}
catch (Exception ex) {
throw ex;
}
finally {
DtAdd.Dispose();
}
return(true);
}
public virtual DeliveryWayInfo GetDeliveryWayByID(int ID)
{
DeliveryWayInfo entity = null;
SqlDataReader RdrList = null;
try
{
string SqlList;
SqlList = "SELECT * FROM Delivery_Way WHERE Delivery_Way_ID = " + ID;
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.Read())
{
entity = new DeliveryWayInfo();
entity.Delivery_Way_ID = Tools.NullInt(RdrList["Delivery_Way_ID"]);
entity.Delivery_Way_SupplierID = Tools.NullInt(RdrList["Delivery_Way_SupplierID"]);
entity.Delivery_Way_Name = Tools.NullStr(RdrList["Delivery_Way_Name"]);
entity.Delivery_Way_Sort = Tools.NullInt(RdrList["Delivery_Way_Sort"]);
entity.Delivery_Way_InitialWeight = Tools.NullInt(RdrList["Delivery_Way_InitialWeight"]);
entity.Delivery_Way_UpWeight = Tools.NullInt(RdrList["Delivery_Way_UpWeight"]);
entity.Delivery_Way_FeeType = Tools.NullInt(RdrList["Delivery_Way_FeeType"]);
entity.Delivery_Way_Fee = Tools.NullDbl(RdrList["Delivery_Way_Fee"]);
entity.Delivery_Way_InitialFee = Tools.NullDbl(RdrList["Delivery_Way_InitialFee"]);
entity.Delivery_Way_UpFee = Tools.NullDbl(RdrList["Delivery_Way_UpFee"]);
entity.Delivery_Way_Status = Tools.NullInt(RdrList["Delivery_Way_Status"]);
entity.Delivery_Way_Cod = Tools.NullInt(RdrList["Delivery_Way_Cod"]);
entity.Delivery_Way_Img = Tools.NullStr(RdrList["Delivery_Way_Img"]);
entity.Delivery_Way_Url = Tools.NullStr(RdrList["Delivery_Way_Url"]);
entity.Delivery_Way_Intro = Tools.NullStr(RdrList["Delivery_Way_Intro"]);
entity.Delivery_Way_Site = Tools.NullStr(RdrList["Delivery_Way_Site"]);
}
return(entity);
}
catch (Exception ex) {
throw ex;
}
finally {
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public virtual bool AddDeliveryWay(DeliveryWayInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM Delivery_Way";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Delivery_Way_ID"] = entity.Delivery_Way_ID;
DrAdd["Delivery_Way_SupplierID"] = entity.Delivery_Way_SupplierID;
DrAdd["Delivery_Way_Name"] = entity.Delivery_Way_Name;
DrAdd["Delivery_Way_Sort"] = entity.Delivery_Way_Sort;
DrAdd["Delivery_Way_InitialWeight"] = entity.Delivery_Way_InitialWeight;
DrAdd["Delivery_Way_UpWeight"] = entity.Delivery_Way_UpWeight;
DrAdd["Delivery_Way_FeeType"] = entity.Delivery_Way_FeeType;
DrAdd["Delivery_Way_Fee"] = entity.Delivery_Way_Fee;
DrAdd["Delivery_Way_InitialFee"] = entity.Delivery_Way_InitialFee;
DrAdd["Delivery_Way_UpFee"] = entity.Delivery_Way_UpFee;
DrAdd["Delivery_Way_Status"] = entity.Delivery_Way_Status;
DrAdd["Delivery_Way_Cod"] = entity.Delivery_Way_Cod;
DrAdd["Delivery_Way_Img"] = entity.Delivery_Way_Img;
DrAdd["Delivery_Way_Url"] = entity.Delivery_Way_Url;
DrAdd["Delivery_Way_Intro"] = entity.Delivery_Way_Intro;
DrAdd["Delivery_Way_Site"] = entity.Delivery_Way_Site;
DtAdd.Rows.Add(DrAdd);
try {
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex) {
throw ex;
}
finally {
DtAdd.Dispose();
}
}
public string GetDeliveryWayDistricts()
{
int Delivery_Way_ID = tools.CheckInt(Request.QueryString["Delivery_Way_ID"]);
IList <DeliveryWayDistrictInfo> entitys = MyBLL.GetDeliveryWayDistrictsByDWID(Delivery_Way_ID, Public.GetUserPrivilege());
if (entitys != null)
{
DeliveryWayInfo wayinfo = MyBLL.GetDeliveryWayByID(Delivery_Way_ID, Public.GetUserPrivilege());
StateInfo stateEntity = null;
CityInfo cityEntity = null;
CountyInfo countyEntity = null;
StringBuilder jsonBuilder = new StringBuilder();
jsonBuilder.Append("{\"page\":1,\"total\":1,\"records\":" + entitys.Count + ",\"rows\"");
jsonBuilder.Append(":[");
foreach (DeliveryWayDistrictInfo entity in entitys)
{
stateEntity = addrBLL.GetStateInfoByCode(entity.District_State);
cityEntity = addrBLL.GetCityInfoByCode(entity.District_City);
countyEntity = addrBLL.GetCountyInfoByCode(entity.District_County);
jsonBuilder.Append("{\"DeliveryWayDistrictInfo.District_ID\":" + entity.District_ID + ",\"cell\":[");
//各字段
jsonBuilder.Append("\"");
jsonBuilder.Append(entity.District_ID);
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
if (wayinfo == null)
{
jsonBuilder.Append(Delivery_Way_ID);
}
else
{
jsonBuilder.Append(wayinfo.Delivery_Way_Name);
}
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
if (entity.District_State == "0" || entity.District_State.Length == 0)
{
jsonBuilder.Append("全部");
}
else
{
if (stateEntity == null)
{
jsonBuilder.Append(entity.District_State);
}
else
{
jsonBuilder.Append(stateEntity.State_CN);
}
}
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
if (entity.District_City == "0" || entity.District_City.Length == 0)
{
jsonBuilder.Append("全部");
}
else
{
if (cityEntity == null)
{
jsonBuilder.Append(entity.District_City);
}
else
{
jsonBuilder.Append(cityEntity.City_CN);
}
}
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
if (entity.District_County == "0" || entity.District_County.Length == 0)
{
jsonBuilder.Append("全部");
}
else
{
if (countyEntity == null)
{
jsonBuilder.Append(entity.District_County);
}
else
{
jsonBuilder.Append(countyEntity.County_CN);
}
}
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
jsonBuilder.Append("<img src=\\\"/images/icon_edit.gif\\\" alt=\\\"修改\\\"> <a href=\\\"district_list.aspx?action=renew&delivery_way_id=" + Delivery_Way_ID + "&district_id=" + entity.District_ID + "\\\" title=\\\"修改\\\">修改</a> <img src=\\\"/images/icon_del.gif\\\" alt=\\\"删除\\\"> <a href=\\\"javascript:void(0);\\\" onclick=\\\"confirmdelete('district_do.aspx?action=move&delivery_way_id=" + Delivery_Way_ID + "&district_id=" + entity.District_ID + "')\\\" title=\\\"删除\\\">删除</a>");
jsonBuilder.Append("\",");
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return(jsonBuilder.ToString());
}
else
{
return(null);
}
}
