예제 #1
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List <Common.Model.MouldingBom_Model> DataTableToList(DataTable dt)
        {
            List <Common.Model.MouldingBom_Model> modelList = new List <Common.Model.MouldingBom_Model>();
            int rowsCount = dt.Rows.Count;

            if (rowsCount > 0)
            {
                Common.Model.MouldingBom_Model model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model            = new Common.Model.MouldingBom_Model();
                    model.partNumber = dt.Rows[n]["partNumber"].ToString();
                    model.matPart01  = dt.Rows[n]["matPart01"].ToString();
                    model.matPart02  = dt.Rows[n]["matPart02"].ToString();
                    model.customer   = dt.Rows[n]["customer"].ToString();
                    model.model      = dt.Rows[n]["model"].ToString();
                    model.jigNo      = dt.Rows[n]["jigNo"].ToString();
                    if (dt.Rows[n]["cavityCount"].ToString() != "")
                    {
                        model.cavityCount = decimal.Parse(dt.Rows[n]["cavityCount"].ToString());
                    }
                    if (dt.Rows[n]["partsWeight"].ToString() != "")
                    {
                        model.partsWeight = decimal.Parse(dt.Rows[n]["partsWeight"].ToString());
                    }
                    if (dt.Rows[n]["cycleTime"].ToString() != "")
                    {
                        model.cycleTime = decimal.Parse(dt.Rows[n]["cycleTime"].ToString());
                    }
                    if (dt.Rows[n]["blockCount"].ToString() != "")
                    {
                        model.blockCount = decimal.Parse(dt.Rows[n]["blockCount"].ToString());
                    }
                    if (dt.Rows[n]["unitCount"].ToString() != "")
                    {
                        model.unitCount = decimal.Parse(dt.Rows[n]["unitCount"].ToString());
                    }
                    model.machineID = dt.Rows[n]["machineID"].ToString();
                    model.userName  = dt.Rows[n]["userName"].ToString();
                    if (dt.Rows[n]["dateTime"].ToString() != "")
                    {
                        model.dateTime = DateTime.Parse(dt.Rows[n]["dateTime"].ToString());
                    }
                    model.remarks = dt.Rows[n]["remarks"].ToString();

                    model.partnumberall = dt.Rows[n]["partNumberAll"].ToString();
                    modelList.Add(model);
                }
            }
            return(modelList);
        }
예제 #2
0
        /// <summary>
        /// 分页获取数据列表
        /// </summary>
        //public DataSet GetList(int PageSize,int PageIndex,string strWhere)
        //{
        //return dal.GetList(PageSize,PageIndex,strWhere);
        //}

        /// <summary>
        /// 获得前几行数据
        /// </summary>
        public Common.Model.MouldingBom_Model CopyObj(Common.Model.MouldingBom_Model objModel)
        {
            Common.Model.MouldingBom_Model model;
            model               = new Common.Model.MouldingBom_Model();
            model.partNumber    = objModel.partNumber;
            model.matPart01     = objModel.matPart01;
            model.matPart02     = objModel.matPart02;
            model.customer      = objModel.customer;
            model.model         = objModel.model;
            model.jigNo         = objModel.jigNo;
            model.cavityCount   = objModel.cavityCount;
            model.partsWeight   = objModel.partsWeight;
            model.cycleTime     = objModel.cycleTime;
            model.blockCount    = objModel.blockCount;
            model.unitCount     = objModel.unitCount;
            model.machineID     = objModel.machineID;
            model.userName      = objModel.userName;
            model.dateTime      = objModel.dateTime;
            model.remarks       = objModel.remarks;
            model.partnumberall = objModel.partnumberall;
            return(model);
        }
예제 #3
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public SqlCommand UpdateCommand(Common.Model.MouldingBom_Model model)
 {
     return(dal.UpdateCommand(model));
 }
예제 #4
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(Common.Model.MouldingBom_Model model)
 {
     return(dal.Update(model));
 }
예제 #5
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public SqlCommand AddCommand(Common.Model.MouldingBom_Model model)
 {
     return(dal.AddCommand(model));
 }
예제 #6
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public void Add(Common.Model.MouldingBom_Model model)
 {
     dal.Add(model);
 }