public void ToReplacementModel_RelativeUri_TextReplacement()
        {
            var mock = new Mock <IFileSystem>();

            mock.Setup(fs => fs.FileExists(It.IsAny <string>())).Returns(false);
            mock.Setup(fs => fs.FileReadAllText(It.IsAny <string>())).Returns(CodeSample);
            var regionCache = new FileRegionsCache(fileSystem: mock.Object);

            Uri uri = new Uri(RelativeFilePath, UriKind.Relative);

            Replacement replacement = new Replacement
            {
                DeletedRegion = new Region
                {
                    CharOffset = 196,
                    CharLength = 14,
                },
                InsertedContent = new ArtifactContent
                {
                    Text = ReplacementText,
                },
            };
            ReplacementModel model = replacement.ToReplacementModel(regionCache, uri);

            model.Should().NotBeNull();
            model.InsertedBytes.Should().BeNull();
            model.InsertedString.Should().BeEquivalentTo(ReplacementText);
            model.Region.Should().NotBeNull();
            model.Region.CharLength.Should().Be(14);
            model.Region.CharOffset.Should().Be(196);
            model.Region.IsBinaryRegion.Should().BeFalse();
            model.Region.ByteOffset.Should().Be(-1);
        }
Пример #2
0
        public void ToFixModel_FileDoesNotExists_FixIsNotApplyable()
        {
            var mock = new Mock <IFileSystem>();

            mock.Setup(fs => fs.FileExists(It.IsAny <string>())).Returns(false);
            mock.Setup(fs => fs.FileReadAllText(It.IsAny <string>())).Returns(string.Empty);
            var regionCache = new FileRegionsCache(fileSystem: mock.Object);

            string descriptionString = "test description";
            string replacementText   = "public class";

            var fix = new Fix
            {
                Description = new Message {
                    Text = descriptionString
                },
                ArtifactChanges = new List <ArtifactChange>
                {
                    new ArtifactChange
                    {
                        ArtifactLocation = new ArtifactLocation
                        {
                            Uri = new Uri(AnotherFilePath, UriKind.Absolute),
                        },
                        Replacements = new List <Replacement>
                        {
                            new Replacement
                            {
                                DeletedRegion = new Region
                                {
                                    CharOffset = 196,
                                    CharLength = 14,
                                },
                                InsertedContent = new ArtifactContent
                                {
                                    Text = replacementText
                                },
                            },
                        },
                    },
                },
            }.ToFixModel(originalUriBaseIds: null, regionCache);

            fix.Description.Should().BeEquivalentTo(descriptionString);
            fix.ArtifactChanges.Count.Should().Be(1);
            fix.CanBeAppliedToFile(FilePath).Should().BeFalse();
            ObservableCollection <ReplacementModel> replacements = fix.ArtifactChanges.FirstOrDefault().Replacements;

            // file doesn't exist, output replacement should have be same as input region.
            replacements.Count.Should().Be(1);
            ReplacementModel replacement = replacements.FirstOrDefault();

            replacement.InsertedString.Should().BeEquivalentTo(replacementText);
            replacement.Region.CharOffset.Should().Be(196);
            replacement.Region.CharLength.Should().Be(14);
            replacement.Region.StartLine.Should().Be(0);
            replacement.Region.EndLine.Should().Be(0);
            replacement.Region.StartColumn.Should().Be(0);
            replacement.Region.EndColumn.Should().Be(0);
        }
