Beispiel #1
0
        public bool GetTempMaterialListByPage(ref List <TempMaterialInfo> modelList, TempMaterialInfo model, ref DividPage page, UserInfo user, ref string strError)
        {
            if (page == null)
            {
                page = new DividPage();
            }
            List <TempMaterialInfo> lstModel = new List <TempMaterialInfo>();

            try
            {
                using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_TempMaterial", GetFilterSql(model, user), "*", "Order By CreateTime Desc,TempMaterialNo,MaterialNo,ID Desc"))
                {
                    while (dr.Read())
                    {
                        lstModel.Add(GetModelFromDataReader(dr));
                    }
                }

                modelList = lstModel;
                return(true);
            }
            catch (Exception ex)
            {
                strError = ex.Message;
                return(false);
            }
            finally
            {
            }
        }
Beispiel #2
0
        private TempMaterialInfo GetModelFromDataReader(SqlDataReader dr)
        {
            TempMaterialInfo model = new TempMaterialInfo();

            model.ID                 = dr["ID"].ToInt32();
            model.TempMaterialNo     = dr["TempMaterialNo"].ToDBString();
            model.TempMaterialDesc   = dr["TempMaterialDesc"].ToDBString();
            model.MaterialNo         = dr["MaterialNo"].ToDBString();
            model.MaterialDesc       = dr["MaterialDesc"].ToDBString();
            model.SapMaterialDoc     = dr["SapMaterialDoc"].ToDBString();
            model.ReplaceUser        = dr["ReplaceUser"].ToDBString();
            model.ReplaceTime        = dr["ReplaceTime"].ToDateTimeNull();
            model.TempMaterialStatus = dr["TempMaterialStatus"].ToInt32();
            model.IsDel              = dr["ISDEL"].ToInt32();
            model.Creater            = dr["CREATER"].ToDBString();
            model.CreateTime         = dr["CREATETIME"].ToDateTime();
            model.Modifyer           = dr["MODIFYER"].ToDBString();
            model.ModifyTime         = dr["MODIFYTIME"].ToDateTimeNull();

            if (Common_Func.readerExists(dr, "StrTempMaterialStatus"))
            {
                model.StrTempMaterialStatus = dr["StrTempMaterialStatus"].ToDBString();
            }

            model.Unit   = string.Empty;
            model.IsRohs = 2;

            return(model);
        }
Beispiel #3
0
 public bool GetTempMaterialByID(ref TempMaterialInfo model, UserInfo user, ref string strError)
 {
     try
     {
         using (SqlDataReader dr = _db.GetTempMaterialByID(model))
         {
             if (dr.Read())
             {
                 model = (GetModelFromDataReader(dr));
                 return(true);
             }
             else
             {
                 strError = "找不到任何数据";
                 return(false);
             }
         }
     }
     catch (Exception ex)
     {
         strError = ex.Message;
         return(false);
     }
     finally
     {
     }
 }
Beispiel #4
0
        public bool SaveTempMaterial(ref TempMaterialInfo model, UserInfo user, ref string strError)
        {
            try
            {
                if (model.ID <= 0)
                {
                    model.Creater = user.UserNo;
                }
                else
                {
                    model.Modifyer = user.UserNo;
                }

                bool bResult = _db.SaveTempMaterial(ref model);
                if (bResult)
                {
                    if (!GetTempMaterialByID(ref model, user, ref strError))
                    {
                        strError = string.Format("{0}{1}{2}", "保存成功,获取保存数据失败", Environment.NewLine, strError);
                    }
                }

                return(bResult);
            }
            catch (Exception ex)
            {
                strError = ex.Message;
                return(false);
            }
        }
