/// <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);
}
