Пример #1
0
        public JsonResult Order_TD(string str)
        {
            BLL.OrderInfoBLL _BLL = new OrderInfoBLL();
            retValue         ret  = new retValue();
            JObject          o    = null;

            PMS.Models.UserModel userModel = Session["UserModel"] as PMS.Models.UserModel;
            int userid = userModel._ID;

            if (!string.IsNullOrEmpty(str))
            {
                o = JObject.Parse(str);
                string ids        = o["ID"]._ToStrTrim();
                int    Month      = o["Month"]._ToInt32();
                int    OrderNum   = o["OrderNum"]._ToInt32();
                int    Group_Type = o["Group_Type"]._ToInt32();
                //1全退,2部分退
                if (Group_Type == 1)
                {
                    Month    = 0;
                    OrderNum = 0;
                }
                ret = _BLL.TD(ids.Remove(ids.Length - 1), userid, Group_Type, Month, OrderNum);
            }
            var js = JsonConvert.SerializeObject(ret);

            return(Json(js, JsonRequestBehavior.AllowGet));
        }
Пример #2
0
        /// <summary>
        /// 用户登录
        /// </summary>
        /// <param name="UserNo">用户编号</param>
        /// <param name="password">密码</param>
        /// <returns>返回验证结果</returns>
        public retValue Login(string UserNo, string password)
        {
            retValue ret = new retValue();

            ret = dal.Login(UserNo, password);
            return(ret);
        }
Пример #3
0
        public ActionResult OrgInfo_AddEdit()
        {
            string          ID         = Request["ID"]._ToStrTrim();
            string          ParentID   = Request["ParentID"]._ToStrTrim();
            List <retValue> resultList = new List <retValue>();

            //如果修改则传ID,新增则传上级ID
            if (!string.IsNullOrEmpty(ID))
            {
                retValue ret = new retValue();
                ret.result = true;
                ret.data   = "修改";
                resultList.Add(ret);
                BLL.OrgInfoBLL _OrgInfoBLL = new OrgInfoBLL();
                ret = _OrgInfoBLL.GetOrgByPK(ID._ToInt32());
                resultList.Add(ret);
                ViewData.Model = resultList;
            }
            else if (!string.IsNullOrEmpty(ParentID))
            {
                retValue ret = new retValue();
                ret.result = false;
                ret.data   = ParentID;
                resultList.Add(ret);
                ViewData.Model = resultList;
            }
            else
            {
                ViewData.Model = null;
            }
            return(View());
        }
Пример #4
0
        public retValue GetCostRecords(int id, string state, int orderid, string OrderNo, string unitname, int UserOrgID = 0)
        {
            retValue _retValue = new retValue();

            try
            {
                _retValue.result = true;

                DataTable tj = dal.GetCount(id, state, orderid, OrderNo, unitname, UserOrgID);
                if (tj.Rows.Count > 0 && tj != null)
                {
                    _retValue.data = "总订购月数:" + tj.Rows[0]["OrderMonths"]._ToInt32() + ",总订购份数:" + tj.Rows[0]["OrderNum"]._ToInt32() + ",总价:" + tj.Rows[0]["Money"]._ToDecimal() + ",已缴费用:" + tj.Rows[0]["MoneyPayed"]._ToDecimal();
                }
                else
                {
                    _retValue.data = "总订购数:0;总订购月:0;订购总价:0;已缴总额:0";
                }
            }
            catch (Exception ex)
            {
                _retValue.result = false;
                _retValue.reason = ex.Message;
            }
            return(_retValue);
        }
Пример #5
0
        public JsonResult Check_FF(string str)
        {
            retValue ret = new retValue();

            BLL.DistributeBLL _BLL = new DistributeBLL();
            JObject           o    = null;

            if (!string.IsNullOrEmpty(str))
            {
                o = JObject.Parse(str);
                string nianjuanqi = o["nianjuanqi"]._ToStrTrim();
                string action     = o["action"]._ToStrTrim();
                //日志类型,0表示市,1表示县
                int type = 0;
                if (action == "area")
                {
                    type = 1;
                }
                string ids = o["ids"]._ToStrTrim();
                if (_BLL.count(ids, type, nianjuanqi) > 0)
                {
                    ret.result = false;
                    ret.reason = "1000";
                }
                else
                {
                    ret.result = true;
                    ret.data   = "";
                }
            }
            var js = JsonConvert.SerializeObject(ret);

            return(Json(js, JsonRequestBehavior.AllowGet));
        }
