示例#1
0
        public bool GetCheckTransListByPage(ref List<CheckTransInfo> modelList, CheckTransInfo model, ref DividPage page, UserInfo user, ref string strError)
        {
            List<CheckTransInfo> lstModel = new List<CheckTransInfo>();
            try
            {
                using (SqlDataReader dr = Common_DB.QueryByDividPage(ref page, "V_CheckTrans", GetFilterSql(model, user), "*", "Order By CheckID Desc,ID Desc"))
                {
                    while (dr.Read())
                    {
                        lstModel.Add(GetModelFromDataReader(dr));
                    }
                }

                modelList = lstModel;
                return true;
            }
            catch (Exception ex)
            {
                strError = ex.Message;
                return false;
            }
            finally
            {
            }
        }
示例#2
0
 public bool GetCheckTransByID(ref CheckTransInfo model, UserInfo user, ref string strError)
 {
     try
     {
         using (SqlDataReader dr = _db.GetCheckTransByID(model))
         {
             if (dr.Read())
             {
                 model = (GetModelFromDataReader(dr));
                 return true;
             }
             else
             {
                 strError = "找不到任何数据";
                 return false;
             }
         }
     }
     catch (Exception ex)
     {
         strError = ex.Message;
         return false;
     }
     finally
     {
     }
 }
示例#3
0
        internal SqlDataReader GetCheckTransByID(CheckTransInfo model)
        {
            string strSql = string.Empty;

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

            return(OperationSql.ExecuteReader(CommandType.Text, strSql, null));
        }
示例#4
0
 public bool SaveCheckTransList(ref CheckTransInfo modelList, UserInfo user, ref string strError)
 {
     try
     {
         return _db.SaveCheckTransList(ref modelList);
     }
     catch (Exception ex)
     {
         strError = ex.Message;
         return false;
     }
 }
示例#5
0
 public bool SaveCheckTrans(ref CheckTransInfo model, UserInfo user, ref string strError)
 {
     try
     {
         if (model.ID <= 0)
         {
             model.Creater = user.UserNo;
         }
         else
         {
             model.Modifyer = user.UserNo;
         }
         return _db.SaveCheckTrans(ref model);
     }
     catch (Exception ex)
     {
         strError = ex.Message;
         return false;
     }
 }
示例#6
0
        internal bool SaveCheckTransList(ref CheckTransInfo model)
        {
            model.OperationTime = DateTime.Now;
            SqlParameter[] param = GetListParameterFromModel(model);

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

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

            if (ErrorMsg.StartsWith("执行错误"))
            {
                throw new Exception(ErrorMsg);
            }
            else
            {
                model.ID            = param[1].Value.ToInt32();
                model.OperationTime = param[param.Length - 1].Value.ToDateTime();
                return(true);
            }
        }
示例#7
0
        private CheckTransInfo GetModelFromDataReader(SqlDataReader dr)
        {
            CheckTransInfo model = new CheckTransInfo();
            if (Common_Func.readerExists(dr, "ID")) model.ID = dr["ID"].ToInt32();
            if (Common_Func.readerExists(dr, "CheckID")) model.CheckID = dr["CheckID"].ToInt32();
            if (Common_Func.readerExists(dr, "WarehouseNo")) model.WarehouseNo = dr["WarehouseNo"].ToDBString();
            if (Common_Func.readerExists(dr, "HouseNo")) model.HouseNo = dr["HouseNo"].ToDBString();
            if (Common_Func.readerExists(dr, "AreaNo")) model.AreaNo = dr["AreaNo"].ToDBString();
            if (Common_Func.readerExists(dr, "MaterialNo")) model.MaterialNo = dr["MaterialNo"].ToDBString();
            if (Common_Func.readerExists(dr, "MaterialDesc")) model.MaterialDesc = dr["MaterialDesc"].ToDBString();
            if (Common_Func.readerExists(dr, "Barcode")) model.Barcode = dr["Barcode"].ToDBString();
            if (Common_Func.readerExists(dr, "SerialNo")) model.SerialNo = dr["SerialNo"].ToDBString();
            if (Common_Func.readerExists(dr, "BatchNo")) model.BatchNo = dr["BatchNo"].ToDBString();
            if (Common_Func.readerExists(dr, "ScanQty")) model.ScanQty = dr["ScanQty"].ToDecimal();
            if (Common_Func.readerExists(dr, "Operator")) model.Operator = dr["Operator"].ToDBString();
            if (Common_Func.readerExists(dr, "OperationTime")) model.OperationTime = dr["OperationTime"].ToDateTime();

            if (Common_Func.readerExists(dr, "WarehouseName")) model.WarehouseName = dr["WarehouseName"].ToDBString();
            if (Common_Func.readerExists(dr, "HouseName")) model.HouseName = dr["HouseName"].ToDBString();
            if (Common_Func.readerExists(dr, "AreaName")) model.AreaName = dr["AreaName"].ToDBString();

            return model;
        }