Пример #3
0
        public static ReplacementModel ToReplacementModel(this Replacement replacement, FileRegionsCache fileRegionsCache, Uri uri)
        {
            if (replacement == null)
            {
                return(null);
            }

            var model = new ReplacementModel
            {
                Region = uri.IsAbsoluteUri
                    ? fileRegionsCache.PopulateTextRegionProperties(replacement.DeletedRegion, uri, populateSnippet: false)
                    : replacement.DeletedRegion,
            };

            if (model.Region.CharOffset >= 0)
            {
                // This is a text replacement.
                model.InsertedString = replacement.InsertedContent?.Text;
            }
            else
            {
                // This is a binary replacement, but don't try to convert the replacement
                // content to a string if there isn't any.
                if (replacement.InsertedContent?.Binary != null)
                {
                    model.InsertedBytes = Convert.FromBase64String(replacement.InsertedContent.Binary);
                }
            }

            return(model);
        }
        public void ToReplacementModel_RelativeUri_BinaryReplacement()
        {
            var mock = new Mock <IFileSystem>();

            mock.Setup(fs => fs.FileExists(It.IsAny <string>())).Returns(false);
            mock.Setup(fs => fs.FileReadAllText(It.IsAny <string>())).Returns(CodeSample);
            var regionCache = new FileRegionsCache(fileSystem: mock.Object);

            Uri uri = new Uri(RelativeFilePath, UriKind.Relative);

            byte[] bytes = Encoding.UTF8.GetBytes(ReplacementText);

            Replacement replacement = new Replacement
            {
                DeletedRegion = new Region
                {
                    ByteOffset = 210,
                },
                InsertedContent = new ArtifactContent
                {
                    Binary = Convert.ToBase64String(bytes),
                },
            };
            ReplacementModel model = replacement.ToReplacementModel(regionCache, uri);

            model.Should().NotBeNull();
            model.InsertedString.Should().BeNull();
            model.InsertedBytes.Should().BeEquivalentTo(bytes);
            model.Region.Should().NotBeNull();
            model.Region.IsBinaryRegion.Should().BeTrue();
            model.Region.CharOffset.Should().Be(-1);
            model.Region.ByteOffset.Should().Be(210);
        }
Пример #5
0
    private ReplacementModel GetReplacementModel()
    {
        //获得当前操作的时间
        DateTime dt = DateTime.Now;
        //往换货单实体类中添加数据
        ReplacementModel replacementModel = new ReplacementModel();

        replacementModel.DisplaceOrderID = BLL.other.Company.InventoryDocBLL.GetReplacementID();
        replacementModel.StoreID         = txtStoreId.Text;
        replacementModel.MakeDocDate     = dt;
        replacementModel.ExpectNum       = BLL.CommonClass.CommonDataBLL.GetMaxqishu();
        replacementModel.OutTotalMoney   = Convert.ToDouble(ViewState["TuizongPrice"]);
        replacementModel.OutTotalPV      = Convert.ToDouble(ViewState["TuizongPv"]);
        replacementModel.InTotalMoney    = Convert.ToDouble(ViewState["zongPrice"]);
        replacementModel.InTotalPV       = Convert.ToDouble(ViewState["zongPv"]);
        replacementModel.InceptAddress   = Encryption.Encryption.GetEncryptionAddress(txtAddress.Text);
        replacementModel.InceptPerson    = Encryption.Encryption.GetEncryptionName(txtInceptMan.Text);
        replacementModel.PostalCode      = txtpostalcode.Text.Trim();
        replacementModel.Telephone       = Encryption.Encryption.GetEncryptionTele(txtTele.Text);
        replacementModel.StateFlag       = "N";
        replacementModel.CloseFlag       = "N";
        replacementModel.Remark          = txtMemo.Text.Trim();
        replacementModel.AuditingDate    = dt;
        replacementModel.MakeDocPerson   = Session["Company"].ToString();
        return(replacementModel);
    }
