如何将TextBox数据提交到GridView显示再保存到数据库

(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

 }
}