Пример #6
0
        public JsonResult DocInfos(string str)
        {
            retValue ret = new retValue();

            BLL.DocBLL _DocBLL = new DocBLL();

            JObject o = null;

            string content = string.Empty;

            if (!string.IsNullOrEmpty(str))
            {
                o = JObject.Parse(str);

                string test1       = o["test1"]._ToStrTrim();
                string test2       = o["test2"]._ToStrTrim();
                string Type        = o["Type"]._ToStrTrim();
                string Name        = o["Name"]._ToStrTrim();
                string ISSN        = o["ISSN"]._ToStrTrim();
                string BKDH        = o["BKDH"]._ToStrTrim().ToUpper();
                string PublishArea = o["PublishArea"]._ToStrTrim();
                ret = _DocBLL.GetDoc("", Type, Name, ISSN, PublishArea, "", "", test1, test2, BKDH);
            }
            content = ret.toJson();

            var js = JsonConvert.SerializeObject(ret);

            return(Json(js, JsonRequestBehavior.AllowGet));
        }
Пример #7
0
        public JsonResult DistributeLog_FF(string str)
        {
            retValue ret = new retValue();

            BLL.DistributeBLL _BLL = new DistributeBLL();
            JObject           o    = null;

            if (!string.IsNullOrEmpty(str))
            {
                o = JObject.Parse(str);
                UserModel userModel  = Session["userModel"] as UserModel;
                string    nianjuanqi = o["nianjuanqi"]._ToStrTrim();
                string    action     = o["action"]._ToStrTrim();
                //日志类型,0表示市,1表示县
                int type = 0;
                if (action == "area")
                {
                    type = 1;
                }
                string ids = o["ids"]._ToStrTrim();
                ret = _BLL.insertLog(ids, nianjuanqi, userModel._ID, type);
            }
            var js = JsonConvert.SerializeObject(ret);

            return(Json(js, JsonRequestBehavior.AllowGet));
        }
Пример #8
0
        public JsonResult Order_Deletes(string str)
        {
            BLL.OrderInfoBLL _BLL = new OrderInfoBLL();
            retValue         ret  = new retValue();

            string    content = string.Empty;
            DataTable dt      = str.ToTable();
            string    ids     = "";
            string    costs   = "";

            foreach (DataRow item in dt.Rows)
            {
                if (!string.IsNullOrEmpty(item["ID"]._ToStrTrim()))
                {
                    ids   += item["ID"]._ToStrTrim() + ",";
                    costs += item["CostID"]._ToStrTrim() + ",";
                }
            }
            ret = _BLL.DeleteByPK(ids.Remove(ids.Length - 1));
            if (ret.result)
            {
                CostBLL costBLL = new CostBLL();
                costBLL.DeleteByPK(costs);
            }
            content = ret.toJson();
            var js = JsonConvert.SerializeObject(ret);

            return(Json(js, JsonRequestBehavior.AllowGet));
        }
Пример #9
0
        public retValue GetCount(string BKDH, string orgid, string userorg, string Group_Type, string dt1, bool area = false)
        {
            retValue pg = new retValue();

            try
            {
                DataTable tj = _dal.GetCount(BKDH, orgid, userorg, Group_Type, dt1, area);
                if (tj.Rows.Count > 0 && tj != null)
                {
                    pg.result = true;
                    pg.data   = "总份数:" + tj.Rows[0]["OrderNum"]._ToInt32();
                }
                else
                {
                    pg.result = true;
                    pg.reason = "未能查询出数据,不能统计";
                }
            }
            catch (Exception ex)
            {
                pg.result = false;
                pg.reason = ex.Message;
            }
            return(pg);
        }