Пример #6
0
        public void ToFixModel_FileExists_FixIsApplyable()
        {
            var mock = new Mock <IFileSystem>();

            mock.Setup(fs => fs.FileExists(It.IsAny <string>())).Returns(true);
            mock.Setup(fs => fs.FileReadAllText(It.IsAny <string>())).Returns(CodeSample);
            var regionCache = new FileRegionsCache(fileSystem: mock.Object);

            string descriptionString = "test description";
            string replacementText   = "public class";

            var fix = new Fix
            {
                Description = new Message {
                    Text = descriptionString
                },
                ArtifactChanges = new List <ArtifactChange>
                {
                    new ArtifactChange
                    {
                        ArtifactLocation = new ArtifactLocation
                        {
                            Uri = new Uri(FilePath, UriKind.Absolute),
                        },
                        Replacements = new List <Replacement>
                        {
                            new Replacement
                            {
                                DeletedRegion = new Region
                                {
                                    CharOffset = 196,
                                    CharLength = 14,
                                },
                                InsertedContent = new ArtifactContent
                                {
                                    Text = replacementText
                                },
                            },
                        },
                    },
                },
            }.ToFixModel(originalUriBaseIds: null, regionCache);

            fix.Description.Should().BeEquivalentTo(descriptionString);
            fix.ArtifactChanges.Count.Should().Be(1);
            fix.CanBeAppliedToFile(FilePath).Should().BeTrue();
            ObservableCollection <ReplacementModel> replacements = fix.ArtifactChanges.FirstOrDefault().Replacements;

            // input replacement is charoffset based. output replacement should have start/end line/column info.
            replacements.Count.Should().Be(1);
            ReplacementModel replacement = replacements.FirstOrDefault();

            replacement.InsertedString.Should().BeEquivalentTo(replacementText);
            replacement.Region.StartLine.Should().Be(6);
            replacement.Region.EndLine.Should().Be(6);
            replacement.Region.StartColumn.Should().Be(7);
            replacement.Region.EndColumn.Should().Be(21);
        }
        /// <summary>
        /// Initializes a new instance of the <see cref="ReplacementEdit"/> class.
        /// </summary>
        /// <param name="replacement">The SARIF replacement from which to construct the edit.</param>
        /// <param name="snapshot">The snapshot to which the edit will be applied.</param>
        public ReplacementEdit(ReplacementModel replacement, ITextSnapshot snapshot)
        {
            this.Text = replacement.InsertedString ?? string.Empty;

            ITrackingSpan replacementSpan = replacement.PersistentSpan.Span;
            SnapshotPoint start           = replacementSpan.GetStartPoint(snapshot);
            SnapshotPoint end             = replacementSpan.GetEndPoint(snapshot);

            this.Span = new SnapshotSpan(start, end);
        }
Пример #8
0
        /// <summary>
        /// 获取店铺换货列表
        /// </summary>
        /// <returns></returns>
        public IList <ReplacementModel> GetReplacementlList(int pageIndex, string key,
                                                            int pageSize, string table, string columns, string condition, out int recordCount, out int pageCount)
        {
            IList <ReplacementModel> list = new List <ReplacementModel>();

            recordCount = 0;
            pageCount   = 0;
            SqlParameter[] parm0 = { new SqlParameter("@PageIndex",   SqlDbType.Int),
                                     new SqlParameter("@PageSize",    SqlDbType.Int),
                                     new SqlParameter("@table",       SqlDbType.VarChar,  1000),
                                     new SqlParameter("@columns",     SqlDbType.NVarChar, 2000),
                                     new SqlParameter("@condition",   SqlDbType.NVarChar, 2000),
                                     new SqlParameter("@key",         SqlDbType.VarChar,    50),
                                     new SqlParameter("@RecordCount", SqlDbType.Int),
                                     new SqlParameter("@PageCount",   SqlDbType.Int) };

            parm0[0].Value = pageIndex;
            parm0[1].Value = pageSize;
            parm0[2].Value = table;
            parm0[3].Value = columns;
            parm0[4].Value = condition;
            parm0[5].Value = key;
            parm0[6].Value = recordCount;
            parm0[7].Value = pageCount;

            parm0[6].Direction = System.Data.ParameterDirection.Output;
            parm0[7].Direction = System.Data.ParameterDirection.Output;


            DataTable dt = DBHelper.ExecuteDataTable("GetCustomersDataPage", parm0, CommandType.StoredProcedure);

            recordCount = Convert.ToInt32(parm0[6].Value);
            pageCount   = Convert.ToInt32(parm0[7].Value);

            foreach (DataRow item in dt.Rows)
            {
                ReplacementModel replacementModel = new ReplacementModel((int)item["id"]);
                list.Add(replacementModel);
                replacementModel.StoreID           = (string)item["StoreID"];
                replacementModel.RefundmentOrderID = (string)item["RefundmentOrderID"];
                replacementModel.StoreOrderID      = (string)item["StoreOrderID"];
                replacementModel.ExpectNum         = (int)item["ExpectNum"];
                replacementModel.StateFlag         = item["StateFlag"].ToString(); //(int )item["StateFlag"];
                replacementModel.CloseFlag         = item["CloseFlag"].ToString(); // (int)item["CloseFlag"];
                //replacementModel.InGoodsMoney = 444;// Convert.ToDouble(item["ingoodsmoney"]);
                //replacementModel.OutGoodsMoney = 333;// Convert.ToDouble(item["outgoodmoney"]);
                replacementModel.MakeDocDate = (DateTime)item["MakeDocDate"];
            }

            return(list);
        }
