/// <summary>
/// 既に登録済みか確認
/// </summary>
/// <param name="b"></param>
/// <returns></returns>
public bool isRegisted(Brewer b)
{
var com = db.CreateCommand();
com.CommandText = "select id from brewers where licencedate = @1 and name = @2 and item = @3";
com.Parameters.AddWithValue("@1", b.getParam(Brewer.RegistInfo.licenceDate));
com.Parameters.AddWithValue("@2", b.getParam(Brewer.RegistInfo.name));
com.Parameters.AddWithValue("@3", b.getParam(Brewer.RegistInfo.item));
var r = com.ExecuteReader();
return(r.Read());
}
/// <summary>
///
/// </summary>
/// <param name="b"></param>
public void regist(Brewer b)
{
if (isRegisted(b))
{
return;//登録済みなら何もしない
}
var com = db.CreateCommand();
com.CommandText = "insert into brewers(prefecture,taxoffice,licencedate,registdate,name,place,classification,item,type) values(@1,@2,@3,@4,@5,@6,@7,@8,@9);";
com.Parameters.AddWithValue("@1", b.getParam(Brewer.RegistInfo.prefecture));
com.Parameters.AddWithValue("@2", b.getParam(Brewer.RegistInfo.taxoffice));
com.Parameters.AddWithValue("@3", b.getParam(Brewer.RegistInfo.licenceDate));
com.Parameters.AddWithValue("@4", b.getParam(Brewer.RegistInfo.registDate));
com.Parameters.AddWithValue("@5", b.getParam(Brewer.RegistInfo.name));
com.Parameters.AddWithValue("@6", b.getParam(Brewer.RegistInfo.place));
com.Parameters.AddWithValue("@7", b.getParam(Brewer.RegistInfo.classification));
com.Parameters.AddWithValue("@8", b.getParam(Brewer.RegistInfo.item));
com.Parameters.AddWithValue("@9", b.getParam(Brewer.RegistInfo.type));
com.ExecuteNonQuery();
}