/// <summary> /// 删除数据 /// </summary> /// <returns></returns> public bool DeleteData(MemberList_StaticStru objstru) { string errorMsg; SqliteAccess conn = new SqliteAccess(DBLink); string str = string.Format("delete from MemberList_Static where id='{0}'", objstru.ID); int count = conn.Execute(str, out errorMsg); if (count > 0) { return(true); } else { return(false); } }
/// <summary> /// 接收前端传递来的,待修改页面数据,原样返回 /// </summary> /// <param name="username"></param> /// <param name="sex"></param> /// <param name="tel"></param> /// <param name="addr"></param> /// <param name="Static"></param> /// <returns></returns> public IActionResult MemberEdit(string username, string sex, string tel, string addr, string states) { MemberList_StaticStru MemberList_Static = new MemberList_StaticStru(); MemberList_Static.username = username; MemberList_Static.sex = sex; MemberList_Static.tel = tel; MemberList_Static.addr = addr; MemberList_Static.states = states; var resultModel = new MemberList_StaticViewModel { memberlist_static = MemberList_Static }; return(View(resultModel)); }
/// <summary> /// 编辑数据 /// </summary> /// <returns></returns> public bool UpdateData(MemberList_StaticStru objstru) { string errorMsg; SqliteAccess conn = new SqliteAccess(DBLink); string str = string.Format("update MemberList_Static set sex = '{0}', tel = '{1}', addr = '{2}', states = '{3}' where username='******'", objstru.sex, objstru.tel, objstru.addr, objstru.states, objstru.username); int count = conn.Execute(str, out errorMsg); if (count > 0) { return(true); } else { return(false); } }
/// <summary> /// 新增数据 /// </summary> /// <returns></returns> public bool AddData(MemberList_StaticStru objstru) { string errorMsg; SqliteAccess conn = new SqliteAccess(DBLink); string str = string.Format("insert into MemberList_Static (username,sex,tel,addr,states) values('{0}','{1}','{2}','{3}','{4}')", objstru.username, objstru.sex, objstru.tel, objstru.addr, objstru.states); int count = conn.Execute(str, out errorMsg); if (count > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除数据,delete /// </summary> /// <param name="id"></param> /// <param name="username"></param> /// <returns></returns> public bool Delete(string id, string username) { MemberList_StaticStru MemberList_StaticStru = new MemberList_StaticStru(); MemberList_StaticStru.ID = Convert.ToInt32(id); MemberList_StaticStru.username = username; MemberList_StaticViewModel dataInfo = new MemberList_StaticViewModel(); if (dataInfo.DeleteData(MemberList_StaticStru)) { return(true); } else { return(false); } }
/// <summary> /// 新增数据,add /// </summary> /// <param name="username"></param> /// <param name="sex"></param> /// <param name="tel"></param> /// <param name="addr"></param> /// <param name="Static"></param> /// <returns></returns> public bool Add(string username, string sex, string tel, string addr, string states) { MemberList_StaticStru MemberList_StaticStru = new MemberList_StaticStru(); MemberList_StaticStru.username = username; MemberList_StaticStru.sex = sex; MemberList_StaticStru.tel = tel; MemberList_StaticStru.addr = addr; MemberList_StaticStru.states = states; MemberList_StaticViewModel dataInfo = new MemberList_StaticViewModel(); if (dataInfo.AddData(MemberList_StaticStru)) { return(true); } else { return(false); } }
/// <summary> /// 查询数据 /// </summary> /// <returns></returns> public List <MemberList_StaticStru> GetDate(CommConf options) { string errorMsg; DBLink = options.AttriList.FirstOrDefault(o => o.key == "DBLink").value; SqliteAccess conn = new SqliteAccess(DBLink); DataTable dt = conn.QueryDt("select * from MemberList_Static order by ID", out errorMsg); MemberList_StaticStru obj = new MemberList_StaticStru(); dataInfoList = new List <MemberList_StaticStru>(); foreach (DataRow item in dt.Rows) { obj = new MemberList_StaticStru(); obj.ID = int.Parse(item["id"].ToString()); obj.username = item["username"].ToString(); obj.sex = item["sex"].ToString(); obj.tel = item["tel"].ToString(); obj.addr = item["addr"].ToString(); obj.states = item["states"].ToString(); dataInfoList.Add(obj); } return(dataInfoList); }
/// <summary> /// 搜索 /// </summary> /// <param name="options"></param> /// <returns></returns> public List <MemberList_StaticStru> GetDateSreach(CommConf options, ref Dictionary <string, string> sqlDic) { string errorMsg; DBLink = options.AttriList.FirstOrDefault(o => o.key == "DBLink").value; SqliteAccess conn = new SqliteAccess(DBLink); string sql = string.Format("select * from MemberList_Static {0} order by ID asc", CommonMethod.SqlStrWithTime(sqlDic)); DataTable dt = conn.QueryDt(sql, out errorMsg); MemberList_StaticStru obj = new MemberList_StaticStru(); dataInfoList = new List <MemberList_StaticStru>(); foreach (DataRow item in dt.Rows) { obj = new MemberList_StaticStru(); obj.ID = int.Parse(item["id"].ToString()); obj.username = item["username"].ToString(); obj.sex = item["sex"].ToString(); obj.tel = item["tel"].ToString(); obj.addr = item["addr"].ToString(); obj.states = item["states"].ToString(); dataInfoList.Add(obj); } return(dataInfoList); }