Пример #10
0
        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="OrderNo">公司编号</param>
        /// <param name="UnitName">单位名称</param>
        /// <param name="name">负责人名称</param>
        /// <param name="phone">联系方式</param>
        /// <param name="address">地址</param>
        /// <param name="OrgID">所属网点</param>
        /// <param name="InUser">录入人</param>
        /// <returns>成功返回空值,否则返回提示</returns>
        public retValue Insert(string OrderNo, string UnitName, string name, string phone,
                               string address, string OrgID, int InUser)
        {
            retValue ret = new retValue();

            ret = dal.Insert(OrderNo, UnitName, name, phone, address, OrgID, InUser);
            return(ret);
        }
Пример #11
0
        public JsonResult GetAllDocInfo(string str)
        {
            retValue ret = new retValue();

            BLL.DocBLL _BLL = new DocBLL();
            ret = _BLL.GetDoc(str, "", "", "", "", "", "", "", "", "");
            var js = JsonConvert.SerializeObject(ret);

            return(Json(js, JsonRequestBehavior.AllowGet));
        }
Пример #12
0
        public JsonResult GetPosters()
        {
            retValue  ret  = new retValue();
            UserModel user = Session["UserModel"] as UserModel;

            BLL.UserBLL _BLL = new UserBLL();
            ret.result = true;
            ret.data   = _BLL.GetPosters(user.OrgID._ToStr());
            var js = JsonConvert.SerializeObject(ret);

            return(Json(js, JsonRequestBehavior.AllowGet));
        }
Пример #13
0
        public JsonResult UserLoginOut(string str)
        {
            retValue ret = new retValue();

            Session["UserModel"] = null;
            ret.result           = true;
            ret.data             = "NEEDLOGIN";
            UserModel.needlogin  = true;
            var js = JsonConvert.SerializeObject(ret);

            return(Json(js, JsonRequestBehavior.AllowGet));
        }
Пример #14
0
        public JsonResult OrgInfos(string str)
        {
            retValue ret = new retValue();

            BLL.OrgInfoBLL _BLL = new OrgInfoBLL();
            UserModel      user = Session["UserModel"] as UserModel;

            ret = _BLL.GetOrgByParentID(str._ToInt32(), user.OrgID, user.Level);
            var js = JsonConvert.SerializeObject(ret);

            return(Json(js, JsonRequestBehavior.AllowGet));
        }
Пример #15
0
        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="OrderNo">公司编号</param>
        /// <param name="UnitName">单位名称</param>
        /// <param name="name">负责人名称</param>
        /// <param name="phone">联系方式</param>
        /// <param name="address">地址</param>
        /// <param name="OrgID">所属网点</param>
        /// <param name="InUser">录入人</param>
        /// <returns></returns>
        public retValue Insert(string OrderNo, string UnitName, string name, string phone,
                               string address, string OrgID, int InUser)
        {
            retValue ret = new retValue();
            string   res = "";

            try
            {
                res = check(OrderNo);
                if (!string.IsNullOrEmpty(res))
                {
                    ret.result = false;
                    ret.reason = res;
                    return(ret);
                }
                string       sql  = @" insert into OrderPeople(OrderNo,UnitName,name,phone,address,OrgID,InUser) 
values(@OrderNo,@UnitName,@name,@phone,@address,@OrgID,@InUser) ";
                SqlParameter Para = null;
                Para = new SqlParameter("OrderNo", OrderNo._ToStrTrim().ToUpper());
                dbhelper.SqlParameterList.Add(Para);
                Para = new SqlParameter("UnitName", UnitName._ToStrTrim().ToUpper());
                dbhelper.SqlParameterList.Add(Para);
                Para = new SqlParameter("name", name._ToStrTrim().ToUpper());
                dbhelper.SqlParameterList.Add(Para);
                Para = new SqlParameter("phone", phone._ToStrTrim());
                dbhelper.SqlParameterList.Add(Para);
                Para = new SqlParameter("address", address._ToStrTrim());
                dbhelper.SqlParameterList.Add(Para);
                Para = new SqlParameter("OrgID", OrgID._ToInt32());
                dbhelper.SqlParameterList.Add(Para);
                Para = new SqlParameter("InUser", InUser._ToInt32());
                dbhelper.SqlParameterList.Add(Para);
                int num = dbhelper.ExecuteInsert(sql);
                if (num == 0)
                {
                    ret.result = false;
                    res        = "操作失败";
                }
                else
                {
                    ret.result = true;
                    ret.data   = num;
                }
            }
            catch (Exception ex)
            {
                ret.result = false;
                res        = ex.Message;
            }
            ret.reason = res;
            return(ret);
        }