Пример #9
0
        //添加换货信息
        public void ADDReplacement(ReplacementModel replacementModel, ArrayList displaceList)
        {
            using (SqlConnection conn = new SqlConnection(DBHelper.connString))
            {
                conn.Open();
                SqlTransaction tran = conn.BeginTransaction();
                try
                {
                    string SQL_Insert_DisplaceGoodsOrder = @"insert into  Replacement (DisplaceOrderID, StoreID, MakeDocDate, MakeDocPerson,ExpectNum, OutTotalMoney, 
						OutTotalPV, InTotalMoney, InTotalPV, InceptAddress, InceptPerson, PostalCode, Telephone, StateFlag, CloseFlag,remark)
                         values( @DisplaceOrderID,  @StoreID, @MakeDocDate, @MakeDocPerson,
						@ExpectNum, @OutTotalMoney, @OutTotalPV, @InTotalMoney, @InTotalPV,
						 @InceptAddress, @InceptPerson, @PostalCode, @Telephone, @StateFlag, @CloseFlag,@remark)"                        ;

                    SqlParameter[] para =
                    {
                        new SqlParameter("@DisplaceOrderID", replacementModel.DisplaceOrderID),
                        new SqlParameter("@StoreID",         replacementModel.StoreID),
                        new SqlParameter("@MakeDocDate",     replacementModel.MakeDocDate),

                        new SqlParameter("@MakeDocPerson",   replacementModel.MakeDocPerson),
                        new SqlParameter("@ExpectNum",       replacementModel.ExpectNum),
                        new SqlParameter("@OutTotalMoney",   replacementModel.OutTotalMoney),
                        new SqlParameter("@OutTotalPV",      replacementModel.OutTotalPV),
                        new SqlParameter("@InTotalMoney",    replacementModel.InTotalMoney),
                        new SqlParameter("@InTotalPV",       replacementModel.InTotalPV),
                        new SqlParameter("@InceptAddress",   replacementModel.InceptAddress),
                        new SqlParameter("@InceptPerson",    replacementModel.InceptPerson),
                        new SqlParameter("@PostalCode",      replacementModel.PostalCode),
                        new SqlParameter("@Telephone",       replacementModel.Telephone),
                        new SqlParameter("@StateFlag",       replacementModel.StateFlag),
                        new SqlParameter("@CloseFlag",       replacementModel.CloseFlag),
                        new SqlParameter("@remark",          replacementModel.Remark)
                    };
                    DBHelper.ExecuteNonQuery(tran, SQL_Insert_DisplaceGoodsOrder, para, CommandType.Text);

                    CreateReplacementDetails(tran, displaceList, replacementModel.DisplaceOrderID);
                    tran.Commit();
                }
                catch (Exception err)
                {
                    tran.Rollback();
                    throw err;
                }
                finally
                {
                    conn.Close();
                }
            }
        }
        public void ToReplacementModel_NullReplacement_ReturnNull()
        {
            var mock = new Mock <IFileSystem>();

            mock.Setup(fs => fs.FileExists(It.IsAny <string>())).Returns(false);
            mock.Setup(fs => fs.FileReadAllText(It.IsAny <string>())).Returns(CodeSample);
            var regionCache = new FileRegionsCache(fileSystem: mock.Object);

            Uri uri = new Uri(FilePath);

            Replacement      replacement = null;
            ReplacementModel model       = replacement.ToReplacementModel(regionCache, uri);

            model.Should().BeNull();
        }
Пример #11
0
        static public ReplacementModel FromDTO(Replacement dto)
        {
            ReplacementModel model = null;

            if (dto != null)
            {
                model = new ReplacementModel();
                var coursesDAO = new MSSQLCourseDAO();
                model.Replaced = Courses.Mapper.FromDTO(coursesDAO.FindCourseById(dto.ReplacedID));

                var replacementsCoursesDAO = new MSSQLReplacementsCoursesDAO();
                foreach (ReplacementCourse rc in replacementsCoursesDAO.FindByReplacementId(dto.Id))
                {
                    model.AddCourse(Courses.Mapper.FromDTO(coursesDAO.FindCourseById(rc.courseID)));
                }
            }

            return(model);
        }
