/// <summary>
        /// 添加办公用品领用信息
        /// </summary>
        /// <param name="OfficeThingsUsedM">领用单主信息</param>
        /// <param name="OfficeThingsUsedInfos">领用详细信息</param>
        /// <returns>添加是否成功 false:失败,true:成功</returns>
        public static bool InserOfficeThingsUsedInfo(OfficeThingsUsedModel OfficeThingsUsedM, string OfficeThingsUsedInfos)
        {
            try
            {
                #region 添加入库库存信息sql语句
                StringBuilder OfficeThingsUsedSql = new StringBuilder();
                OfficeThingsUsedSql.AppendLine("INSERT INTO officedba.OfficeThingsUsed");
                OfficeThingsUsedSql.AppendLine("(CompanyCD");
                OfficeThingsUsedSql.AppendLine(",ApplyNo     ");
                OfficeThingsUsedSql.AppendLine(",Title");
                OfficeThingsUsedSql.AppendLine(",EmployeeID   ");
                OfficeThingsUsedSql.AppendLine(",DeptID  ");
                OfficeThingsUsedSql.AppendLine(",UsedDate    ");
                OfficeThingsUsedSql.AppendLine(",CountTotal    ");
                OfficeThingsUsedSql.AppendLine(",BillStatus    ");
                OfficeThingsUsedSql.AppendLine(",Creator    ");
                OfficeThingsUsedSql.AppendLine(",CreateDate");
                OfficeThingsUsedSql.AppendLine(",Remark");
                OfficeThingsUsedSql.AppendLine(",ModifiedDate");
                OfficeThingsUsedSql.AppendLine(",ModifiedUserID)");
                OfficeThingsUsedSql.AppendLine(" values ");
                OfficeThingsUsedSql.AppendLine("(@CompanyCD");
                OfficeThingsUsedSql.AppendLine(",@ApplyNo     ");
                OfficeThingsUsedSql.AppendLine(",@Title");
                OfficeThingsUsedSql.AppendLine(",@EmployeeID   ");
                OfficeThingsUsedSql.AppendLine(",@DeptID  ");
                OfficeThingsUsedSql.AppendLine(",@UsedDate    ");
                OfficeThingsUsedSql.AppendLine(",@CountTotal    ");
                OfficeThingsUsedSql.AppendLine(",@BillStatus    ");
                OfficeThingsUsedSql.AppendLine(",@Creator    ");
                OfficeThingsUsedSql.AppendLine(",@CreateDate");
                OfficeThingsUsedSql.AppendLine(",@Remark");
                OfficeThingsUsedSql.AppendLine(",@ModifiedDate");
                OfficeThingsUsedSql.AppendLine(",@ModifiedUserID)");
                #endregion

                #region 设置参数
                SqlParameter[] paramgas = new SqlParameter[13];
                paramgas[0] = SqlHelper.GetParameter("@CompanyCD", OfficeThingsUsedM.CompanyCD);
                paramgas[1] = SqlHelper.GetParameter("@ApplyNo", OfficeThingsUsedM.ApplyNo);
                paramgas[2] = SqlHelper.GetParameter("@Title", OfficeThingsUsedM.Title);
                paramgas[3] = SqlHelper.GetParameter("@EmployeeID", OfficeThingsUsedM.EmployeeID);
                paramgas[4] = SqlHelper.GetParameter("@DeptID", OfficeThingsUsedM.DeptID);
                paramgas[5] = SqlHelper.GetParameter("@UsedDate", OfficeThingsUsedM.UsedDate);
                paramgas[6] = SqlHelper.GetParameter("@CountTotal", OfficeThingsUsedM.CountTotal);
                paramgas[7] = SqlHelper.GetParameter("@BillStatus", OfficeThingsUsedM.BillStatus);
                paramgas[8] = SqlHelper.GetParameter("@Creator", OfficeThingsUsedM.Creator);
                paramgas[9] = SqlHelper.GetParameter("@CreateDate", OfficeThingsUsedM.CreateDate);
                paramgas[10] = SqlHelper.GetParameter("@Remark", OfficeThingsUsedM.Remark);
                paramgas[11] = SqlHelper.GetParameter("@ModifiedDate", OfficeThingsUsedM.ModifiedDate);
                paramgas[12] = SqlHelper.GetParameter("@ModifiedUserID", OfficeThingsUsedM.ModifiedUserID);
                #endregion
                return InsertAll(OfficeThingsUsedSql.ToString(), OfficeThingsUsedInfos, OfficeThingsUsedM.ApplyNo, OfficeThingsUsedM.CompanyCD, OfficeThingsUsedM.ModifiedUserID, paramgas);
            }
            catch
            {
                return false;
            }
        }
        /// <summary>
        /// 用品领用确认
        /// </summary>
        /// <param name="OfficeThingsUsedM">领用单主信息</param>
        /// <param name="OfficeThingsUsedInfos">领用单详细信息</param>
        /// <returns>确认是否成功 false:失败,true:成功</returns>
        public static bool ConfirmUsedInfo(OfficeThingsUsedModel OfficeThingsUsedM, string OfficeThingsUsedInfos)
        {
            try
            {
                #region 添加入库库存信息sql语句
                StringBuilder OfficeThingsUsedSql = new StringBuilder();
                OfficeThingsUsedSql.AppendLine("Update officedba.OfficeThingsUsed");
                OfficeThingsUsedSql.AppendLine("SET BillStatus=@BillStatus");
                OfficeThingsUsedSql.AppendLine(",Confirmor=@Confirmor     ");
                OfficeThingsUsedSql.AppendLine(",ConfirmDate=@ConfirmDate     ");
                OfficeThingsUsedSql.AppendLine(",ModifiedDate=@ModifiedDate");
                OfficeThingsUsedSql.AppendLine(",ModifiedUserID=@ModifiedUserID");
                OfficeThingsUsedSql.AppendLine("  WHERE  ApplyNo=@ApplyNo AND CompanyCD=@CompanyCD");
                #endregion

                #region 设置参数
                SqlParameter[] paramgas = new SqlParameter[7];
                paramgas[0] = SqlHelper.GetParameter("@BillStatus", OfficeThingsUsedM.BillStatus);
                paramgas[1] = SqlHelper.GetParameter("@Confirmor", OfficeThingsUsedM.Confirmor);
                paramgas[2] = SqlHelper.GetParameter("@ConfirmDate", OfficeThingsUsedM.ConfirmDate);
                paramgas[3] = SqlHelper.GetParameter("@ModifiedDate", OfficeThingsUsedM.ModifiedDate);
                paramgas[4] = SqlHelper.GetParameter("@ModifiedUserID", OfficeThingsUsedM.ModifiedUserID);
                paramgas[5] = SqlHelper.GetParameter("@ApplyNo", OfficeThingsUsedM.ApplyNo);
                paramgas[6] = SqlHelper.GetParameter("@CompanyCD", OfficeThingsUsedM.CompanyCD);
                #endregion
                return ConfirmAll(OfficeThingsUsedSql.ToString(), OfficeThingsUsedInfos, OfficeThingsUsedM.ApplyNo, OfficeThingsUsedM.CompanyCD, OfficeThingsUsedM.ModifiedUserID, paramgas);
            }
            catch
            {
                return false;
            }
        }
        /// <summary>
        /// 修改用品领用单信息
        /// </summary>
        /// <param name="OfficeThingsBuyM">领用单主信息</param>
        /// <param name="OfficeThingsUsedInfos">领用单详细信息</param>
        /// <returns>添加是否成功 false:失败,true:成功</returns>
        public static bool UpdateOfficeThingsUsedInfo(OfficeThingsUsedModel OfficeThingsUsedM, string OfficeThingsUsedInfos)
        {
            try
            {
                #region 添加领用单存信息sql语句
                StringBuilder OfficeThingsUsedSql = new StringBuilder();
                OfficeThingsUsedSql.AppendLine("UPDATE officedba.OfficeThingsUsed");
                OfficeThingsUsedSql.AppendLine(" SET Title=@Title");
                OfficeThingsUsedSql.AppendLine(",EmployeeID=@EmployeeID   ");
                OfficeThingsUsedSql.AppendLine(",DeptID=@DeptID  ");
                OfficeThingsUsedSql.AppendLine(",UsedDate=@UsedDate    ");
                OfficeThingsUsedSql.AppendLine(",CountTotal=@CountTotal    ");
                OfficeThingsUsedSql.AppendLine(",BillStatus=@BillStatus    ");
                OfficeThingsUsedSql.AppendLine(",Remark=@Remark");
                OfficeThingsUsedSql.AppendLine(",ModifiedDate=@ModifiedDate");
                OfficeThingsUsedSql.AppendLine(",ModifiedUserID=@ModifiedUserID");
                OfficeThingsUsedSql.AppendLine(" WHERE  CompanyCD=@CompanyCD AND ApplyNo=@ApplyNo");
                #endregion

                #region 设置参数
                SqlParameter[] paramgas = new SqlParameter[11];
                paramgas[0] = SqlHelper.GetParameter("@Title", OfficeThingsUsedM.Title);
                paramgas[1] = SqlHelper.GetParameter("@EmployeeID", OfficeThingsUsedM.EmployeeID);
                paramgas[2] = SqlHelper.GetParameter("@DeptID", OfficeThingsUsedM.DeptID);
                paramgas[3] = SqlHelper.GetParameter("@UsedDate", OfficeThingsUsedM.UsedDate);
                paramgas[4] = SqlHelper.GetParameter("@CountTotal", OfficeThingsUsedM.CountTotal);
                paramgas[5] = SqlHelper.GetParameter("@BillStatus", OfficeThingsUsedM.BillStatus);
                paramgas[6] = SqlHelper.GetParameter("@Remark", OfficeThingsUsedM.Remark);
                paramgas[7] = SqlHelper.GetParameter("@ModifiedDate", OfficeThingsUsedM.ModifiedDate);
                paramgas[8] = SqlHelper.GetParameter("@ModifiedUserID", OfficeThingsUsedM.ModifiedUserID);
                paramgas[9] = SqlHelper.GetParameter("@CompanyCD", OfficeThingsUsedM.CompanyCD);
                paramgas[10] = SqlHelper.GetParameter("@ApplyNo", OfficeThingsUsedM.ApplyNo);
                #endregion
                return UpdateAll(OfficeThingsUsedSql.ToString(), OfficeThingsUsedInfos, OfficeThingsUsedM.ApplyNo, OfficeThingsUsedM.CompanyCD, OfficeThingsUsedM.ModifiedUserID, paramgas);
            }
            catch
            {
                return false;
            }
        }
 /// <summary>
 /// 用品领用确认
 /// </summary>
 /// <param name="OfficeThingsUsedM">领用单主信息</param>
 /// <param name="OfficeThingsUsedInfos">领用单详细信息</param>
 /// <returns>确认是否成功 false:失败,true:成功</returns>
 public static bool ConfirmUsedInfo(OfficeThingsUsedModel OfficeThingsUsedM,string OfficeThingsUsedInfos)
 {
     return OfficeThingsUsedDBHelper.ConfirmUsedInfo(OfficeThingsUsedM, OfficeThingsUsedInfos);
 }
 /// <summary>
 /// 修改用品领用单信息
 /// </summary>
 /// <param name="OfficeThingsBuyM">领用单主信息</param>
 /// <param name="OfficeThingsUsedInfos">领用单详细信息</param>
 /// <returns>添加是否成功 false:失败,true:成功</returns>
 public static bool UpdateOfficeThingsUsedInfo(OfficeThingsUsedModel OfficeThingsUsedM, string OfficeThingsUsedInfos)
 {
     return OfficeThingsUsedDBHelper.UpdateOfficeThingsUsedInfo(OfficeThingsUsedM, OfficeThingsUsedInfos);
 }
 /// <summary>
 /// 添加办公用品领用信息
 /// </summary>
 /// <param name="OfficeThingsUsedM">领用单主信息</param>
 /// <param name="OfficeThingsUsedInfos">领用详细信息</param>
 /// <returns>添加是否成功 false:失败,true:成功</returns>
 public static bool InserOfficeThingsUsedInfo(OfficeThingsUsedModel OfficeThingsUsedM, string OfficeThingsUsedInfos)
 {
     return OfficeThingsUsedDBHelper.InserOfficeThingsUsedInfo(OfficeThingsUsedM, OfficeThingsUsedInfos);
 }