Beispiel #5
0
        private SqlParameter[] GetParameterFromModel(TempMaterialInfo model)
        {
            int i;

            SqlParameter[] param = new SqlParameter[] {
                new SqlParameter("@ErrorMsg", SqlDbType.NVarChar, 1000),

                new SqlParameter("@v_ID", model.ID.ToSqlValue()),
                new SqlParameter("@v_TempMaterialNo", model.TempMaterialNo.ToSqlValue()),
                new SqlParameter("@v_TempMaterialDesc", model.TempMaterialDesc.ToSqlValue()),
                new SqlParameter("@v_MaterialNo", model.MaterialNo.ToSqlValue()),
                new SqlParameter("@v_MaterialDesc", model.MaterialDesc.ToSqlValue()),
                new SqlParameter("@v_SapMaterialDoc", model.SapMaterialDoc.ToSqlValue()),
                new SqlParameter("@v_ReplaceUser", model.ReplaceUser.ToSqlValue()),
                new SqlParameter("@v_ReplaceTime", model.ReplaceTime.ToSqlValue()),
                new SqlParameter("@v_TempMaterialStatus", model.TempMaterialStatus.ToSqlValue()),
                new SqlParameter("@v_IsDel", model.IsDel.ToSqlValue()),
                new SqlParameter("@v_Creater", model.Creater.ToSqlValue()),
                new SqlParameter("@v_CreateTime", model.CreateTime.ToSqlValue()),
                new SqlParameter("@v_Modifyer", model.Modifyer.ToSqlValue()),
                new SqlParameter("@v_ModifyTime", model.ModifyTime.ToSqlValue()),
            };

            i = 0;
            param[i++].Direction = ParameterDirection.Output;
            param[i++].Direction = ParameterDirection.InputOutput;
            param[i++].Direction = ParameterDirection.InputOutput;
            param[i++].Direction = ParameterDirection.Input;
            param[i++].Direction = ParameterDirection.Input;
            param[i++].Direction = ParameterDirection.Input;
            param[i++].Direction = ParameterDirection.Input;
            param[i++].Direction = ParameterDirection.Input;
            param[i++].Direction = ParameterDirection.Input;
            param[i++].Direction = ParameterDirection.Input;
            param[i++].Direction = ParameterDirection.Input;
            param[i++].Direction = ParameterDirection.Input;
            param[i++].Direction = ParameterDirection.InputOutput;
            param[i++].Direction = ParameterDirection.Input;
            param[i++].Direction = ParameterDirection.InputOutput;

            i = 0;
            param[i++].Size = 1000;
            param[i++].Size = 18;
            param[i++].Size = 20;
            param[i++].Size = 50;
            param[i++].Size = 20;
            param[i++].Size = 50;
            param[i++].Size = 50;
            param[i++].Size = 20;
            param[i++].Size = 30;
            param[i++].Size = 18;
            param[i++].Size = 18;
            param[i++].Size = 50;
            param[i++].Size = 30;
            param[i++].Size = 50;
            param[i++].Size = 30;

            return(param);
        }
Beispiel #6
0
        public SqlDataReader GetTempMaterialByNo(TempMaterialInfo model)
        {
            string strSql = string.Empty;

            strSql = string.Format("SELECT * FROM V_TempMaterial WHERE TempMaterialNo = '{0}'", string.IsNullOrEmpty(model.MaterialNo) ? model.TempMaterialNo : model.MaterialNo);

            return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
        }
Beispiel #7
0
        public SqlDataReader GetTempMaterialByID(TempMaterialInfo model)
        {
            string strSql = string.Empty;

            strSql = string.Format("SELECT * FROM V_TempMaterial WHERE ID = {0}", model.ID);

            return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
        }
Beispiel #8
0
        private TempMaterialInfo TransferTaskDetailToTempMaterial(TaskDetails_Model TM)
        {
            TempMaterialInfo model = new TempMaterialInfo();

            model.MaterialNo   = TM.MaterialNo;
            model.MaterialDesc = TM.MaterialDesc;
            model.Unit         = TM.Unit;
            model.IsRohs       = TM.IsROHS;

            return(model);
        }
Beispiel #9
0
 public bool DeleteTempMaterialByID(TempMaterialInfo model, UserInfo user, ref string strError)
 {
     try
     {
         return(_db.DeleteTempMaterialByID(model));
     }
     catch (Exception ex)
     {
         strError = ex.Message;
         return(false);
     }
 }