示例#8
0
        private string GetFilterSql(CheckTransInfo model, UserInfo user)
        {
            try
            {
                string strSql = "";
                bool hadWhere = false;

                if (model.ID >= 1)
                {
                    strSql = Common_Func.AddWhereAnd(strSql, hadWhere);
                    strSql += " ID = " + model.ID + " ";
                    hadWhere = true;
                }

                if (model.CheckID >= 1)
                {
                    strSql = Common_Func.AddWhereAnd(strSql, hadWhere);
                    strSql += " CheckID = " + model.CheckID + " ";
                    hadWhere = true;
                }

                if (!string.IsNullOrEmpty(model.AreaNo))
                {
                    strSql = Common_Func.AddWhereAnd(strSql, hadWhere);
                    strSql += " (AreaNo LIKE '%" + model.AreaNo + "%' OR AreaName LIKE '%" + model.AreaNo + "%') ";
                    hadWhere = true;
                }

                if (!string.IsNullOrEmpty(model.HouseNo))
                {
                    strSql = Common_Func.AddWhereAnd(strSql, hadWhere);
                    strSql += " (HouseNo LIKE '%" + model.HouseNo + "%' OR HouseName LIKE '%" + model.HouseNo + "%') ";
                    hadWhere = true;
                }

                if (!string.IsNullOrEmpty(model.WarehouseNo))
                {
                    strSql = Common_Func.AddWhereAnd(strSql, hadWhere);
                    strSql += " (WarehouseNo LIKE '%" + model.WarehouseNo + "%' OR WarehouseName LIKE '%" + model.WarehouseNo + "%') ";
                    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.Operator))
                {
                    strSql = Common_Func.AddWhereAnd(strSql, hadWhere);
                    strSql += " Operator Like '%" + model.Operator + "%' ";
                    hadWhere = true;
                }

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

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

                return strSql;
            }
            catch
            {
                return string.Empty;
            }
        }
