コード例 #1
0
 public int AddBsUser(BsUser bsUser)
 {
     return(bsUserDAL.AddBsUser(bsUser));
 }
コード例 #2
0
 public int EditBsUser(BsUser bsUser)
 {
     return(bsUserDAL.EditBsUser(bsUser));
 }
コード例 #3
0
 /// <summary>
 /// 新增数据
 /// </summary>
 /// <param name="model">实体</param>
 /// <returns>系统编号</returns>
 public int Insert(BsUser model)
 {
     return(DBContext.Insert("Agent_BsUser", model)
            .AutoMap(x => x.SysNo)
            .ExecuteReturnLastId <int>("SysNo"));
 }
コード例 #4
0
        public string Get_NextDoctByDept(string json)
        {
            Back <Oudayschedule> back = new Back <Oudayschedule>();
            string msg = "";
            string xml = "";

            try
            {
                int      deptid = Convert.ToInt32(JsonHelper.GetVluesParentstr(json, "deptid"));
                DateTime today, endtoday, nextst, nextend;

                today    = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd 00:00:00"));
                endtoday = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd 23:59:59"));
                var nextday = today.AddDays(Convert.ToInt32(1 - Convert.ToInt32(today.DayOfWeek)) + 7);
                nextst = CommUtil.GetTimeStartByType("Week", nextday);
                var nextendday = endtoday.AddDays(Convert.ToInt32(1 - Convert.ToInt32(endtoday.DayOfWeek)) + 7);
                nextend = CommUtil.GetTimeEndByType("Week", nextendday);

                DataTable            doct = bll.QueryDoctByDept(deptid, nextst, nextend);
                List <Oudayschedule> list = new List <Oudayschedule>();
                if (doct == null || doct.Rows.Count == 0)
                {
                    //提示无挂号医生
                    back.errcode = 0;
                    back.errmsg  = "暂无可挂号医生";
                    back.data    = new List <Oudayschedule>();
                }
                else
                {
                    int mainNum = doct.Rows.Count;

                    foreach (DataRow row in doct.Rows)
                    {
                        Oudayschedule days = new Oudayschedule();
                        BsUser        user = new BsUser();
                        user.doctorid = Convert.ToInt32(row["id"]);
                        user.name     = row["docname"].ToString();
                        user.deptid   = Convert.ToInt32(row["deptid"]);
                        user.deptname = row["deptname"].ToString();
                        user.docgra   = row["docgra"].ToString();
                        user.price    = Convert.ToDouble(row["price"]);
                        user.resume   = row["resume"].ToString();
                        user.picture  = row["picture"].ToString();
                        days.user     = user;
                        DataTable        datalist = bll.QuerySchBydoct(user.doctorid, nextst, nextend);
                        List <Schdatecs> dates    = new List <Schdatecs>();
                        foreach (DataRow rw in datalist.Rows)
                        {
                            Schdatecs sch = new Schdatecs();
                            //sch.id = Convert.ToInt32(rw["id"]);
                            sch.scheduledate = Convert.ToDateTime(rw["scheduledate"]).ToString("MM-dd");
                            sch.week         = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetDayName(Convert.ToDateTime(rw["scheduledate"]).DayOfWeek);
                            dates.Add(sch);
                        }
                        days.list = dates;
                        list.Add(days);
                    }
                    back.errcode = 0;
                    back.errmsg  = "";
                    xml          = JsonHelper.getJsonByObject((Object)list);
                    back.data    = list;
                }
            }
            catch (Exception ex)
            {
                back.errcode = -1;
                back.errmsg  = ex.Message;
                back.data    = new List <Oudayschedule>();
            }
            msg = JsonHelper.getJsonByObject((Object)back);

            return(msg);
        }
コード例 #5
0
ファイル: BsUserDAL.cs プロジェクト: flzzyf/BookHorse_24
    public int AddBsUser(BsUser bsUser)
    {
        string sql = String.Format("insert into BsUser(username,password,realname,email,phone,address,zipcode) values('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}')", bsUser.Username, bsUser.Password, bsUser.Realname, bsUser.Email, bsUser.Phone, bsUser.Address, bsUser.Zipcode);

        return(SqlHelper.ExecuteNonQuery(sql));
    }
コード例 #6
0
ファイル: BsUserDAL.cs プロジェクト: flzzyf/BookHorse_24
    public int EditBsUser(BsUser bsUser)
    {
        string sql = String.Format("update BsUser set username='******',password='******',realname='{2}',email='{3}',phone='{4}',address='{5}',ipcode='{6}',role={7} where id={8}", bsUser.Username, bsUser.Password, bsUser.Realname, bsUser.Email, bsUser.Phone, bsUser.Address, bsUser.Role, bsUser.Zipcode, bsUser.ID);

        return(SqlHelper.ExecuteNonQuery(sql));
    }