public ActionResult UpdateSave(Book.Model.T_Base_Admin Admin) { Book.BLL.T_Base_Admin bll = new BLL.T_Base_Admin(); int result = bll.Update(Admin); return(Redirect("Index")); }
//public List<Book.Model.T_Base_Admin> GetAll() //{ // Book.DAL.T_Base_Admin dal = new DAL.T_Base_Admin(); // return dal.GetAll(); //} public int Add(Book.Model.T_Base_Admin item) { Book.DAL.T_Base_Admin dal = new DAL.T_Base_Admin(); //用DAL层提供的添加方法添加 dal.Add(item); return(0); }
public int Update(Book.Model.T_Base_Admin Admin) { Book.DAL.T_Base_Admin dal = new DAL.T_Base_Admin(); int result = dal.Update(Admin); return(result); }
//public List<Book.Model.T_Base_Provider> GetAll() //{ // SqlConnection co = new SqlConnection(); // co.ConnectionString = "server=10.132.239.3;uid=sa;pwd=Jsj123456;database=15211160113"; // co.Open(); // SqlCommand cm = new SqlCommand(); // cm.Connection = co; // cm.CommandText = "select * from t_base_provider"; // SqlDataReader dr = cm.ExecuteReader(); // List<Book.Model.T_Base_Provider> lst = new List<Model.T_Base_Provider>(); // while (dr.Read()) // { // Book.Model.T_Base_Provider provider = new Model.T_Base_Provider(); // provider.Id = Convert.ToInt32(dr["Id"]); // provider.Name = Convert.ToString(dr["Name"]); // provider.Tel = Convert.ToString(dr["Tel"]); // provider.Memo = Convert.ToString(dr["Memo"]); // provider.Fax = Convert.ToString(dr["Fax"]); // lst.Add(provider); // } // dr.Close(); // co.Close(); // return lst; //} public int Add(Book.Model.T_Base_Admin item) { SqlConnection co = new SqlConnection(); co.ConnectionString = "server=10.132.239.3;uid=sa;pwd=Jsj123456;database=15211160113"; co.Open(); SqlCommand cm = new SqlCommand(); cm.Connection = co; cm.CommandText = "Insert into T_Base_Admin(LoginName,PWD,RoleId) values (@LoginName,@PWD,@RoleId)"; cm.Parameters.AddWithValue("@LoginName", item.LoginName); cm.Parameters.AddWithValue("@PWD", item.PWD); cm.Parameters.AddWithValue("@RoleId", item.RoleId); int result = cm.ExecuteNonQuery(); co.Close(); return(result); }