Пример #12
0
        //根据换货单号得到换货单详细
        /// <summary>
        /// 根据换货单号得到换货单详细
        /// </summary>
        /// <returns></returns>
        public ReplacementModel GetReplacementlModelByDisplaceOrderID(string displaceOrderID)
        {
            ReplacementModel replacementModel = null;
            string           sql = "Select id,displaceorderid,storeid,storeorderid,refundmentorderid,OutStorageOrderID,makedocdate,makedocperson,auditperson,expectnum,outtotalmoney,outtotalpv,intotalmoney,intotalpv,inceptaddress,postalcode,telephone,stateflag,closeflag, remark,operateip,operatenum,inceptperson From Replacement Where DisplaceOrderID = @DisplaceOrderID ";

            SqlParameter[] para = new SqlParameter[] { new SqlParameter("@DisplaceOrderID", displaceOrderID) };
            SqlDataReader  dr   = DBHelper.ExecuteReader(sql, para, CommandType.Text);

            if (dr.Read())
            {
                replacementModel = new ReplacementModel();
                replacementModel.DisplaceOrderID   = dr.GetString(dr.GetOrdinal("displaceorderid"));
                replacementModel.StoreID           = dr.GetString(dr.GetOrdinal("storeid"));
                replacementModel.StoreOrderID      = dr.GetString(dr.GetOrdinal("storeorderid"));
                replacementModel.RefundmentOrderID = dr.GetString(dr.GetOrdinal("refundmentorderid"));
                replacementModel.OutStrageOrderID  = dr.GetString(dr.GetOrdinal("OutStorageOrderID"));
                replacementModel.MakeDocDate       = dr.GetDateTime(dr.GetOrdinal("makedocdate"));
                replacementModel.MakeDocPerson     = dr.GetString(dr.GetOrdinal("makedocperson"));
                // replacementModel.AuditingDate = dr.GetDateTime(dr.GetOrdinal("auditingdate"));
                replacementModel.AuditPerson = dr.GetString(dr.GetOrdinal("auditperson"));
                replacementModel.ExpectNum   = dr.GetInt32(dr.GetOrdinal("expectnum"));

                replacementModel.OutTotalMoney = double.Parse(dr["outtotalmoney"].ToString());
                replacementModel.OutTotalPV    = double.Parse(dr["outtotalpv"].ToString());
                replacementModel.InTotalMoney  = double.Parse(dr["intotalmoney"].ToString());
                replacementModel.InTotalPV     = double.Parse(dr["intotalpv"].ToString());
                replacementModel.InceptAddress = dr.GetString(dr.GetOrdinal("inceptaddress"));
                replacementModel.PostalCode    = dr.GetString(dr.GetOrdinal("postalcode"));
                replacementModel.Telephone     = dr.GetString(dr.GetOrdinal("telephone"));
                //replacementModel.StateFlag=int.Parse(dr["stateflag"].ToString());
                //replacementModel.StateFlag = dr.GetInt32(dr.GetOrdinal("stateflag"));
                //replacementModel.CloseFlag=int.Parse(dr["closeflag"].ToString());
                //replacementModel.CloseFlag = dr.GetInt32(dr.GetOrdinal("closeflag"));
                replacementModel.Remark       = dr.GetString(dr.GetOrdinal("remark"));
                replacementModel.OperateIP    = dr.GetString(dr.GetOrdinal("operateip"));
                replacementModel.OperateNum   = dr.GetString(dr.GetOrdinal("operatenum"));
                replacementModel.InceptPerson = dr.GetString(dr.GetOrdinal("inceptperson"));
            }
            dr.Close();
            return(replacementModel);
        }
