public bool update(Model.UserToRoleModel.usertorole usertorolemodel)
{
string sql = string.Format("role_id='{0}'", usertorolemodel.role);
string contion = string.Format("user_id='{0}'", usertorolemodel.user);
string tablename = typeof(QDDL.Model.UserToRoleModel.usertorole).Name;
return(ServerHelp.updateByWhere(tablename, _webip, contion, sql));
}
public bool update(Model.UserToRoleModel.usertorole usertorolemodel)
{
try
{
string strsql = string.Format(" role_id='{0}'", usertorolemodel.role);
string contation = string.Format("where user_id='{0}'", usertorolemodel.user);
string sql = "update usertorole set " + strsql + contation;
var ds = SqliteHelper.ExecuteNonQuery(con, sql, CommandType.Text);
if (Convert.ToInt32(ds) > 0)
{
return(true);
}
return(false);
}
catch { return(false); }
}
public bool add(Model.UserToRoleModel.usertorole usertorolemodel)
{
try
{
string sqldep = string.Format("select * from users where id='{0}'", usertorolemodel.user);
DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text);
if (dps != null && dps.Tables.Count > 0)
{
users dep = DataTableToList.GetList <users>(dps.Tables[0]).FirstOrDefault();
if (dep != null)
{
usertorolemodel.user = dep.guid;
}
}
string sqlduty = string.Format("select * from role where id='{0}'", usertorolemodel.role);
dps = SqliteHelper.ExecuteDataSet(con, sqlduty, CommandType.Text);
if (dps != null && dps.Tables.Count > 0)
{
role dep = DataTableToList.GetList <role>(dps.Tables[0]).FirstOrDefault();
if (dep != null)
{
usertorolemodel.role = dep.guid;
}
}
string sql =
string.Format
(
"INSERT INTO usertorole(user_id,role_id) VALUES('{0}','{1}') ;select last_insert_rowid()",
usertorolemodel.user, usertorolemodel.role
);
var ds = SqliteHelper.ExecuteScalar(con, sql, CommandType.Text);
if (Convert.ToInt32(ds) > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
// MessageAlert.Alert(ex.ToString());
return(false);
}
}
public bool delete(Model.UserToRoleModel.usertorole usertorolemodel)
{
string contion = string.Format("id='{0}'", usertorolemodel.id);
return(ServerHelp.deleteDataByWhere <Model.UserToRoleModel.usertorole>(_webip, contion));
}
public bool add(Model.UserToRoleModel.usertorole usertorolemodel)
{
return(ServerHelp.addSingleInfoNotReturnID <QDDL.Model.UserToRoleModel.usertorole>(usertorolemodel, _webip));
}