private void GetCondition()
{
//读取条件
List <CatagoryInfo> condition = new List <CatagoryInfo>();
string keywordfilepath = "config\\creative.txt";
int num = 0;
if (File.Exists(keywordfilepath))
{
string[] str = File.ReadAllLines(keywordfilepath, System.Text.Encoding.Default);
foreach (string item in str)
{
if (item.Trim() != "")
{
CatagoryInfo con = new CatagoryInfo();
con.id = num++;
con.key = item.Trim();
strcon.Add(item.Trim());
condition.Add(con);
}
}
}
cbCondition.ItemsSource = condition;
cbCondition.SelectedValuePath = "id";
cbCondition.DisplayMemberPath = "key";
}
public CatagoryInfo GetCategoryName(String name)
{
SqlDBdataAccess db = new SqlDBdataAccess();
SqlCommand cmd = db.GetCommand("select * from Lib_Book_Category where Category_Name like '%" + name + "%'");
CatagoryInfo ob = GetData(cmd);
return(ob);
}
public bool InsertCategory(CatagoryInfo obj)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("insert into [dbo].[Lib_Book_Category] ([Category_Name])" + "values(@CategoryName)");
SqlParameter p = new SqlParameter("@CategoryName", SqlDbType.VarChar, 50);
p.Value = obj.CatagoryName;
cmd.Parameters.Add(p);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(val > 0);
}
CatagoryInfo GetData(SqlCommand cmd)
{
cmd.Connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
CatagoryInfo ob = new CatagoryInfo();
using (reader)
{
while (reader.Read())
{
ob.Id = reader.GetInt32(0);
ob.CatagoryName = reader.GetString(1);
}
reader.Close();
}
cmd.Connection.Close();
return(ob);
}
private void catagoryAddbutton_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(addCatagoryTextbox.Text))
{
MessageBox.Show("Enter Catagory Name", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
info1 = cmd.GetCategoryName(catagory);
compare = info1.CatagoryName;
if (compare == catagory)
{
MessageBox.Show("Catagory Already Exists", "Invalid Operation", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
info.CatagoryName = catagory;
cm.InsertCategory(info);
MessageBox.Show("Catagory Added Successfully", "Congratulation", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
}
