/// <summary>
/// 仓库管理查询
/// </summary>
/// <param name="page"></param>
/// <param name="limit"></param>
/// <returns></returns>
public static object storeSelect(int page, int limit)
{
string sql = string.Format("select * from (select ROW_NUMBER() OVER(ORDER BY StoreID desc) as rows,* from T_Store) o ");
string sqlpages = sql + string.Format(" where o.rows between ({0}-1)*{1}+1 and {2}*{3} ", page, limit, page, limit);
//总查询记录
var TabCount = DBHelper.Read(sql).Rows.Count;
//分页后查询数据
var TabPage = DBHelper.Read(sqlpages);
List <T_Store> storelst = new List <T_Store>();
foreach (DataRow item in TabPage.Rows)
{
T_Store store = new T_Store
{
StoreID = Convert.ToInt32(item["StoreID"].ToString()),
Name = item["Name"].ToString(),
Status = Convert.ToInt32(item["Status"].ToString())
};
storelst.Add(store);
}
//定义匿名类型 接受供应商总数用于分页
var obj = new
{
status = TabCount,
lst = storelst
};
return(obj);
}
/// <summary>
/// 编辑仓库信息
/// </summary>
private void StoreEdit()
{
T_Store store = new T_Store
{
StoreID = Convert.ToInt32(HttpContext.Current.Request.Form["StoreId"]),
Name = HttpContext.Current.Request.Form["Name"],
Status = Convert.ToInt32(HttpContext.Current.Request.Form["Status"])
};
var obj = new
{
code = 200,
status = "no",
msg = "编辑失败"
};
if (storeBll.storeEdit(store))
{
obj = new
{
code = 201,
status = "yes",
msg = "编辑成功"
};
}
javaScriptSerializer(obj);
}
/// <summary>
/// 仓库编辑查询赋值
/// </summary>
/// <param name="StoreId"></param>
/// <returns></returns>
public static T_Store storeEditSelect(int StoreId)
{
string sql = string.Format("select * from T_Store where StoreID={0}", StoreId);
var db = DBHelper.Read(sql).Rows[0];
T_Store store = new T_Store
{
Name = db["Name"].ToString(),
Status = Convert.ToInt32(db["Status"].ToString())
};
return(store);
}
/// <summary>
/// 采购订单商品入库仓库--查询
/// </summary>
/// <returns></returns>
public static List <T_Store> StoreSelect()
{
string sql = string.Format("select * from T_Store");
var db = DBHelper.Read(sql);
List <T_Store> lst = new List <T_Store>();
foreach (DataRow item in db.Rows)
{
T_Store store = new T_Store
{
StoreID = Convert.ToInt32(item["StoreID"].ToString()),
Name = item["Name"].ToString(),
Status = Convert.ToInt32(item["Status"].ToString())
};
lst.Add(store);
}
return(lst);
}
/// <summary>
/// 修改仓库信息
/// </summary>
/// <param name="store"></param>
/// <returns></returns>
public static bool storeEdit(T_Store store)
{
string sql = string.Format("update T_Store set Name='{0}',Status={1} where StoreID={2}", store.Name, store.Status, store.StoreID);
return(DBHelper.Write(sql));
}
/// <summary>
/// 新增仓库
/// </summary>
/// <param name="store"></param>
/// <returns></returns>
public static bool storeAdd(T_Store store)
{
string sql = string.Format("insert T_Store(Name,Status) values('{0}',{1})", store.Name, store.Status);
return(DBHelper.Write(sql));
}
/// <summary>
/// 修改仓库信息
/// </summary>
/// <param name="store"></param>
/// <returns></returns>
public static bool storeEdit(T_Store store)
{
return(storeDal.storeEdit(store));
}
/// <summary>
/// 新增仓库
/// </summary>
/// <param name="store"></param>
/// <returns></returns>
public static bool storeAdd(T_Store store)
{
return(storeDal.storeAdd(store));
}