Beispiel #10
0
 public bool ExistsTempMaterialNo(TempMaterialInfo model, bool bIncludeDel, UserInfo user, ref string strError)
 {
     try
     {
         return(_db.ExistsTempMaterialNo(model, bIncludeDel));
     }
     catch (Exception ex)
     {
         strError = ex.Message;
         return(false);
     }
 }
Beispiel #11
0
        private string GetFilterSql(TempMaterialInfo model, UserInfo user)
        {
            try
            {
                string strSql   = " Where ISNULL(IsDel,1) = 1 ";
                bool   hadWhere = true;


                if (!string.IsNullOrEmpty(model.TempMaterialNo))
                {
                    strSql   = Common_Func.AddWhereAnd(strSql, hadWhere);
                    strSql  += " (TempMaterialNo Like '%" + model.TempMaterialNo + "%' or TempMaterialDesc Like '%" + model.TempMaterialNo + "%') ";
                    hadWhere = true;
                }

                if (!string.IsNullOrEmpty(model.MaterialNo))
                {
                    strSql   = Common_Func.AddWhereAnd(strSql, hadWhere);
                    strSql  += " (MaterialNo Like '%" + model.MaterialNo + "%' or MaterialDesc Like '%" + model.MaterialNo + "%') ";
                    hadWhere = true;
                }

                if (!string.IsNullOrEmpty(model.Creater))
                {
                    strSql   = Common_Func.AddWhereAnd(strSql, hadWhere);
                    strSql  += " Creater Like '%" + model.Creater + "%' ";
                    hadWhere = true;
                }

                if (model.StartTime != null)
                {
                    strSql   = Common_Func.AddWhereAnd(strSql, hadWhere);
                    strSql  += " CreateTime >= " + model.StartTime.ToDateTime().Date.ToSqlTimeString() + " ";
                    hadWhere = true;
                }

                if (model.EndTime != null)
                {
                    strSql   = Common_Func.AddWhereAnd(strSql, hadWhere);
                    strSql  += " CreateTime <= " + model.EndTime.ToDateTime().AddDays(1).Date.ToSqlTimeString() + " ";
                    hadWhere = true;
                }


                return(strSql);
            }
            catch
            {
                return(string.Empty);
            }
        }
Beispiel #12
0
        public string GetTempMaterialNo(TempMaterialInfo model)
        {
            string strSql = string.Empty;

            if (model.ID <= 0)
            {
                strSql = "SELECT 'L' || TO_CHAR(SYSDATE,'YYYYMM') || CONCAT(SUBSTR('00000',1,5-LENGTH(SEQ_TEMPMATERIALNO.NEXTVAL)),SEQ_TEMPMATERIALNO.NEXTVAL) FROM DUAL";
            }
            else
            {
                strSql = string.Format("SELECT TempMaterialNo FROM T_TEMPMATERIAL WHERE ID = {0}", model.ID);
            }

            object o;

            o = OperationSql.ExecuteScalar(CommandType.Text, strSql, null);
            return(o.ToDBString());
        }
Beispiel #13
0
 public bool GetTempMaterialNo(ref TempMaterialInfo model, UserInfo user, ref string strError)
 {
     try
     {
         string menuNo = _db.GetTempMaterialNo(model);
         if (string.IsNullOrEmpty(menuNo))
         {
             return(false);
         }
         model.TempMaterialNo = menuNo;
         return(true);
     }
     catch (Exception ex)
     {
         strError = ex.Message;
         return(false);
     }
 }
Beispiel #14
0
        public bool SaveTempMaterial(ref TempMaterialInfo model)
        {
            SqlParameter[] param = GetParameterFromModel(model);

            OperationSql.ExecuteNonQuery2(CommandType.StoredProcedure, "Proc_SaveTempMaterial", param);

            string ErrorMsg = param[0].Value.ToDBString();

            if (ErrorMsg.StartsWith("执行错误"))
            {
                throw new Exception(ErrorMsg);
            }
            else
            {
                model.ID         = param[1].Value.ToInt32();
                model.CreateTime = param[param.Length - 3].Value.ToDateTime();
                model.ModifyTime = param[param.Length - 1].Value.ToDateTimeNull();
                return(true);
            }
        }
