public List <PublishingModel> getByKeyword(string keyword)
{
SqlConnection con = new SqlConnection(myDBConnectionString);
con.Open();
string tSQL = "Select * from Publishing where p_id Like @pid or p_Name Like @pName";
SqlCommand cmd = new SqlCommand(tSQL, con);
cmd.Parameters.AddWithValue("pid", '%' + keyword + '%');
cmd.Parameters.AddWithValue("pName", '%' + keyword + '%');
SqlDataReader reader = cmd.ExecuteReader();
List <PublishingModel> list = new List <PublishingModel>();
while (reader.Read())
{
PublishingModel p = new PublishingModel();
p.p_id = (string)reader["p_id"];
p.p_Identifier = (string)reader["p_Identifier"];
p.p_Name = (string)reader["p_Name"];
p.p_Address = (string)reader["p_Address"];
list.Add(p);
}
reader.Close();
con.Close();
return(list);
}
public List <PublishingModel> SeleteAll()
{
SqlConnection con = new SqlConnection(myDBConnectionString);
con.Open();
string tSQL = "select p_id,p_Identifier,p_Name,p_Address from Publishing";
SqlCommand cmd = new SqlCommand(tSQL, con);
SqlDataReader reader = cmd.ExecuteReader();
List <PublishingModel> list = new List <PublishingModel>();
while (reader.Read())
{
PublishingModel p = new PublishingModel();
p.p_id = (string)reader["p_id"];
p.p_Identifier = (string)reader["p_Identifier"];
p.p_Name = (string)reader["p_Name"];
p.p_Address = (string)reader["p_Address"];
list.Add(p);
}
reader.Close();
con.Close();
return(list);
}
public PublishingModel 要修改的出版社資料(string pid)
{
SqlConnection con = new SqlConnection(myDBConnectionString);
con.Open();
string tSQL = "select * from Publishing where p_id=@pid";
SqlCommand cmd = new SqlCommand(tSQL, con);
cmd.Parameters.AddWithValue("pid", pid);
SqlDataReader reader = cmd.ExecuteReader();
PublishingModel p = new PublishingModel();
if (reader.Read())
{
p.p_id = (string)reader["p_id"];
p.p_Identifier = (string)reader["p_Identifier"];
p.p_Name = (string)reader["p_Name"];
p.p_Address = (string)reader["p_Address"];
}
reader.Close();
con.Close();
return(p);
}
public ActionResult EditSave(PublishingModel p)
{
PublishingFactory factory = new PublishingFactory();
factory.Edit(p);
return(RedirectToAction("List"));
}
public ActionResult CreateSave(PublishingModel p)
{
PublishingFactory factory = new PublishingFactory();
p.p_id = factory.自動產生p_id();
factory.Create(p);
return(RedirectToAction("List"));
}
public void Create(PublishingModel p)
{
SqlConnection con = new SqlConnection(myDBConnectionString);
con.Open();
string tSQL = "Insert into Publishing (p_id,p_Identifier,p_Name,p_Address)Values(@pid,@pidentifier,@pName,@pAddress)";
SqlCommand cmd = new SqlCommand(tSQL, con);
cmd.Parameters.AddWithValue("pid", p.p_id);
cmd.Parameters.AddWithValue("pidentifier", p.p_Identifier);
cmd.Parameters.AddWithValue("pName", p.p_Name);
cmd.Parameters.AddWithValue("pAddress", p.p_Address);
cmd.ExecuteNonQuery();
con.Close();
}
public void Edit(PublishingModel p)
{
SqlConnection con = new SqlConnection(myDBConnectionString);
con.Open();
string tSQL = "Update Publishing set p_Identifier=@pidentifier,p_Name=@pName,p_Address=@pAddress where p_id=@pid";
SqlCommand cmd = new SqlCommand(tSQL, con);
cmd.Parameters.AddWithValue("pid", p.p_id);
cmd.Parameters.AddWithValue("pidentifier", p.p_Identifier);
cmd.Parameters.AddWithValue("pName", p.p_Name);
cmd.Parameters.AddWithValue("pAddress", p.p_Address);
cmd.ExecuteNonQuery();
con.Close();
}