Пример #13
0
        public void TestFromDTO()
        {
            //GIVEN

            int    _replacedId        = 2;
            int    _replacementId     = 7;
            string _replacedName      = "Podstawy Programowania";
            string _replacedCode      = "INZ1519L";
            string _replacementCode   = "INP002258Wl";
            string _replacementName   = "Kurs programowania";
            int    _replacementsCount = 1;
            Mock <IReplacementDAO> replacementsDAOmock;
            ReplacementModel       model;


            Replacement rep = new Replacement(_replacementId, _replacedId);

            replacementsDAOmock = new Mock <IReplacementDAO>();
            replacementsDAOmock.Setup(x => x.FindByReplacedId(rep.ReplacedID)).Returns(new List <Replacement>()
            {
                rep
            });

            model          = new ReplacementModel();
            model.Replaced = new CourseModel()
            {
                Code = _replacementCode, Name = _replacedName
            };


            var dtoList = replacementsDAOmock.Object.FindByReplacedId(_replacedId);

            //WHEN
            var mappedModel = Mapper.FromDTO(dtoList[0]);

            //THEN
            Assert.AreEqual(_replacedCode, mappedModel.Replaced.Code);
            Assert.AreEqual(_replacedName, mappedModel.Replaced.Name);
            Assert.IsTrue(mappedModel.Replacements.Exists(r => r.Code == _replacementCode));
            Assert.IsTrue(mappedModel.Replacements.Exists(r => r.Name == _replacementName));
        }
        public static ReplacementModel ToReplacementModel(this Replacement replacement)
        {
            if (replacement == null)
            {
                return(null);
            }

            ReplacementModel model = new ReplacementModel();

            model.DeletedLength = replacement.DeletedLength;

            if (!String.IsNullOrEmpty(replacement.InsertedBytes))
            {
                model.InsertedString = Encoding.UTF8.GetString(Convert.FromBase64String(replacement.InsertedBytes));
                model.InsertedBytes  = Encoding.UTF8.GetBytes(model.InsertedString);
            }

            model.Offset = replacement.Offset;

            return(model);
        }
Пример #15
0
        public static ReplacementModel ToReplacementModel(this Replacement replacement)
        {
            if (replacement == null)
            {
                return(null);
            }

            ReplacementModel model = new ReplacementModel();

            model.DeletedLength = replacement.DeletedRegion.ByteLength;
            model.Offset        = replacement.DeletedRegion.ByteOffset;

            if (!string.IsNullOrWhiteSpace(replacement.InsertedContent?.Text))
            {
                model.InsertedString = replacement.InsertedContent.Text;
            }
            else if (replacement.InsertedContent?.Binary != null)
            {
                model.InsertedBytes = Convert.FromBase64String(replacement.InsertedContent.Binary);
            }

            return(model);
        }
Пример #16
0
 private static bool HasOffsetAndLength(ReplacementModel replacementModel) =>
 replacementModel.Offset >= 0 && replacementModel.DeletedLength >= 0;
Пример #17
0
        //根据换货单号得到换货单详细
        /// <summary>
        /// 根据换货单号得到换货单详细
        /// </summary>
        /// <returns></returns>
        public void SaveReplacementlModelByDisplaceOrderID(string displaceOrderID, string number, ReplacementModel replacementModel, ArrayList displaceList)
        {
            using (SqlConnection conn = new SqlConnection(DBHelper.connString))
            {
                conn.Open();
                SqlTransaction tran = conn.BeginTransaction();
                try
                {       //得到制单人
                    CommonDataDAL commonDataDAL = new CommonDataDAL();
                    string        makeman       = commonDataDAL.GetNameByAdminID(number);

                    //删除原来的明细
                    SqlParameter[] sPara = new SqlParameter[] { new SqlParameter("@num", SqlDbType.VarChar, 20) };
                    sPara[0].Value = displaceOrderID;

                    DBHelper.ExecuteNonQuery(tran, "delete from ReplacementDetail where displaceOrderID =@num", sPara, CommandType.Text);
                    foreach (ReplacementDetailModel replacementDetailModel in displaceList)
                    {
                        replacementDetailModel.DisplaceOrderID = replacementModel.DisplaceOrderID;
                    }

                    CreateReplacementDetails(tran, displaceList, displaceOrderID);

                    //更新原来的换货单信息
                    string         SQL_UPDATE_DisplaceGoodsOrder = @"UPDATE Replacement SET 
																MakeDocPerson = @MakeDocPerson, ExpectNum = @ExpectNum, 
																OutTotalMoney = @OutTotalMoney, OutTotalPV = @OutTotalPV, 
																InTotalMoney = @InTotalMoney, InTotalPV = @InTotalPV, 
																InceptAddress = @InceptAddress, InceptPerson = @InceptPerson, 
																PostalCode = @PostalCode, Telephone = @Telephone,remark=@remark
																WHERE DisplaceOrderID = @DisplaceOrderID"                                                                ;
                    SqlParameter[] para =
                    {
                        new SqlParameter("@MakeDocPerson",   replacementModel.MakeDocPerson),
                        new SqlParameter("@ExpectNum",       replacementModel.ExpectNum),
                        new SqlParameter("@OutTotalMoney",   replacementModel.OutTotalMoney),
                        new SqlParameter("@OutTotalPV",      replacementModel.OutTotalPV),
                        new SqlParameter("@InTotalMoney",    replacementModel.InTotalMoney),
                        new SqlParameter("@InTotalPV",       replacementModel.InTotalPV),
                        new SqlParameter("@InceptAddress",   replacementModel.InceptAddress),
                        new SqlParameter("@InceptPerson",    replacementModel.InceptPerson),
                        new SqlParameter("@PostalCode",      replacementModel.PostalCode),
                        new SqlParameter("@Telephone",       replacementModel.Telephone),
                        new SqlParameter("@DisplaceOrderID", replacementModel.DisplaceOrderID),
                        new SqlParameter("@remark",          replacementModel.Remark)
                    };
                    int a = DBHelper.ExecuteNonQuery(tran, SQL_UPDATE_DisplaceGoodsOrder, para, CommandType.Text);

                    tran.Commit();
                }
                catch (Exception err)
                {
                    tran.Rollback();
                    throw err;
                }
                finally
                {
                    conn.Close();
                }
            }
        }