Beispiel #15
0
        public bool DeleteTempMaterialByID(TempMaterialInfo model)
        {
            SqlParameter[] param = new SqlParameter[] {
                new SqlParameter("@ErrorMsg", SqlDbType.NVarChar, 1000),

                new SqlParameter("@v_ID", model.ID.ToSqlValue()),
            };
            param[0].Direction = ParameterDirection.Output;

            OperationSql.ExecuteNonQuery2(CommandType.StoredProcedure, "Proc_DeleteTempMaterialByID", param);

            string ErrorMsg = param[0].Value.ToDBString();

            if (ErrorMsg.StartsWith("执行错误"))
            {
                throw new Exception(ErrorMsg);
            }
            else
            {
                return(true);
            }
        }
Beispiel #16
0
        public bool ExistsTempMaterialNo(TempMaterialInfo model, bool bIncludeDel)
        {
            SqlParameter[] param = new SqlParameter[] {
                new SqlParameter("@ErrorMsg", SqlDbType.NVarChar, 1000),

                new SqlParameter("@v_TempMaterialNo", model.TempMaterialNo.ToSqlValue()),
                new SqlParameter("@IncludeDel", bIncludeDel.ToSqlValue()),
            };
            param[0].Direction = ParameterDirection.Output;

            OperationSql.ExecuteNonQuery2(CommandType.StoredProcedure, "Proc_ExistsTempMaterialNo", param);

            string ErrorMsg = param[0].Value.ToDBString();

            if (ErrorMsg.StartsWith("执行错误"))
            {
                throw new Exception(ErrorMsg);
            }
            else
            {
                return(string.IsNullOrEmpty(ErrorMsg));
            }
        }
Beispiel #17
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="model"></param>
        /// <param name="type">获取类型 1-仅SAP; 2-仅临时物料; 3-先临时再SAP</param>
        /// <param name="user"></param>
        /// <param name="strError"></param>
        /// <returns></returns>
        public bool GetMaterialInfo(ref TempMaterialInfo model, int type, UserInfo user, ref string strError)
        {
            Task_Func         TF = new Task_Func();
            TaskDetails_Model TM = new TaskDetails_Model();

            SqlDataReader    dr   = null;
            TempMaterialInfo temp = new TempMaterialInfo();

            try
            {
                switch (type)
                {
                case 1:
                    //if (TF.GetMaterialInfoForSAP(model.MaterialNo, ref TM, ref strError))
                    //{
                    //    temp = TransferTaskDetailToTempMaterial(TM);
                    //}
                    //else
                {
                    return(false);
                }
                break;

                case 2:
                    dr = _db.GetTempMaterialByNo(model);
                    if (dr != null && dr.Read())
                    {
                        temp              = GetModelFromDataReader(dr);
                        temp.MaterialNo   = temp.TempMaterialNo;
                        temp.MaterialDesc = temp.TempMaterialDesc;
                    }
                    else
                    {
                        strError = "没有获取到临时物料信息!";
                        return(false);
                    }
                    break;

                case 3:
                    dr = _db.GetTempMaterialByNo(model);
                    if (dr != null && dr.Read())
                    {
                        temp              = GetModelFromDataReader(dr);
                        temp.MaterialNo   = temp.TempMaterialNo;
                        temp.MaterialDesc = temp.TempMaterialDesc;
                    }
                    else
                    {
                        //if (TF.GetMaterialInfoForSAP(model.MaterialNo, ref TM, ref strError))
                        //{
                        //    temp = TransferTaskDetailToTempMaterial(TM);
                        //}
                        //else
                        {
                            strError = "没有获取到物料信息!";
                            return(false);
                        }
                    }
                    break;

                default:
                    strError = "传入类型错误";
                    return(false);
                }

                model = temp;
                return(true);
            }
            catch (Exception ex)
            {
                strError = ex.Message;
                return(false);
            }
            finally
            {
                if (dr != null && !dr.IsClosed)
                {
                    dr.Close();
                }
            }
        }