private void btnPesquisar_Click(object sender, EventArgs e)
{
mdlUser _user = new mdlUser();
if (cbFiltro.Text == "Nome")
{
_user.Nome = txtFiltro.Text;
}
else if (cbFiltro.Text == "RG")
{
_user.RG = txtFiltro.Text;
}
else if (cbFiltro.Text == "CPF")
{
_user.CPF = txtFiltro.Text;
}
/*_user.CPF = txtFiltro.Text;
* _user.Nome = txtFiltro.Text;
* _user.RG = txtFiltro.Text;*/
ctlUser _ctlUser = new ctlUser();
dgUser.DataSource = _ctlUser.PesquisarUsuario(_user);
}
public static int UpdateUserInfo(mdlUser modelUser)
{
int Result = -1;
try
{
using (SqlConnection conn = new SqlConnection(DBUtility.connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
string strSQL = @" UPDATE tb_sy_user SET Rid =@Rid, language=@language WHERE Uid=@Uid AND Uname=@Uname";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@Uid", modelUser.Uid),
new SqlParameter("@Uname", modelUser.Uname),
new SqlParameter("@Rid", modelUser.Role.Rid),
new SqlParameter("@language", modelUser.Language)
};
cmd.Parameters.AddRange(paras);
cmd.CommandText = strSQL;
cmd.Connection = conn;
Result = cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(Result);
}
public static int AddUserInfo(mdlUser modelUser)
{
int Result = -1;
try
{
using (SqlConnection conn = new SqlConnection(DBUtility.connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
string strSQL = @"INSERT INTO tb_sy_user(Uname, Uname_desc, Pwd, Rid, language) VALUES (@Uname, @Uname_desc, @Pwd, @Rid, @language)";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@Uname", modelUser.Uname),
new SqlParameter("@Uname_desc", modelUser.Uname_Desc),
new SqlParameter("@Pwd", modelUser.Pwd),
new SqlParameter("@Rid", modelUser.Role.Rid),
new SqlParameter("@language", modelUser.Language)
};
cmd.Parameters.AddRange(paras);
cmd.CommandText = strSQL;
cmd.Connection = conn;
Result = cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(Result);
}
private void barButtonItem15_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Form FormUser = kiemtraform(typeof(mdlUser));
if (FormUser == null)
{
mdlUser usctrl = new mdlUser();
usctrl.MdiParent = this;
usctrl.Show();
usctrl.Text = "Người dùng";
}
else
{
FormUser.Activate();
}
}
// GET: User list
public HttpResponseMessage GET(int Page = 1)
{
Page = Page == 0 ? 1 : Page;
mdlUser user = new mdlUser();
user.page = Page;
int skip = 0;
int take = 3;
if (Page > 1)
{
skip = take * (Page - 1);
}
user.per_page = take;
user.total = lobjDatabase.User.ToList().Count;
List <UserDetails> userlist = lobjDatabase.User.AsQueryable().OrderBy(x => x.id).Skip(skip).Take(take).ToList();
user.data = userlist;
return(Request.CreateResponse(HttpStatusCode.OK, user));
}
/// <summary>
/// 編輯用戶
/// </summary>
/// <param name="modelUser"></param>
/// <returns>dgsql1</returns>
public int UpdateUserInfo(mdlUser modelUser)
{
int Result = -1;
try
{
string strSQL = @" UPDATE sys_user SET language=@language WHERE user_id=@user_id AND Uname=@user_name";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@user_id", modelUser.user_id),
new SqlParameter("@user_name", modelUser.user_name),
new SqlParameter("@language", modelUser.language)
};
Result = clsApp.ExecuteNonQuery(strSQL, paras, false);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(Result);
}
/// <summary>
/// 添加新用戶
/// </summary>
/// <param name="modelUser"></param>
/// <returns>dgsql1</returns>
public int AddUserInfo(mdlUser modelUser)
{
int Result = -1;
try
{
string strSQL = @"INSERT INTO tb_sy_user(Uname, Uname_desc, Pwd, Rid, language) VALUES (@Uname, @Uname_desc, @Pwd, @Rid, @language)";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@user_id", modelUser.user_id),
new SqlParameter("@user_name", modelUser.user_name),
new SqlParameter("@password", modelUser.password),
new SqlParameter("@language", modelUser.language)
};
Result = clsApp.ExecuteNonQuery(strSQL, paras, false);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(Result);
}
