(1)UI层
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Threading;
namespace PMS.PMS_MyProductionPlan
{
public partial class WebForm1 : System.Web.UI.Page
{
CommonOper.CommonOper commonOper = new CommonOper.CommonOper();
MsgBox msgBox = new MsgBox();
CommonOper.FileOperate fileOperate = new CommonOper.FileOperate(); //定义文件操作
BLL.MyProductionPlan.ProductionPlanSubmit B_ProductionPlanSubmit = new BLL.MyProductionPlan.ProductionPlanSubmit();
BLL.ManageSys.MSG B_MSG = new BLL.ManageSys.MSG();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["USERID"] == null || Session["USERID"].ToString() == "")
{
Response.Redirect(commonOper.GetSysUrl() + "/Default.aspx");
}
createResult();
}
}
private void createResult()
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
dt.Columns.Add("产品名称", typeof(string));
dt.Columns.Add("供应商编号", typeof(string));
dt.Columns.Add("类别编号", typeof(string));
dt.Columns.Add("单位数量", typeof(string));
dt.Columns.Add("产品单价", typeof(string));
dt.Columns.Add("库存量", typeof(string));
dt.Columns.Add("已订购量", typeof(string));
dt.Columns.Add("安全存量", typeof(string));
dt.Columns.Add("IsSale", typeof(string));
dt.Columns.Add("Remark", typeof(string));
dt.Columns.Add("Id_Department", typeof(string));
ds.Tables.Add(dt);
ViewState["DS_PRODUCTIONPLAN"]=ds;
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
//实现自增序号
if (e.Row.RowIndex != -1)
{
int indexID = e.Row.RowIndex + 1;
e.Row.Cells[0].Text = indexID.ToString();
/*分页情况
* int indexID = this.GridView1.PageIndex * this.myGridView.PageSize + e.Row.RowIndex + 1;
e.Row.Cells[0].Text = indexID.ToString();
*/
}
//鼠标滑过行变色
if (e.Row.RowType == DataControlRowType.DataRow)
{
//鼠标移动到每项时颜色交替效果
e.Row.Attributes.Add("OnMouseOut", "this.style.backgroundColor='White';this.style.color='#003399'");
e.Row.Attributes.Add("OnMouseOver", "this.style.backgroundColor='#6699FF';this.style.color='#8C4510'");
//设置悬浮鼠标指针形状为"小手"
e.Row.Attributes["style"] = "Cursor:hand";
}
}
protected void ButtonAdd_Click(object sender, EventArgs e)//添加产品资料
{
checkTextBox();//检测编辑框是否为空
if (TextProStoreNum.Text.Trim() != "" && TextProSafeNum.Text.Trim() != "" && TextProPrice.Text.Trim() != "" &&
TextProNum.Text.Trim() != "" && TextProName.Text.Trim() != "" && TextProID.Text.Trim() != "" && TextProClass.Text.Trim() != ""
&& TextProBookNum.Text.Trim() != "")
{
DataRow dr = ((DataSet)ViewState["DS_PRODUCTIONPLAN"]).Tables[0].NewRow();//生成新行
//dr["产品名称"] = TextProName.Text.Trim();//也可以用这种方法
dr.ItemArray = new object[]{
TextProName.Text.Trim(),
TextProID.Text.Trim(),
TextProClass.Text.Trim(),
TextProNum.Text.Trim(),
TextProPrice.Text.Trim(),
TextProStoreNum.Text.Trim(),
TextProBookNum.Text.Trim(),
TextProSafeNum.Text.Trim(),
DropDownList1.SelectedItem.Text.Trim(),
TextRemark.Text,
Convert.ToDecimal(Session["WSH_ID"])//部门编号
};
((DataSet)ViewState["DS_PRODUCTIONPLAN"]).Tables[0].Rows.Add(dr);//往表格填数据
bind();
Reset();//添加完毕后清空文本框
}
else
{
msgBox.AjaxResponeSrcipt(UpdatePanel1, this.GetType(), "请您输入完整的产品资料信息!");
//msgBox.Show(this, "请您输入完整的产品资料信息");
}
}
protected void bind()//显示表格
{
if (((DataSet)ViewState["DS_PRODUCTIONPLAN"]).Tables[0].Rows.Count > 0)
{
trProductPlan.Style.Value = "";
GridView1.DataSource=(DataSet)(ViewState["DS_PRODUCTIONPLAN"]);
GridView1.DataBind();
}
else
{
GridView1.DataSource = null;
GridView1.DataBind();
trProductPlan.Style.Value = "display:none";
//msgBox.AjaxResponeSrcipt(UpdatePanel1, this.GetType(), "添加失败!");
}
}
protected void checkTextBox()//检测编辑框是否为空
{
if (TextProName.Text.Trim() == "")
{
//msgBox.AjaxResponeSrcipt(UpdatePanel1, this.GetType(), "请您输入相应的产品名称!");
msgBox.Show(this, "请您输入相应的产品名称");
TextProName.Focus();
}
else if (TextProID.Text.Trim() == "")
{
msgBox.AjaxResponeSrcipt(UpdatePanel1, this.GetType(), "请您输入相应的供应商编号!");
//msgBox.Show(this, "请您输入相应的供应商编号!");
TextProID.Focus();
}
else if (TextProClass.Text.Trim() == "")
{
msgBox.AjaxResponeSrcipt(UpdatePanel1, this.GetType(), "请您输入相应的类别编号!");
//msgBox.Show(this, "请您输入相应的类别编号!");
TextProClass.Focus();
}
else if (TextProNum.Text.Trim() == "")
{
msgBox.AjaxResponeSrcipt(UpdatePanel1, this.GetType(), "请您输入相应的产品单位数量!");
//msgBox.Show(this, "请您输入相应的产品单位数量");
TextProNum.Focus();
}
else if (TextProPrice.Text.Trim() == "")
{
msgBox.AjaxResponeSrcipt(UpdatePanel1, this.GetType(), "请您输入相应的产品单价!");
//msgBox.Show(this, "请您输入相应的产品单价");
TextProPrice.Focus();
}
else if (TextProStoreNum.Text.Trim() == "")
{
msgBox.AjaxResponeSrcipt(UpdatePanel1, this.GetType(), "请您输入相应的产品库存量!");
//msgBox.Show(this, "请您输入相应的产品库存量");
TextRemark.Focus();
}
else if (TextProBookNum.Text.Trim() == "")
{
msgBox.AjaxResponeSrcipt(UpdatePanel1, this.GetType(), "请输入相应的产品订购量!");
//msgBox.Show(this, "请输入相应的产品订购量!");
TextProBookNum.Focus();
}
else if (TextProSafeNum.Text.Trim() == "")
{
msgBox.AjaxResponeSrcipt(UpdatePanel1, this.GetType(), "请您输入相应的产品安全存量!");
//msgBox.Show(this, "请您输入相应的产品安全存量");
TextProSafeNum.Focus();
}
}
protected void ButtonReset_Click(object sender, EventArgs e)//重置
{
Reset();
}
protected void Reset()//重置
{
TextProName.Text = "";
TextProID.Text = "";
TextProClass.Text = "";
TextProNum.Text = "";
TextProPrice.Text = "";
TextProStoreNum.Text = "";
TextProBookNum.Text = "";
TextProSafeNum.Text = "";
TextRemark.Text = "";
TextProName.Focus();//焦点于产品名称文本编辑框
}
protected void ButtonSubmit_Click(object sender, EventArgs e)//提交
{
if (B_ProductionPlanSubmit.addProductionPlan((DataSet)(ViewState["DS_PRODUCTIONPLAN"])))
{
((DataSet)(ViewState["DS_PRODUCTIONPLAN"])).Tables[0].Rows.Clear();//清空
msgBox.AjaxResponeSrcipt(UpdatePanel1,this.GetType(),"提交成功!");
bind();
}
else
{
msgBox.AjaxResponeSrcipt(UpdatePanel1, this.GetType(), "提交失败!");
}
}
protected void Cancel_Click(object sender, EventArgs e)//取消
{
((DataSet)ViewState["DS_PRODUCTIONPLAN"]).Tables[0].Rows.Clear();
bind();
}
//进行删除表格中某一行
protected void LinkButtonDelete_Click(object sender, EventArgs e)//删除
{
GridViewRow gvr = (GridViewRow)((DataControlFieldCell)(((LinkButton)(sender)).Parent)).Parent;
int index = Convert.ToInt32(gvr.Cells[0].Text) - 1;
((DataSet)(ViewState["DS_PRODUCTIONPLAN"])).Tables[0].Rows.RemoveAt(index);
bind();
}
//编辑表格
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)//编辑该项
{
GridView1.EditIndex = e.NewEditIndex;
bind();
}
//取消编辑
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)//取消修改
{
GridView1.EditIndex = -1;
bind();
}
//编辑更改保存
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)//更新
{
//((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString();
GridViewRow gvr = (GridViewRow)((DataControlFieldCell)(((LinkButton)(sender)).Parent)).Parent;//获取行号
gvr.Cells[1].Text = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString();
}
}
}
(2)BLL层
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Factory;
using IDAL;
using System.Data;
namespace BLL.MyProductionPlan
{
public class ProductionPlanSubmit
{
private readonly ITB_ProductionPlanDetail dal_ProductionPlanDetail = DataAccess.CreateTB_ProductionPlanDetail();
private readonly ITB_ProductionPlan dal_ProductionPlan = DataAccess.CreateTB_ProductionPlan();
public List<decimal> ListId = new List<decimal>();
public bool addProductionPlan(DataSet ds) //添加产品计划
{
ListId.Clear();
if (ds != null && ds.Tables.Count > 0)
{
Entity.TB_ProductionPlanDetail E_ProductionPlanDetail = new Entity.TB_ProductionPlanDetail();
foreach (DataRow dr in ds.Tables[0].Rows)
{
E_ProductionPlanDetail.产品名称 = dr["产品名称"].ToString();
E_ProductionPlanDetail.供应商编号 =Convert.ToDecimal(dr["供应商编号"].ToString());
E_ProductionPlanDetail.类别编号 = Convert.ToDecimal(dr["类别编号"].ToString());
E_ProductionPlanDetail.单位数量 = dr["单位数量"].ToString();
E_ProductionPlanDetail.产品单价 =Convert.ToDecimal(dr["产品单价"].ToString());
E_ProductionPlanDetail.库存量 = Convert.ToDecimal(dr["库存量"].ToString());
E_ProductionPlanDetail.已订购量 = Convert.ToDecimal(dr["已订购量"].ToString());
E_ProductionPlanDetail.安全存量 = Convert.ToDecimal(dr["安全存量"].ToString());
E_ProductionPlanDetail.IsSale = dr["IsSale"].ToString();
E_ProductionPlanDetail.Remark = dr["Remark"].ToString();
E_ProductionPlanDetail.Id_Department = Convert.ToDecimal(dr["Id_Department"]);
decimal mainID = dal_ProductionPlanDetail.Add(E_ProductionPlanDetail);//添加记录
if (mainID > 0)
{
ListId.Add(mainID);
}
else
{
return false;
}
}
return true;
}
else
{
return false;
}
}
}
}
(3)IDAL
using System;
using System.Data;
namespace IDAL
{
/// <summary>
/// 接口层TB_ProductionPlanDetail
/// </summary>
public interface ITB_ProductionPlanDetail
{
#region 成员方法
/// <summary>
/// 是否存在该记录
/// </summary>
bool Exists(decimal 产品编号);
/// <summary>
/// 增加一条数据
/// </summary>
decimal Add(Entity.TB_ProductionPlanDetail model);
/// <summary>
/// 更新一条数据
/// </summary>
bool Update(Entity.TB_ProductionPlanDetail model);
/// <summary>
/// 删除一条数据
/// </summary>
bool Delete(decimal 产品编号);
bool DeleteList(string 产品编号list );
/// <summary>
/// 得到一个对象实体
/// </summary>
Entity.TB_ProductionPlanDetail GetModel(decimal 产品编号);
/// <summary>
/// 获得数据列表
/// </summary>
DataSet GetList(string strWhere);
/// <summary>
/// 获得前几行数据
/// </summary>
DataSet GetList(int Top,string strWhere,string filedOrder);
int GetRecordCount(string strWhere);
DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex);
/// <summary>
/// 根据分页获得数据列表
/// </summary>
//DataSet GetList(int PageSize,int PageIndex,string strWhere);
#endregion 成员方法
}
}
(4)SQLServer
using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using IDAL;
using DBCommonOper;//Please add references
namespace SQLServerDAL
{
/// <summary>
/// 数据访问类:TB_ProductionPlanDetail
/// </summary>
public partial class TB_ProductionPlanDetail:ITB_ProductionPlanDetail
{
public TB_ProductionPlanDetail()
{}
#region Method
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(decimal 产品编号)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select count(1) from TB_ProductionPlanDetail");
strSql.Append(" where 产品编号=@产品编号");
SqlParameter[] parameters = {
new SqlParameter("@产品编号", SqlDbType.Decimal)
};
parameters[0].Value = 产品编号;
return DBCommonOper.DBHelp.Exists(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Entity.TB_ProductionPlanDetail model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TB_ProductionPlanDetail(");
strSql.Append("产品名称,供应商编号,类别编号,单位数量,产品单价,库存量,已订购量,安全存量,IsSale,Remark,Id_Main,Id_Department)");
strSql.Append(" values (");
strSql.Append("@产品名称,@供应商编号,@类别编号,@单位数量,@产品单价,@库存量,@已订购量,@安全存量,@IsSale,@Remark,@Id_Main,@Id_Department)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@产品名称", SqlDbType.NVarChar,40),
new SqlParameter("@供应商编号", SqlDbType.Decimal,9),
new SqlParameter("@类别编号", SqlDbType.Decimal,9),
new SqlParameter("@单位数量", SqlDbType.NVarChar,20),
new SqlParameter("@产品单价", SqlDbType.Money,8),
new SqlParameter("@库存量", SqlDbType.Decimal,9),
new SqlParameter("@已订购量", SqlDbType.Decimal,9),
new SqlParameter("@安全存量", SqlDbType.Decimal,9),
new SqlParameter("@IsSale", SqlDbType.NVarChar,10),
new SqlParameter("@Remark", SqlDbType.NVarChar,100),
new SqlParameter("@Id_Main", SqlDbType.Decimal,9),
new SqlParameter("@Id_Department", SqlDbType.Decimal,9)};
parameters[0].Value = model.产品名称;
parameters[1].Value = model.供应商编号;
parameters[2].Value = model.类别编号;
parameters[3].Value = model.单位数量;
parameters[4].Value = model.产品单价;
parameters[5].Value = model.库存量;
parameters[6].Value = model.已订购量;
parameters[7].Value = model.安全存量;
parameters[8].Value = model.IsSale;
parameters[9].Value = model.Remark;
parameters[10].Value = model.Id_Main;
parameters[11].Value = model.Id_Department;
object obj = DBCommonOper.DBHelp.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToDecimal(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.TB_ProductionPlanDetail model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update TB_ProductionPlanDetail set ");
strSql.Append("产品名称=@产品名称,");
strSql.Append("供应商编号=@供应商编号,");
strSql.Append("类别编号=@类别编号,");
strSql.Append("单位数量=@单位数量,");
strSql.Append("产品单价=@产品单价,");
strSql.Append("库存量=@库存量,");
strSql.Append("已订购量=@已订购量,");
strSql.Append("安全存量=@安全存量,");
strSql.Append("IsSale=@IsSale,");
strSql.Append("Remark=@Remark,");
strSql.Append("Id_Main=@Id_Main,");
strSql.Append("Id_Department=@Id_Department");
strSql.Append(" where 产品编号=@产品编号");
SqlParameter[] parameters = {
new SqlParameter("@产品名称", SqlDbType.NVarChar,40),
new SqlParameter("@供应商编号", SqlDbType.Decimal,9),
new SqlParameter("@类别编号", SqlDbType.Decimal,9),
new SqlParameter("@单位数量", SqlDbType.NVarChar,20),
new SqlParameter("@产品单价", SqlDbType.Money,8),
new SqlParameter("@库存量", SqlDbType.Decimal,9),
new SqlParameter("@已订购量", SqlDbType.Decimal,9),
new SqlParameter("@安全存量", SqlDbType.Decimal,9),
new SqlParameter("@IsSale", SqlDbType.NVarChar,10),
new SqlParameter("@Remark", SqlDbType.NVarChar,100),
new SqlParameter("@Id_Main", SqlDbType.Decimal,9),
new SqlParameter("@Id_Department", SqlDbType.Decimal,9),
new SqlParameter("@产品编号", SqlDbType.Decimal,9)};
parameters[0].Value = model.产品名称;
parameters[1].Value = model.供应商编号;
parameters[2].Value = model.类别编号;
parameters[3].Value = model.单位数量;
parameters[4].Value = model.产品单价;
parameters[5].Value = model.库存量;
parameters[6].Value = model.已订购量;
parameters[7].Value = model.安全存量;
parameters[8].Value = model.IsSale;
parameters[9].Value = model.Remark;
parameters[10].Value = model.Id_Main;
parameters[11].Value = model.Id_Department;
parameters[12].Value = model.产品编号;
int rows = DBCommonOper.DBHelp.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(decimal 产品编号)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("delete from TB_ProductionPlanDetail ");
strSql.Append(" where 产品编号=@产品编号");
SqlParameter[] parameters = {
new SqlParameter("@产品编号", SqlDbType.Decimal)
};
parameters[0].Value = 产品编号;
int rows = DBCommonOper.DBHelp.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 批量删除数据
/// </summary>
public bool DeleteList(string 产品编号list )
{
StringBuilder strSql=new StringBuilder();
strSql.Append("delete from TB_ProductionPlanDetail ");
strSql.Append(" where 产品编号 in ("+产品编号list + ") ");
int rows = DBCommonOper.DBHelp.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.TB_ProductionPlanDetail GetModel(decimal 产品编号)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 产品编号,产品名称,供应商编号,类别编号,单位数量,产品单价,库存量,已订购量,安全存量,IsSale,Remark,Id_Main,Id_Department from TB_ProductionPlanDetail ");
strSql.Append(" where 产品编号=@产品编号");
SqlParameter[] parameters = {
new SqlParameter("@产品编号", SqlDbType.Decimal)
};
parameters[0].Value = 产品编号;
Entity.TB_ProductionPlanDetail model = new Entity.TB_ProductionPlanDetail();
DataSet ds = DBCommonOper.DBHelp.Query(strSql.ToString(), parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["产品编号"]!=null && ds.Tables[0].Rows[0]["产品编号"].ToString()!="")
{
model.产品编号=decimal.Parse(ds.Tables[0].Rows[0]["产品编号"].ToString());
}
if(ds.Tables[0].Rows[0]["产品名称"]!=null && ds.Tables[0].Rows[0]["产品名称"].ToString()!="")
{
model.产品名称=ds.Tables[0].Rows[0]["产品名称"].ToString();
}
if(ds.Tables[0].Rows[0]["供应商编号"]!=null && ds.Tables[0].Rows[0]["供应商编号"].ToString()!="")
{
model.供应商编号=decimal.Parse(ds.Tables[0].Rows[0]["供应商编号"].ToString());
}
if(ds.Tables[0].Rows[0]["类别编号"]!=null && ds.Tables[0].Rows[0]["类别编号"].ToString()!="")
{
model.类别编号=decimal.Parse(ds.Tables[0].Rows[0]["类别编号"].ToString());
}
if(ds.Tables[0].Rows[0]["单位数量"]!=null && ds.Tables[0].Rows[0]["单位数量"].ToString()!="")
{
model.单位数量=ds.Tables[0].Rows[0]["单位数量"].ToString();
}
if(ds.Tables[0].Rows[0]["产品单价"]!=null && ds.Tables[0].Rows[0]["产品单价"].ToString()!="")
{
model.产品单价=decimal.Parse(ds.Tables[0].Rows[0]["产品单价"].ToString());
}
if(ds.Tables[0].Rows[0]["库存量"]!=null && ds.Tables[0].Rows[0]["库存量"].ToString()!="")
{
model.库存量=decimal.Parse(ds.Tables[0].Rows[0]["库存量"].ToString());
}
if(ds.Tables[0].Rows[0]["已订购量"]!=null && ds.Tables[0].Rows[0]["已订购量"].ToString()!="")
{
model.已订购量=decimal.Parse(ds.Tables[0].Rows[0]["已订购量"].ToString());
}
if(ds.Tables[0].Rows[0]["安全存量"]!=null && ds.Tables[0].Rows[0]["安全存量"].ToString()!="")
{
model.安全存量=decimal.Parse(ds.Tables[0].Rows[0]["安全存量"].ToString());
}
if(ds.Tables[0].Rows[0]["IsSale"]!=null && ds.Tables[0].Rows[0]["IsSale"].ToString()!="")
{
model.IsSale = ds.Tables[0].Rows[0]["IsSale"].ToString();
}
if(ds.Tables[0].Rows[0]["Remark"]!=null && ds.Tables[0].Rows[0]["Remark"].ToString()!="")
{
model.Remark=ds.Tables[0].Rows[0]["Remark"].ToString();
}
if (ds.Tables[0].Rows[0]["Id_Main"] != null && ds.Tables[0].Rows[0]["Id_Main"].ToString() != "")
{
model.Id_Main =decimal.Parse(ds.Tables[0].Rows[0]["Id_Main"].ToString());
}
if (ds.Tables[0].Rows[0]["Id_Department"] != null && ds.Tables[0].Rows[0]["Id_Department"].ToString() != "")
{
model.Id_Department = decimal.Parse(ds.Tables[0].Rows[0]["Id_Department"].ToString());
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select 产品编号,产品名称,供应商编号,类别编号,单位数量,产品单价,库存量,已订购量,安全存量,IsSale,Remark,Id_Main,Id_Department ");
strSql.Append(" FROM TB_ProductionPlanDetail ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
return DBCommonOper.DBHelp.Query(strSql.ToString());
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top,string strWhere,string filedOrder)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select ");
if(Top>0)
{
strSql.Append(" top "+Top.ToString());
}
strSql.Append(" 产品编号,产品名称,供应商编号,类别编号,单位数量,产品单价,库存量,已订购量,安全存量,IsSale,Remark,Id_Main,Id_Department ");
strSql.Append(" FROM TB_ProductionPlanDetail ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
strSql.Append(" order by " + filedOrder);
return DBCommonOper.DBHelp.Query(strSql.ToString());
}
/// <summary>
/// 获取记录总数
/// </summary>
public int GetRecordCount(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select count(1) FROM TB_ProductionPlanDetail ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
object obj = DBCommonOper.DBHelp.GetSingle(strSql.ToString());
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("SELECT * FROM ( ");
strSql.Append(" SELECT ROW_NUMBER() OVER (");
if (!string.IsNullOrEmpty(orderby.Trim()))
{
strSql.Append("order by T." + orderby );
}
else
{
strSql.Append("order by T.产品编号 desc");
}
strSql.Append(")AS Row, T.* from TB_ProductionPlanDetail T ");
if (!string.IsNullOrEmpty(strWhere.Trim()))
{
strSql.Append(" WHERE " + strWhere);
}
strSql.Append(" ) TT");
strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
return DBCommonOper.DBHelp.Query(strSql.ToString());
}
/*
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetList(int PageSize,int PageIndex,string strWhere)
{
SqlParameter[] parameters = {
new SqlParameter("@tblName", SqlDbType.VarChar, 255),
new SqlParameter("@fldName", SqlDbType.VarChar, 255),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@IsReCount", SqlDbType.Bit),
new SqlParameter("@OrderType", SqlDbType.Bit),
new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
};
parameters[0].Value = "TB_ProductionPlanDetail";
parameters[1].Value = "产品编号";
parameters[2].Value = PageSize;
parameters[3].Value = PageIndex;
parameters[4].Value = 0;
parameters[5].Value = 0;
parameters[6].Value = strWhere;
return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
}*/
#endregion Method
}
}
(5)model
using System;
namespace Entity
{
/// <summary>
/// TB_ProductionPlanDetail:实体类(属性说明自动提取数据库字段的描述信息)
/// </summary>
[Serializable]
public partial class TB_ProductionPlanDetail
{
public TB_ProductionPlanDetail()
{}
#region Model
private decimal _产品编号;
private string _产品名称;
private decimal? _供应商编号;
private decimal? _类别编号;
private string _单位数量;
private decimal? _产品单价;
private decimal? _库存量;
private decimal? _已订购量;
private decimal? _安全存量;
private string _issale;
private string _remark;
private decimal? _id_main;
private decimal? _id_department;
/// <summary>
///
/// </summary>
public decimal 产品编号
{
set{ _产品编号=value;}
get{return _产品编号;}
}
/// <summary>
///
/// </summary>
public string 产品名称
{
set{ _产品名称=value;}
get{return _产品名称;}
}
/// <summary>
///
/// </summary>
public decimal? 供应商编号
{
set{ _供应商编号=value;}
get{return _供应商编号;}
}
/// <summary>
///
/// </summary>
public decimal? 类别编号
{
set{ _类别编号=value;}
get{return _类别编号;}
}
/// <summary>
///
/// </summary>
public string 单位数量
{
set{ _单位数量=value;}
get{return _单位数量;}
}
/// <summary>
///
/// </summary>
public decimal? 产品单价
{
set{ _产品单价=value;}
get{return _产品单价;}
}
/// <summary>
///
/// </summary>
public decimal? 库存量
{
set{ _库存量=value;}
get{return _库存量;}
}
/// <summary>
///
/// </summary>
public decimal? 已订购量
{
set{ _已订购量=value;}
get{return _已订购量;}
}
/// <summary>
///
/// </summary>
public decimal? 安全存量
{
set{ _安全存量=value;}
get{return _安全存量;}
}
/// <summary>
///
/// </summary>
public string IsSale
{
set{ _issale=value;}
get{return _issale;}
}
/// <summary>
///
/// </summary>
public string Remark
{
set{ _remark=value;}
get{return _remark;}
}
/// <summary>
///
/// </summary>
public decimal? Id_Main
{
set { _id_main = value; }
get { return _id_main; }
}
/// <summary>
///
/// </summary>
public decimal? Id_Department
{
set { _id_department = value; }
get { return _id_department; }
}
#endregion Model
}
}