Пример #1
0
        /// <summary>
        /// 更新单位
        /// </summary>
        /// <param name="id">序号</param>
        /// <param name="unit">单位</param>
        /// <param name="spec">规格</param>
        /// <param name="isDisable">停用</param>
        /// <param name="returnUnit">单位信息</param>
        /// <param name="error">出错时返回错误信息,无错时返回null</param>
        /// <returns>返回是否成功更新单位信息</returns>
        public bool UpdateUnit(int id, string unit, string spec, bool isDisable, out IQueryable <View_S_Unit> returnUnit,
                               out string error)
        {
            error = null;

            DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;

            try
            {
                S_Unit unitObj = (from c in dataContxt.S_Unit
                                  where c.ID == id
                                  select c).Single();
                unitObj.UnitName  = unit;
                unitObj.UnitSpec  = spec;
                unitObj.IsDisable = isDisable;

                dataContxt.SubmitChanges();

                GetAllUnit(out returnUnit, out error);

                return(true);
            }
            catch (Exception err)
            {
                return(SetReturnError(err, out returnUnit, out error));
            }
        }
Пример #2
0
        /// <summary>
        /// 添加单位
        /// </summary>
        /// <param name="unit">单位</param>
        /// <param name="spec">单位规格</param>
        /// <param name="isDisable">停用</param>
        /// <param name="returnUnit">单位信息</param>
        /// <param name="error">出错时返回错误信息,无错时返回null</param>
        /// <returns>返回是否成功添加单位信息</returns>
        public bool AddUnit(string unit, string spec, bool isDisable, out IQueryable <View_S_Unit> returnUnit,
                            out string error)
        {
            error = null;

            DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;

            try
            {
                S_Unit unitObj = new S_Unit();

                unitObj.UnitName  = unit;
                unitObj.UnitSpec  = spec;
                unitObj.IsDisable = isDisable;

                dataContxt.S_Unit.InsertOnSubmit(unitObj);
                dataContxt.SubmitChanges();

                GetAllUnit(out returnUnit, out error);

                return(true);
            }
            catch (Exception err)
            {
                return(SetReturnError(err, out returnUnit, out error));
            }
        }