Пример #16
0
        public ActionResult Order_getCounts(string str)
        {
            retValue ret = new retValue();

            PMS.Models.UserModel userModel = Session["UserModel"] as PMS.Models.UserModel;
            int userid = userModel._ID;

            BLL.OrderInfoBLL _BLL = new OrderInfoBLL();
            JObject          o    = null;

            if (!string.IsNullOrEmpty(str))
            {
                o = JObject.Parse(str);

                string test1            = o["test1"]._ToStrTrim();
                string test2            = o["test2"]._ToStrTrim();
                string Province         = o["Province"]._ToStrTrim();
                string CompanyCity      = o["CompanyCity"]._ToStrTrim();
                string CompanyUnderCity = o["CompanyUnderCity"]._ToStrTrim();
                string CompanyUnderArea = o["CompanyUnderArea"]._ToStrTrim();
                string OrderNo          = o["OrderNo"]._ToStrTrim();
                string UnitName         = o["UnitName"]._ToStrTrim();
                string BKDH             = o["BKDH"]._ToStrTrim();
                string OrderState       = o["OrderState"]._ToStrTrim();
                string CostState        = o["CostState"]._ToStrTrim();
                string OrgID            = "";
                if (Province._ToInt32() > 0)
                {
                    OrgID = Province;
                }
                if (CompanyCity._ToInt32() > 0)
                {
                    OrgID = CompanyCity;
                }
                if (CompanyUnderCity._ToInt32() > 0)
                {
                    OrgID = CompanyUnderCity;
                }
                if (CompanyUnderArea._ToInt32() > 0)
                {
                    OrgID = CompanyUnderArea;
                }
                PageModel pg = _BLL.GetCount(0, BKDH, OrderNo, UnitName, test1, test2,
                                             userModel.OrgID._ToStr(), OrgID, OrderState, CostState);
                ret.result = true;
                ret.data   = pg.msg;
            }
            var js = JsonConvert.SerializeObject(ret);

            return(Json(js, JsonRequestBehavior.AllowGet));
        }
Пример #17
0
        public ActionResult Order_getCounts(string str)
        {
            retValue ret = new retValue();

            PMS.Models.UserModel userModel = Session["UserModel"] as PMS.Models.UserModel;
            int userid = userModel._ID;

            BLL.DistributeBLL _BLL = new DistributeBLL();
            JObject           o    = null;

            if (!string.IsNullOrEmpty(str))
            {
                o = JObject.Parse(str);

                string test1            = o["test1"]._ToStrTrim();
                string Group_Type       = o["Group_Type"]._ToStrTrim();
                string Province         = o["Province"]._ToStrTrim();
                string CompanyCity      = o["CompanyCity"]._ToStrTrim();
                string CompanyUnderCity = o["CompanyUnderCity"]._ToStrTrim();
                string CompanyUnderArea = o["CompanyUnderArea"]._ToStrTrim();
                string NewspaperName    = o["NewspaperName"]._ToStrTrim();
                string Roads            = o["Roads"]._ToStrTrim();
                string OrgID            = "";
                if (Province._ToInt32() > 0)
                {
                    OrgID = Province;
                }
                if (CompanyCity._ToInt32() > 0)
                {
                    OrgID = CompanyCity;
                }
                if (CompanyUnderCity._ToInt32() > 0)
                {
                    OrgID = CompanyUnderCity;
                }
                if (CompanyUnderArea._ToInt32() > 0)
                {
                    OrgID = CompanyUnderArea;
                }
                if (Roads._ToInt32() > 0)
                {
                    OrgID = Roads;
                }
                ret = _BLL.GetCount(NewspaperName, OrgID, userModel.OrgID._ToStr(), Group_Type, test1);
            }
            var js = JsonConvert.SerializeObject(ret);

            return(Json(js, JsonRequestBehavior.AllowGet));
        }
