Exemple #1
0
        public bool ArchiveLendSlip(LendSlip paras)
        {
            int    API   = 5;
            string token = HttpContext.Current.Request.Headers.Get("token");

            if (Models.UniversalModels.User.IsValidToken(token))
            {
                User CurrentUser = Models.UniversalModels.User.GetUserByToken(token);

                if (Models.UniversalModels.User.IsContainsCurrentAPIPermission(CurrentUser.UserID, API))
                {
                    Log log = new Log(API, CurrentUser);
                    log.Add(token + "|" + nameof(paras) + ":" + JsonConvert.SerializeObject(paras));

                    try
                    {
                        bool s = new GageServiceImpl().ArchiveLendSlip(paras);
                        return(s);
                    }
                    catch (Exception ex)
                    {
                        log.Add("Exception:" + ex.Message + "|" + ex.StackTrace);
                        return(false);
                    }
                }
            }
            throw new HttpResponseException(HttpStatusCode.Forbidden);
        }//5
        public virtual bool AddLendSlip(LendSlip lendSlip, User CurrentUser)
        {
            using (SqlConnection conn = new SqlConnection(Common.SQLHelper.Asset_strConn))
            {
                conn.Open();
                SqlTransaction sqlTransaction = conn.BeginTransaction();
                try
                {
                    Asset asset = Asset.GetBy(lendSlip.AssetID);
                    if (asset == null)
                    {
                        throw new Exception("资产不存在");
                    }
                    if (asset.Status != "在库")
                    {
                        throw new Exception("资产未处于在库状态");
                    }

                    lendSlip.AssetName          = asset.AssetName;
                    lendSlip.AssetCategory      = asset.AssetCategory;
                    lendSlip.ApplicantName      = Personnel.GetBy(lendSlip.ApplicantID).Name;
                    lendSlip.LendDate           = DateTime.Now;
                    lendSlip.TransactorName     = CurrentUser.Name;
                    lendSlip.ReceiverDepartment = Personnel.GetBy(lendSlip.ApplicantID).Department;

                    asset.CurrentWhereSpot         = lendSlip.WhereUsing;// + lendSlip.ApplicantName;
                    asset.CurrentWhereOrganization = lendSlip.ReceiverDepartment;
                    asset.Status = asset.AddStatus("领用");

                    lendSlip.sqlTransaction = asset.sqlTransaction = sqlTransaction;
                    lendSlip.Add();
                    asset.Update();

                    sqlTransaction.Commit();
                    return(true);
                }
                catch
                {
                    sqlTransaction.Rollback();
                    throw;
                }
            }
        }
        public virtual bool ArchiveLendSlip(LendSlip paras)
        {
            using (SqlConnection conn = new SqlConnection(Common.SQLHelper.Asset_strConn))
            {
                conn.Open();
                SqlTransaction sqlTransaction = conn.BeginTransaction();
                try
                {
                    LendSlip lendSlip = LendSlip.GetBy(paras.ID);


                    Asset asset = Asset.GetBy(lendSlip.AssetID);
                    if (asset == null)
                    {
                        throw new Exception("资产不存在");
                    }
                    if (!asset.Status.Contains("领用"))
                    {
                        throw new Exception("资产未被领用");
                    }


                    asset.RemoveStatus("领用");
                    asset.RefreshPosition();

                    paras.CopyTo(lendSlip, false);
                    lendSlip.ReturnDate = DateTime.Now;

                    asset.sqlTransaction = lendSlip.sqlTransaction = sqlTransaction;
                    asset.Update();
                    lendSlip.Update();

                    sqlTransaction.Commit();
                    return(true);
                }
                catch
                {
                    sqlTransaction.Rollback();
                    throw;
                }
            }
        }
 public virtual IEnumerable <LendSlip> GetLendSlipsOf(string AssetID)
 {
     return(LendSlip.GetBy(AssetID));
 }
 public virtual IEnumerable <LendSlip> GetAllLendSlips()
 {
     return(LendSlip.GetAll());
 }