/// <summary>
/// 得到一个对象实体 by SQLpara
/// </summary>
public Lebi_Supplier_Delivery GetModel(SQLPara para)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from [Lebi_Supplier_Delivery] ");
if (para.Where != "")
{
strSql.Append(" where " + para.Where + "");
}
Lebi_Supplier_Delivery model = new Lebi_Supplier_Delivery();
DataSet ds = SqlUtils.SqlUtilsInstance.TextExecuteDataset(strSql.ToString(), para.Para);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
if (ds.Tables[0].Rows[0]["Sort"].ToString() != "")
{
model.Sort = int.Parse(ds.Tables[0].Rows[0]["Sort"].ToString());
}
if (ds.Tables[0].Rows[0]["Supplier_id"].ToString() != "")
{
model.Supplier_id = int.Parse(ds.Tables[0].Rows[0]["Supplier_id"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 编辑配送点
/// </summary>
public void Delivery_Edit()
{
if (!Power("supplier_delivery_list", "配送点管理"))
{
AjaxNoPower();
return;
}
int id = RequestTool.RequestInt("id", 0);
bool addflag = false;
Lebi_Supplier_Delivery model = B_Lebi_Supplier_Delivery.GetModel("id = " + id + " and Supplier_id = " + CurrentSupplier.id + "");
if (model == null)
{
addflag = true;
model = new Lebi_Supplier_Delivery();
}
model = B_Lebi_Supplier_Delivery.SafeBindForm(model);
if (addflag)
{
model.Supplier_id = CurrentSupplier.id;
B_Lebi_Supplier_Delivery.Add(model);
id = B_Lebi_Supplier_Delivery.GetMaxId();
Log.Add("添加配送点", "Delivery", id.ToString(), CurrentSupplier, model.Name);
}
else
{
B_Lebi_Supplier_Delivery.Update(model);
Log.Add("编辑配送点", "Delivery", id.ToString(), CurrentSupplier, model.Name);
}
string result = "{\"msg\":\"OK\", \"id\":\"" + id + "\"}";
Response.Write(result);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Lebi_Supplier_Delivery model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [Lebi_Supplier_Delivery] set ");
strSql.Append("Name= @Name,");
strSql.Append("Remark= @Remark,");
strSql.Append("Sort= @Sort,");
strSql.Append("Supplier_id= @Supplier_id");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Remark", SqlDbType.NVarChar, 200),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@Supplier_id", SqlDbType.Int, 4)
};
parameters[0].Value = model.id;
parameters[1].Value = model.Name;
parameters[2].Value = model.Remark;
parameters[3].Value = model.Sort;
parameters[4].Value = model.Supplier_id;
SqlUtils.SqlUtilsInstance.TextExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Lebi_Supplier_Delivery model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Lebi_Supplier_Delivery](");
strSql.Append("Name,Remark,Sort,Supplier_id)");
strSql.Append(" values (");
strSql.Append("@Name,@Remark,@Sort,@Supplier_id)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Name", model.Name),
new SqlParameter("@Remark", model.Remark),
new SqlParameter("@Sort", model.Sort),
new SqlParameter("@Supplier_id", model.Supplier_id)
};
object obj = SqlUtils.SqlUtilsInstance.TextExecuteNonQuery(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
public Lebi_Supplier_Delivery GetDelivery(int id)
{
Lebi_Supplier_Delivery model = B_Lebi_Supplier_Delivery.GetModel(id);
if (model == null)
{
model = new Lebi_Supplier_Delivery();
}
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Power("supplier_delivery_list", "配送点管理"))
{
WindowNoPower();
}
int id = RequestTool.RequestInt("id", 0);
model = B_Lebi_Supplier_Delivery.GetModel("id = " + id + " and Supplier_id = " + CurrentSupplier.id + "");
if (model == null)
{
model = new Lebi_Supplier_Delivery();
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Lebi_Supplier_Delivery model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Lebi_Supplier_Delivery](");
strSql.Append("[Name],[Remark],[Sort],[Supplier_id])");
strSql.Append(" values (");
strSql.Append("@Name,@Remark,@Sort,@Supplier_id)");
OleDbParameter[] parameters =
{
new OleDbParameter("@Name", model.Name),
new OleDbParameter("@Remark", model.Remark),
new OleDbParameter("@Sort", model.Sort),
new OleDbParameter("@Supplier_id", model.Supplier_id)
};
AccessUtils.Instance.TextExecuteNonQuery(strSql.ToString(), parameters);
return(1);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Lebi_Supplier_Delivery model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [Lebi_Supplier_Delivery] set ");
strSql.Append("[Name]=@Name,");
strSql.Append("[Remark]=@Remark,");
strSql.Append("[Sort]=@Sort,");
strSql.Append("[Supplier_id]=@Supplier_id");
strSql.Append(" where id=" + model.id);
OleDbParameter[] parameters =
{
new OleDbParameter("@Name", model.Name),
new OleDbParameter("@Remark", model.Remark),
new OleDbParameter("@Sort", model.Sort),
new OleDbParameter("@Supplier_id", model.Supplier_id)
};
AccessUtils.Instance.TextExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 安全方式绑定对象表单
/// </summary>
public Lebi_Supplier_Delivery SafeBindForm(Lebi_Supplier_Delivery model)
{
if (HttpContext.Current.Request["Name"] != null)
{
model.Name = Shop.Tools.RequestTool.RequestSafeString("Name");
}
if (HttpContext.Current.Request["Remark"] != null)
{
model.Remark = Shop.Tools.RequestTool.RequestSafeString("Remark");
}
if (HttpContext.Current.Request["Sort"] != null)
{
model.Sort = Shop.Tools.RequestTool.RequestInt("Sort", 0);
}
if (HttpContext.Current.Request["Supplier_id"] != null)
{
model.Supplier_id = Shop.Tools.RequestTool.RequestInt("Supplier_id", 0);
}
return(model);
}
/// <summary>
/// 得到一个对象实体 by id
/// </summary>
public Lebi_Supplier_Delivery GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from [Lebi_Supplier_Delivery] ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Lebi_Supplier_Delivery model = new Lebi_Supplier_Delivery();
DataSet ds = SqlUtils.SqlUtilsInstance.TextExecuteDataset(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
if (ds.Tables[0].Rows[0]["Sort"].ToString() != "")
{
model.Sort = int.Parse(ds.Tables[0].Rows[0]["Sort"].ToString());
}
if (ds.Tables[0].Rows[0]["Supplier_id"].ToString() != "")
{
model.Supplier_id = int.Parse(ds.Tables[0].Rows[0]["Supplier_id"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public Lebi_Supplier_Delivery ReaderBind(IDataReader dataReader)
{
Lebi_Supplier_Delivery model = new Lebi_Supplier_Delivery();
object ojb;
ojb = dataReader["id"];
if (ojb != null && ojb != DBNull.Value)
{
model.id = (int)ojb;
}
model.Name = dataReader["Name"].ToString();
model.Remark = dataReader["Remark"].ToString();
ojb = dataReader["Sort"];
if (ojb != null && ojb != DBNull.Value)
{
model.Sort = (int)ojb;
}
ojb = dataReader["Supplier_id"];
if (ojb != null && ojb != DBNull.Value)
{
model.Supplier_id = (int)ojb;
}
return(model);
}
/// <summary>
/// 导出供应商订单数据(商品)
/// </summary>
public void SupplierOrder_product_Export()
{
if (!EX_Admin.Power("statis_orderproduct", "订单报表"))
{
PageNoPower();
}
string where = RequestTool.RequestString("where");
where = Server.UrlDecode(where).Replace("´", "'");
//SystemLog.Add(where);
string titles = "" + Tag("序号") + "," + Tag("供应商") + "," + Tag("配送点") + "," + Tag("单号") + "," + Tag("订购日期") + "," + Tag("发货时间") + "," + Tag("支付状态") + "," + Tag("支付方式") + "," + Tag("配送方式") + "," + Tag("商品名称") + "," + Tag("条形码") + "," + Tag("商品条码") + "," + Tag("单位") + "," + Tag("数量") + "," + Tag("金额") + "";
string[] arr = titles.Split(',');
DataTable dt = new DataTable();
foreach (string col in arr)
{
dt.Columns.Add(col);
}
DataRow r = dt.NewRow();
dt.Rows.Add(r);
//List<Lebi_Order_Product> models = B_Lebi_Order_Product.GetList("Order_id in (select id from Lebi_Order where " + where + ")", "id desc");
List <Lebi_Order_Product> models = B_Lebi_Order_Product.GetList(where, "id desc");
//Response.Write(models.Count);
//Response.End();
StringBuilder sb = new StringBuilder();
if (!Shop.LebiAPI.Service.Instanse.Check("managelicenese"))
{
sb.Append("LebiShop V" + SYS.Version + "." + SYS.Version_Son + " (http://www.lebi.cn),\r\n");
}
sb.Append(titles + "\r\n");
//sb.Append("标签,");
//sb.Append(tag + "\r\n");
int i = 0;
Lebi_Supplier supplier;
Lebi_Supplier_Delivery delivery;
Lebi_Order order;
foreach (Lebi_Order_Product model in models)
{
order = Shop.Bussiness.Order.GetOrder(model.Order_id);
i++;
supplier = B_Lebi_Supplier.GetModel(order.Supplier_id);
if (supplier == null)
{
supplier = new Lebi_Supplier();
}
delivery = B_Lebi_Supplier_Delivery.GetModel(order.Supplier_Delivery_id);
if (delivery == null)
{
delivery = new Lebi_Supplier_Delivery();
}
sb.Append(i + ",");
sb.Append(out_txt(supplier.SubName) + ",");
sb.Append(out_txt(delivery.Name) + ",");
sb.Append(order.Code + ",");
sb.Append(order.Time_Add.ToString("yyyy-MM-dd HH:mm:ss") + ",");
if (order.IsShipped == 1)
{
sb.Append(order.Time_Shipped.ToString("yyyy-MM-dd HH:mm:ss") + ",");
}
else
{
sb.Append("-,");
}
sb.Append((order.IsPaid == 1 ? Tag("已支付") : Tag("未支付")) + ",");
sb.Append(out_txt(Lang(order.Pay) + Lang(order.OnlinePay)) + ",");
sb.Append(out_txt(order.Transport_Name) + ",");
sb.Append(out_txt(Lang(model.Product_Name)) + ",");
sb.Append(model.Product_Number + ",");
sb.Append(Shop.Bussiness.EX_Product.GetProduct(model.Product_id).Code + ",");
sb.Append(Lang(Shop.Bussiness.EX_Product.ProductUnit(Shop.Bussiness.EX_Product.GetProduct(model.Product_id).Units_id)) + ",");
sb.Append(model.Count + ",");
sb.Append(model.Price * model.Count);
sb.Append("\r\n");
}
FileTool.StringTofile(sb.ToString(), "order", ".csv");
}
/// <summary>
/// 更新一条数据
/// </summary>
public static void Update(Lebi_Supplier_Delivery model)
{
D_Lebi_Supplier_Delivery.Instance.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(Lebi_Supplier_Delivery model)
{
return(D_Lebi_Supplier_Delivery.Instance.Add(model));
}
/// <summary>
/// 安全方式绑定表单数据
/// </summary>
public static Lebi_Supplier_Delivery SafeBindForm(Lebi_Supplier_Delivery model)
{
return(D_Lebi_Supplier_Delivery.Instance.SafeBindForm(model));
}