示例#9
0
        public string SaveCheckTransScanPro(int checkID, string strBarcode, string strAreaNo, string strUserJson, bool isTray)
        {
            CheckTransInfo model = new CheckTransInfo();
            string strError = string.Empty;

            try
            {
                //AreaInfo area = JSONHelper.JsonToObject<AreaInfo>(strAreaNo);

                UserInfo user = JSONHelper.JsonToObject<UserInfo>(strUserJson);
                if (user == null || string.IsNullOrEmpty(user.UserNo))
                {
                    model.Status = "E";
                    model.Message = "用户信息获取失败!";
                    return JSONHelper.ObjectToJson(model);
                }
                Area_Func func = new Area_Func();
                AreaInfo area = new AreaInfo();
                area.AreaNo = strAreaNo;
                string strErrMsg = null;
                if (!func.GetAreaByAreaNo(ref area, user, ref strErrMsg))
                {
                    throw new Exception(strErrMsg);
                }
                if (area == null || string.IsNullOrEmpty(area.AreaNo))
                {
                    model.Status = "E";
                    model.Message = "货位信息获取失败!";
                    return JSONHelper.ObjectToJson(model);
                }

                PrintBarcode.Barcode_Func bfunc = new PrintBarcode.Barcode_Func();
                model.ScanBarcode = bfunc.GetCheckBarcode(checkID, strBarcode, isTray, ref strError);
                if (model.ScanBarcode == null)
                {
                    model.Status = "E";
                    model.Message = "条码信息获取失败!" + strError;
                    return JSONHelper.ObjectToJson(model);
                }
                List<string> lstBarcode = new List<string>();
                if (isTray)
                {
                    foreach (var item in model.ScanBarcode.tray_Model.listDetails)
                    {
                        lstBarcode.AddRange(item.listBarcode);
                    }
                }
                else
                {
                    lstBarcode.Add(model.ScanBarcode.SERIALNO);
                }
                bool res = true;
                List<Barcode_Model> lstScanBar = new List<Barcode_Model>();
                foreach (var item in lstBarcode)
                {
                    Barcode_Model bar = bfunc.GetCheckBarcode(item, ref strError);
                    if (bar != null && !string.IsNullOrEmpty(bar.SERIALNO))
                        lstScanBar.Add(bar);
                }
                foreach (var item in lstScanBar)
                {
                    model = new CheckTransInfo();
                    model.CheckID = checkID;

                    model.AreaNo = area.AreaNo;
                    model.HouseNo = area.HouseNo;
                    model.WarehouseNo = area.WarehouseNo;

                    model.Operator = user.UserNo;
                    model.Barcode = item.BARCODE;
                    model.SerialNo = item.SERIALNO;
                    model.BatchNo = item.BATCHNO;
                    model.SN = item.SN;
                    model.MaterialNo = item.MATERIALNO;
                    model.MaterialDesc = item.MATERIALDESC;
                    model.ScanQty = item.QTY;
                    res = SaveCheckTrans(ref model, user, ref strError);
                    if (!res)
                        break;
                }

                if (res)
                {
                    model.Status = "S";
                    return JSONHelper.ObjectToJson(model);
                }
                else
                {
                    model.Status = "E";
                    model.Message = strError;
                    return JSONHelper.ObjectToJson(model);
                }
            }
            catch (Exception ex)
            {
                model.Status = "E";
                model.Message = "Web异常:" + ex.Message + ex.StackTrace;
                //if (Common_Func.IsOracleError(model.Message, ref strError)) model.Message = strError;
                return JSONHelper.ObjectToJson(model);
            }
        }
示例#10
0
        public string SaveCheckTransScan(int checkID, string strBarcode, string strAreaNo, string strUserJson, bool isTray)
        {
            CheckTransInfo model = new CheckTransInfo();
            string strError = string.Empty;

            try
            {
                //AreaInfo area = JSONHelper.JsonToObject<AreaInfo>(strAreaNo);

                UserInfo user = JSONHelper.JsonToObject<UserInfo>(strUserJson);
                if (user == null || string.IsNullOrEmpty(user.UserNo))
                {
                    model.Status = "E";
                    model.Message = "用户信息获取失败!";
                    return JSONHelper.ObjectToJson(model);
                }
                Area_Func func = new Area_Func();
                AreaInfo area = new AreaInfo();
                area.AreaNo = strAreaNo;
                string strErrMsg = null;
                if (!func.GetAreaByAreaNo(ref area, user, ref strErrMsg))
                {
                    throw new Exception(strErrMsg);
                }
                if (area == null || string.IsNullOrEmpty(area.AreaNo))
                {
                    model.Status = "E";
                    model.Message = "货位信息获取失败!";
                    return JSONHelper.ObjectToJson(model);
                }

                PrintBarcode.Barcode_Func bfunc = new PrintBarcode.Barcode_Func();
                model.ScanBarcode = bfunc.GetCheckBarcode(checkID, strBarcode, isTray, ref strError);
                if (model.ScanBarcode == null)
                {
                    model.Status = "E";
                    model.Message = "条码信息获取失败!" + strError;
                    return JSONHelper.ObjectToJson(model);
                }
                List<string> lstBarcode = new List<string>();
                bool res = true;
                model.CheckID = checkID;
                model.AreaNo = area.AreaNo;
                model.HouseNo = area.HouseNo;
                model.WarehouseNo = area.WarehouseNo;

                model.Operator = user.UserNo;
                model.Barcode = model.ScanBarcode.BARCODE;
                model.SerialNo = model.ScanBarcode.SERIALNO;
                model.BatchNo = model.ScanBarcode.BATCHNO;
                model.SN = model.ScanBarcode.SN;
                model.MaterialNo = model.ScanBarcode.MATERIALNO;
                model.MaterialDesc = model.ScanBarcode.MATERIALDESC;

                model.ScanQty = model.ScanBarcode.QTY;
                if (isTray)
                {
                    res = SaveCheckTransList(ref model, user, ref strError);
                }
                else
                {

                    res = SaveCheckTrans(ref model, user, ref strError);
                }

                if (res)
                {
                    model.Status = "S";
                    return JSONHelper.ObjectToJson(model);
                }
                else
                {
                    model.Status = "E";
                    model.Message = strError;
                    return JSONHelper.ObjectToJson(model);
                }
            }
            catch (Exception ex)
            {
                model.Status = "E";
                model.Message = "Web异常:" + ex.Message + ex.StackTrace;
                //if (Common_Func.IsOracleError(model.Message, ref strError)) model.Message = strError;
                return JSONHelper.ObjectToJson(model);
            }
        }