Пример #18
0
 //添加换货信息
 public void ADDReplacement(ReplacementModel replacementModel, ArrayList displaceList)
 {
     displaceGoodBrowseDAL.ADDReplacement(replacementModel, displaceList);
 }
Пример #19
0
 //根据换货单号得到换货单详细
 /// 添加换货单和单据明细信息
 /// </summary>
 /// <param name="ReplacementModel">换货单</param>
 /// 根据换货单号得到换货单详细
 /// </summary>
 /// <returns></returns>
 public void SaveReplacementlModelByDisplaceOrderID(string displaceOrderID, string number, ReplacementModel replacementModel, ArrayList displaceList)
 {
     displaceGoodBrowseDAL.SaveReplacementlModelByDisplaceOrderID(displaceOrderID, number, replacementModel, displaceList);
 }
 private ReplacementEdit ToEdit(ReplacementModel replacement) =>
 new ReplacementEdit(replacement, this.textBuffer.CurrentSnapshot);
Пример #21
0
        private void AddTestPage(String testData)
        {
            String[] firstSplit = testData.Split('^');
            if (firstSplit.Length > 0)
            {
                //labelDebugOutput.Text = "Split length " + firstSplit.Length;
                Page newPage = new Page();

                newPage.pageNum = Convert.ToInt32(firstSplit[0]);
                //labelDebugOutput.Text = "pageNumber loaded " + Convert.ToInt32(firstSplit[0]);

                String[] words = firstSplit[1].Split('|');
                newPage.sceneScreenshotFilename = words[0];
                newPage.originalModelId = words[1];
                //labelDebugOutput.Text = "originalModelId  " + newPage.originalModelId;

                List<ReplacementModel> replacementModels = new List<ReplacementModel>();
                for (int i = 2; i < words.Length; i++)
                {
                    String[] suggestionData = words[i].Split(':');

                    ReplacementModel replacement = new ReplacementModel();
                    if (String.Compare("R", suggestionData[0], true) == 0)
                    {
                        replacement.suggestionType = 0;
                    }
                    else if (String.Compare("S", suggestionData[0], true) == 0)
                    {
                        replacement.suggestionType = 1;
                    }
                    else if (String.Compare("M", suggestionData[0], true) == 0)
                    {
                        replacement.suggestionType = 2;
                    }

                    if (String.Compare("Y", suggestionData[1], true) == 0)
                    {
                        replacement.isSelected = true;
                    }
                    else
                    {
                        replacement.isSelected = false;
                    }

                    replacement.modelId = suggestionData[2];

                    replacementModels.Add(replacement);
                } // for() each replacement model

                newPage.replacements = replacementModels;
                pageList.Add(newPage);
            }
        }