Пример #18
0
        public JsonResult UserInfo_AddEdits(string str)
        {
            retValue  ret  = new retValue();
            UserModel user = Session["UserModel"] as UserModel;

            BLL.UserBLL _UserBLL = new UserBLL();
            JObject     o        = null;

            if (!string.IsNullOrEmpty(str))
            {
                o = JObject.Parse(str);

                string ID               = o["ID"]._ToStrTrim();
                string MGUID            = o["MGUID"]._ToStrTrim();
                string USERNO           = o["USERNO"]._ToStrTrim();
                string NAME             = o["NAME"]._ToStrTrim();
                string Sex              = o["Sex"]._ToStrTrim();
                string Role             = o["Role"]._ToStrTrim();
                string Password         = o["Password"]._ToStrTrim();
                string IDCard           = o["IDCard"]._ToStrTrim();
                string PhoneNumber      = o["PhoneNumber"]._ToStrTrim();
                string Email            = o["Email"]._ToStrTrim();
                string Address          = o["Address"]._ToStrTrim();
                string Province         = o["Province"]._ToStrTrim();
                string CompanyCity      = o["CompanyCity"]._ToStrTrim();
                string CompanyUnderCity = o["CompanyUnderCity"]._ToStrTrim();
                string CompanyUnderArea = o["CompanyUnderArea"]._ToStrTrim();
                string State            = o["State"]._ToStrTrim();
                string OrgID            = CompanyUnderArea == "" ? (CompanyUnderCity == "" ?
                                                                    (CompanyCity == "" ?
                                                                     Province :
                                                                     CompanyCity) :
                                                                    CompanyUnderCity) :
                                          CompanyUnderArea;
                //新增
                if (string.IsNullOrEmpty(ID))
                {
                    ret = _UserBLL.Insert(USERNO, NAME, Sex, Role, OrgID, IDCard, Password, PhoneNumber, Address, Email, user._ID._ToStr(), user.Level);
                }
                //更新
                else
                {
                    ret = _UserBLL.UpdateByPK(ID._ToInt32(), USERNO, NAME, Sex, Role, OrgID, IDCard, State, MGUID, Email, PhoneNumber, Password);
                }
            }
            var js = JsonConvert.SerializeObject(ret);

            return(Json(js, JsonRequestBehavior.AllowGet));
        }
Пример #19
0
        /// <summary>
        /// 根据报刊编号更新数据
        /// </summary>
        /// <param name="ID">报刊编号</param>
        /// <param name="Name">名称</param>
        /// <param name="ISSN">ISSN</param>
        /// <param name="TypeID">类型ID</param>
        /// <param name="PublishArea">出版地</param>
        /// <param name="Publisher">出版社</param>
        /// <param name="PublishYear">出版年</param>
        /// <param name="C200F">责任者</param>
        /// <param name="Price">单价</param>
        /// <param name="PL">出版频率</param>
        /// <param name="BKDH">报刊代号</param>
        /// <param name="guid">唯一标识</param>
        /// <returns>成功返回空值,否则返回提示</returns>
        public retValue UpdateByPK(int ID, string Name, string ISSN, string TypeID, string PublishArea, string Publisher, string Price, string PL, string BKDH, string guid)
        {
            retValue ret = new retValue();
            string   res = dal.UpdateByPK(ID, Name, ISSN, TypeID, PublishArea, Publisher, Price, PL, BKDH, guid);

            if (string.IsNullOrEmpty(res))
            {
                ret.result = true; ret.data = "保存成功";
            }
            else
            {
                ret.result = false; ret.reason = res;
            }
            return(ret);
        }
Пример #20
0
        public JsonResult OrgInfo_Deletes(string str)
        {
            retValue ret = new retValue();

            BLL.OrgInfoBLL _BLL = new OrgInfoBLL();
            UserModel      user = Session["UserModel"] as UserModel;

            if (!string.IsNullOrEmpty(str))
            {
                ret = _BLL.DeleteByPK(str, user.Level);
            }
            var js = JsonConvert.SerializeObject(ret);

            return(Json(js, JsonRequestBehavior.AllowGet));
        }