示例#11
0
        public string SaveCheckTransForAndroid(string strCheckTransJson, string strAreaJson, string strUserJson)
        {
            CheckTransInfo model = new CheckTransInfo();
            string strError = string.Empty;

            try
            {
                model = JSONHelper.JsonToObject<CheckTransInfo>(strCheckTransJson);
                if (model == null || string.IsNullOrEmpty(model.Barcode))
                {
                    model = new CheckTransInfo();
                    model.Status = "E";
                    model.Message = "盘点扫描信息获取失败!请重新扫描!";
                    return JSONHelper.ObjectToJson(model);
                }

                UserInfo user = JSONHelper.JsonToObject<UserInfo>(strUserJson);
                if (user == null || string.IsNullOrEmpty(user.UserNo))
                {
                    model.Status = "E";
                    model.Message = "用户信息获取失败!";
                    return JSONHelper.ObjectToJson(model);
                }

                AreaInfo area = JSONHelper.JsonToObject<AreaInfo>(strAreaJson);
                if (area == null || string.IsNullOrEmpty(area.AreaNo))
                {
                    model.Status = "E";
                    model.Message = "货位信息获取失败!";
                    return JSONHelper.ObjectToJson(model);
                }

                PrintBarcode.Barcode_Func bfunc = new PrintBarcode.Barcode_Func();
                model.ScanBarcode = bfunc.GetCheckBarcode(model.CheckID, model.Barcode, false, ref strError);
                if (model.ScanBarcode == null)
                {
                    model.Status = "E";
                    model.Message = "条码信息获取失败!" + strError;
                    return JSONHelper.ObjectToJson(model);
                }

                model.AreaNo = area.AreaNo;
                model.HouseNo = area.HouseNo;
                model.WarehouseNo = area.WarehouseNo;

                model.Operator = user.UserNo;
                model.Barcode = model.ScanBarcode.BARCODE;
                model.SerialNo = model.ScanBarcode.SERIALNO;
                model.BatchNo = model.ScanBarcode.BATCHNO;
                model.SN = model.ScanBarcode.SN;
                model.MaterialNo = model.ScanBarcode.MATERIALNO;
                model.MaterialDesc = model.ScanBarcode.MATERIALDESC;

                bool bResult = SaveCheckTrans(ref model, user, ref strError);

                if (bResult)
                {
                    model.Status = "S";
                    return JSONHelper.ObjectToJson(model);
                }
                else
                {
                    model.Status = "E";
                    model.Message = strError;
                    return JSONHelper.ObjectToJson(model);
                }
            }
            catch (Exception ex)
            {
                model.Status = "E";
                model.Message = "Web异常:" + ex.Message + ex.StackTrace;
                return JSONHelper.ObjectToJson(model);
            }
        }
