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