Пример #21
0
        /// <summary>
        /// 根据主键删除数据
        /// </summary>
        /// <param name="IDs">主键,多个用英文逗号分隔</param>
        /// <returns>成功返回空值,否则返回提示</returns>
        public retValue DeleteByPK(string IDs)
        {
            retValue ret = new retValue();
            string   res = dal.DeleteByPK(IDs);

            if (string.IsNullOrEmpty(res))
            {
                ret.result = true; ret.data = "删除成功";
            }
            else
            {
                ret.result = false; ret.reason = res;
            }
            return(ret);
        }
Пример #22
0
        public retValue UpdateByPK(int ID, int months, int ordernum, string bkdh, int PersonID, int ModifyUser, int PosterID, string OrderDate, string guid = "")
        {
            retValue ret = new retValue();
            string   res = dal.update(ID, ordernum, months, guid, bkdh, PersonID, ModifyUser, PosterID, OrderDate);

            if (string.IsNullOrEmpty(res))
            {
                ret.result = true; ret.data = "保存成功";
            }
            else
            {
                ret.result = false; ret.reason = res;
            }

            return(ret);
        }
Пример #23
0
        public retValue TD(string ID, int ModifyUser, int type = 0, int months = 0, int OrderNum = 0)
        {
            retValue ret = new retValue();
            string   res = dal.TD(ID, ModifyUser, type, months, OrderNum);

            if (string.IsNullOrEmpty(res))
            {
                ret.result = true; ret.data = "退订成功";
            }
            else
            {
                ret.result = false; ret.reason = res;
            }

            return(ret);
        }
Пример #24
0
        public retValue UpdateByPK(int id, decimal money, decimal moneypayed, int userid)
        {
            retValue ret = new retValue();
            string   res = dal.update(id, money, moneypayed, userid);

            if (string.IsNullOrEmpty(res))
            {
                ret.result = true; ret.data = "保存成功";
            }
            else
            {
                ret.result = false; ret.reason = res;
            }

            return(ret);
        }
Пример #25
0
        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="ID">主键</param>
        /// <param name="OrderNo">公司编号</param>
        /// <param name="UnitName">单位名称</param>
        /// <param name="name">负责人名称</param>
        /// <param name="phone">联系方式</param>
        /// <param name="address">地址</param>
        /// <param name="OrgID">所属网点</param>
        /// <param name="guid"></param>
        /// <returns></returns>
        public retValue UpdateByPK(int ID, string OrderNo, string UnitName, string name, string phone,
                                   string address, string OrgID, string guid = "")
        {
            retValue ret = new retValue();
            string   res = dal.UpdateByPK(ID, OrderNo, UnitName, name, phone, address, OrgID, guid);

            if (string.IsNullOrEmpty(res))
            {
                ret.result = true; ret.data = "保存成功";
            }
            else
            {
                ret.result = false; ret.reason = res;
            }

            return(ret);
        }
Пример #26
0
        /// <summary>
        /// 插入用户
        /// </summary>
        /// <param name="userNo">用户编号</param>
        /// <param name="userName">名称</param>
        /// <param name="sex">性别,1男0女</param>
        /// <param name="userRole">角色</param>
        /// <param name="userOrg">用户所属机构</param>
        /// <param name="IDCard">证件号</param>
        /// <param name="Password">密码</param>
        /// <param name="PhoneNumber">电话</param>
        /// <param name="Address">地址</param>
        /// <param name="Email">邮箱</param>
        /// <param name="OPERATOR">操作者</param>
        /// <returns>成功返回空值,否则返回提示</returns>
        public retValue Insert(string userNo, string userName, string sex, string userRole, string chooseOrg,
                               string IDCard, string Password, string PhoneNumber, string Address, string Email, string OPERATOR, int userlevel)
        {
            retValue ret = new retValue();
            string   res = dal.Insert(userNo, userName, sex, userRole, chooseOrg,
                                      IDCard, Password, PhoneNumber, Address, Email, OPERATOR, userlevel);

            if (string.IsNullOrEmpty(res))
            {
                ret.result = true; ret.data = "保存成功";
            }
            else
            {
                ret.result = false; ret.reason = res;
            }
            return(ret);
        }