示例#12
0
        private SqlParameter[] GetListParameterFromModel(CheckTransInfo model)
        {
            int i;

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

                new SqlParameter("@v_ID", SqlDbType.Int),
                new SqlParameter("@v_CheckID", SqlDbType.Int),
                new SqlParameter("@v_WarehouseNo", SqlDbType.NVarChar),
                new SqlParameter("@v_HouseNo", SqlDbType.NVarChar),
                new SqlParameter("@v_AreaNo", SqlDbType.NVarChar),
                new SqlParameter("@v_MaterialNo", SqlDbType.NVarChar),
                new SqlParameter("@v_MaterialDesc", SqlDbType.NVarChar),
                new SqlParameter("@v_Operator", SqlDbType.NVarChar),
                new SqlParameter("@v_OperationTime", SqlDbType.DateTime),
                new SqlParameter("@v_MaterialStd", SqlDbType.NVarChar),
                new SqlParameter("@xmlCheck", SqlDbType.Xml),
            };
            TrayDetails_Model traydetails = new TrayDetails_Model();

            traydetails.listBarcode = new List <string>();
            foreach (TrayDetails_Model item in model.ScanBarcode.tray_Model.listDetails)
            {
                traydetails.listBarcode.AddRange(item.listBarcode);
            }

            i = 1;
            param[i++].Value = model.ID;
            param[i++].Value = model.CheckID;
            param[i++].Value = model.WarehouseNo;
            param[i++].Value = model.HouseNo;
            param[i++].Value = model.AreaNo;
            param[i++].Value = model.MaterialNo;
            param[i++].Value = model.MaterialDesc;
            param[i++].Value = model.Operator;
            param[i++].Value = model.OperationTime;
            param[i++].Value = model.MaterialStd;
            param[i++].Value = XMLUtil.XmlUtil.Serializer(typeof(TrayDetails_Model), traydetails);

            i = 0;
            param[i++].Direction = ParameterDirection.Output;
            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.InputOutput;
            param[i++].Direction = ParameterDirection.Input;
            param[i++].Direction = ParameterDirection.Input;

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

            return(param);
        }
示例#13
0
        private SqlParameter[] GetParameterFromModel(CheckTransInfo model)
        {
            int i;

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

                new SqlParameter("@v_ID", SqlDbType.Int),
                new SqlParameter("@v_CheckID", SqlDbType.Int),
                new SqlParameter("@v_WarehouseNo", SqlDbType.NVarChar),
                new SqlParameter("@v_HouseNo", SqlDbType.NVarChar),
                new SqlParameter("@v_AreaNo", SqlDbType.NVarChar),
                new SqlParameter("@v_MaterialNo", SqlDbType.NVarChar),
                new SqlParameter("@v_MaterialDesc", SqlDbType.NVarChar),
                new SqlParameter("@v_Barcode", SqlDbType.NVarChar),
                new SqlParameter("@v_SerialNo", SqlDbType.NVarChar),
                new SqlParameter("@v_BatchNo", SqlDbType.NVarChar),
                new SqlParameter("@v_SN", SqlDbType.NVarChar),
                new SqlParameter("@v_ScanQty", SqlDbType.Decimal),
                new SqlParameter("@v_Operator", SqlDbType.NVarChar),
                new SqlParameter("@v_OperationTime", SqlDbType.DateTime),
                new SqlParameter("@v_MaterialStd", SqlDbType.NVarChar),
            };
            i = 1;
            param[i++].Value = model.ID;
            param[i++].Value = model.CheckID;
            param[i++].Value = model.WarehouseNo;
            param[i++].Value = model.HouseNo;
            param[i++].Value = model.AreaNo;
            param[i++].Value = model.MaterialNo;
            param[i++].Value = model.MaterialDesc;
            param[i++].Value = model.Barcode;
            param[i++].Value = model.SerialNo;
            param[i++].Value = model.BatchNo;
            param[i++].Value = model.SN;
            param[i++].Value = model.ScanQty;
            param[i++].Value = model.Operator;
            param[i++].Value = model.OperationTime;
            param[i++].Value = model.MaterialStd;



            i = 0;
            param[i++].Direction = ParameterDirection.Output;
            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.Input;
            param[i++].Direction = ParameterDirection.Input;
            param[i++].Direction = ParameterDirection.Input;
            param[i++].Direction = ParameterDirection.InputOutput;
            param[i++].Direction = ParameterDirection.Input;


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

            return(param);
        }