public string Add_Users(List <User> model) { List <User> user = model; string username = ""; string password = ""; string rolenum = ""; string realname = ""; string email = ""; string phone = ""; string department = ""; foreach (var item in user) { username = item.UserName; password = item.Password; rolenum = item.RoleNum; realname = item.RealName; email = item.Email; phone = item.Phone; department = item.DepartNum; } String sql = " insert into Users(UserName,PassWord,RoleNum,RealName,Email,Phone,DepartNum) values( '" + username + "','" + password + "','" + rolenum + "','" + realname + "','" + email + "','" + email + "','" + department + "')"; int result = Dbs.ExecuteNonQuery(sql); if (result == 1) { return("Success"); } else { return("no"); } }
public String Delete_Role(int id) { String sql = "proc_Delete_Role '" + id + "'"; int result = Dbs.ExecuteNonQuery(sql); if (result == 1) { ViewBag.saveStatus = 1; // return 1; String tip = "success"; //return RedirectToAction("Basci_faq"); return(tip); } else { ViewBag.saveStatus = 0; String tip = "Fail"; return(tip); //return Content("<script>alert('no');history.go(-1);</script>"); } }
public ActionResult Edit_Role(List <String> Role_manage) { string ID = Role_manage[0]; //string UserName = Role_manage[1]; string Password = Role_manage[1]; string Role = Role_manage[2]; string RealName = Role_manage[3]; string Phone = Role_manage[4]; string DepartNum = Role_manage[5]; //string newUserName = Leach(UserName); string newPassword = Leach(Password); string newRole = Leach(Role); string newRealName = Leach(RealName); string newPhone = Leach(Phone); string newDepartNum = Leach(DepartNum); String sql = "exec proc_Update_Role_Manage '" + ID + "','" + newPassword + "','" + newRole + "','" + newRealName + "','" + newPhone + "','" + newDepartNum + "'"; int result = Dbs.ExecuteNonQuery(sql); if (result == 1) { ViewBag.saveStatus = 1; // return 1; String tip = "Success"; return(JavaScript(tip)); } else { ViewBag.saveStatus = 0; String tip = "Fail"; return(JavaScript(tip)); //return Content("<script>alert('no');history.go(-1);</script>"); } }