Пример #27
0
        /// <summary>
        /// 根据主键获取用户信息
        /// </summary>
        /// <param name="ID"></param>
        /// <returns>data为DataTable</returns>
        public retValue GetUserByPK(int ID)
        {
            retValue  ret = new retValue();
            DataTable dt  = dal.GetUserByPK(ID);

            if (dt != null && dt.Rows.Count > 0)
            {
                ret.result = true;
                ret.data   = dt;
            }
            else
            {
                ret.result = false;
                ret.reason = "未能查询到数据";
            }
            return(ret);
        }
Пример #28
0
        /// <summary>
        /// 根据用户编号更新数据
        /// </summary>
        /// <param name="ID">流水号</param>
        /// <param name="userNo">用户编号</param>
        /// <param name="userName">名称</param>
        /// <param name="sex">性别,1男0女</param>
        /// <param name="userRole">角色</param>
        /// <param name="userOrg">用户所属机构</param>
        /// <param name="IDCard">证件号</param>
        /// <param name="userState">状态(0有效,1无效)</param>
        /// <param name="guid">唯一标识,每次修改数据会同时修改此列</param>
        /// <returns>成功返回空值,否则返回提示</returns>
        public retValue UpdateByPK(int ID, string userNo, string userName, string sex, string userRole, string userOrg, string IDCard,
                                   string userState, string guid, string Email, string PhoneNumber, string Password = "")
        {
            retValue ret = new retValue();
            string   res = dal.UpdateByPK(ID, userNo, userName, sex, userRole, userOrg, IDCard, userState, guid, Email, PhoneNumber, Password);

            if (string.IsNullOrEmpty(res))
            {
                ret.result = true; ret.data = "保存成功";
            }
            else
            {
                ret.result = false; ret.reason = res;
            }

            return(ret);
        }
Пример #29
0
        /// <summary>
        /// 获取报刊信息
        /// </summary>
        /// <param name="ID">编号</param>
        /// <param name="TYPEID">类型编号</param>
        /// <param name="NAME">名称</param>
        /// <param name="ISSN">ISSN</param>
        /// <param name="PUBLISHAREA">出版地</param>
        /// <param name="PUBLISHER">出版社</param>
        /// <param name="ADDPERSON">添加人</param>
        /// <param name="DocRegData_Begin">新增报刊时间范围,起始值</param>
        /// <param name="DocRegData_End">新增报刊时间范围,截止值</param>
        /// <returns></returns>
        public retValue GetDoc(string ID, string TYPEID, string NAME, string ISSN, string PUBLISHAREA, string PUBLISHER, string ADDPERSON, string DocRegData_Begin, string DocRegData_End, string BKDH)
        {
            retValue  ret = new retValue();
            DataTable dt  = dal.GetDoc(ID, TYPEID, NAME, ISSN, PUBLISHAREA, PUBLISHER, ADDPERSON, DocRegData_Begin, DocRegData_End, BKDH);

            if (dt != null && dt.Rows.Count > 0)
            {
                ret.result = true;
                ret.data   = dt;
            }
            else
            {
                ret.result = false;
                ret.reason = "未能查询到数据";
            }
            return(ret);
        }
Пример #30
0
        /// <summary>
        /// 插入报刊
        /// </summary>
        /// <param name="Name">名称</param>
        /// <param name="ISSN">ISSN</param>
        /// <param name="TypeID">类型ID</param>
        /// <param name="PublishArea">出版地</param>
        /// <param name="Publisher">出版社</param>
        /// <param name="PublishYear">出版年</param>
        /// <param name="C200F">责任者</param>
        /// <param name="Price">单价,一个月的单价</param>
        /// <param name="PL">出版频率</param>
        /// <param name="BKDH">报刊代号</param>
        /// <param name="AddPerson">添加人</param>
        /// <returns>成功返回空值,否则返回提示</returns>
        public retValue Insert(string Name, string ISSN, string TypeID, string PublishArea,
                               string Publisher, string Price, string PL, string BKDH, string AddPerson)
        {
            retValue ret = new retValue();
            string   res = dal.Insert(Name, ISSN, TypeID, PublishArea,
                                      Publisher, Price, PL, BKDH, AddPerson);

            if (string.IsNullOrEmpty(res))
            {
                ret.result = true; ret.data = "操作成功";
            }
            else
            {
                ret.result = false; ret.reason = res;
            }
            return(ret);
        }