/// <summary>
/// コンボボックスに薬効分類をセット
/// </summary>
private void bindClassifications()
{
using(var db = new DrugInfoContext())
{
var list = db.Classifications
.Select(item => new ClassificationViewModel
{
Code = item.ClassificationCode,
Name = item.Name,
classificationId = item.ClassificationId
}).ToList();
// リストの先頭にブランクをセットする
list.Insert(0, new ClassificationViewModel
{
Code = "",
Name = "",
classificationId = 0
});
// コンボボックスの表示設定
this.comboBox1.DisplayMember = "title";
this.comboBox1.ValueMember = "ClassificationId";
this.comboBox1.DataSource = list;
}
}
/// <summary>
/// 表示ボタンをクリックした際の動作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
// 現在選択されている薬効分類を取得する
System.Diagnostics.Debug.WriteLine(
string.Format("SelectedValue={0}", this.comboBox1.SelectedValue));
using (var db = new DrugInfoContext())
{
// 薬効分類IDを元に薬品情報を取得
int clsId = (int)this.comboBox1.SelectedValue;
var list = db.Drugs
.Where(item =>
(clsId == 0 ||
item.ClassificationId == clsId) &&
(String.IsNullOrEmpty(this.txtDrugName.Text) ||
item.Name.Contains(this.txtDrugName.Text)))
.Select(item => new DrugViewModel {
Id = item.DrugId,
Name = item.Name,
Code = item.DrugCode
})
.ToList();
this.dataGridView1.DataSource = list;
this.dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
}
/// <summary>
/// 出力用データを取得する
/// </summary>
/// <param name="drugIdList"></param>
/// <returns></returns>
private List <List <string> > getDrugData(List <int> drugIdList)
{
List <List <string> > data = new List <List <string> >();
using (var db = new DrugInfoContext())
{
foreach (int id in drugIdList)
{
var drug = db.Drugs
.Where(item => item.DrugId == id)
.FirstOrDefault();
var line = new List <string>();
if (drug != null)
{
line.Add(drug.Classifications.ClassificationCode);
line.Add(drug.Classifications.Name);
line.Add(drug.DrugCode);
line.Add(drug.Name);
line.Add(drug.Company);
data.Add(line);
}
}
}
return(data);
}
/// <summary>
/// コンボボックスに薬効分類をセット
/// </summary>
private void bindClassifications()
{
using (var db = new DrugInfoContext())
{
var list = db.Classifications
.Select(item => new ClassificationViewModel
{
Code = item.ClassificationCode,
Name = item.Name,
classificationId = item.ClassificationId
}).ToList();
// リストの先頭にブランクをセットする
list.Insert(0, new ClassificationViewModel
{
Code = "",
Name = "",
classificationId = 0
});
// コンボボックスの表示設定
this.comboBox1.DisplayMember = "title";
this.comboBox1.ValueMember = "ClassificationId";
this.comboBox1.DataSource = list;
}
}
/// <summary>
/// コンボボックスのデータ読み込み
/// </summary>
private void bindClassification()
{
using (var db = new DrugInfoContext())
{
db.Database.Connection.Open();
this.cmbClassification.DisplayMember = "Name";
this.cmbClassification.ValueMember = "ClassificationId";
this.cmbClassification.DataSource = db.Classifications.ToList();
this.cmbClassification.FormattingEnabled = true;
this.cmbClassification.Format += new ListControlConvertEventHandler(formatComboLabel);
}
}
/// <summary>
/// 更新処理
/// </summary>
private void updateDrugInfo()
{
using (var db = new DrugInfoContext())
{
var drug = db.Drugs.Where(item => item.DrugId == this.drugId).First();
drug.Name = this.txtName.Text;
drug.Company = this.txtCompany.Text;
drug.ClassificationId = (int)this.cmbClassification.SelectedValue;
db.SaveChanges();
}
}
/// <summary>
/// コンボボックスのデータ読み込み
/// </summary>
private void bindClassification()
{
using (var db = new DrugInfoContext())
{
db.Database.Connection.Open();
this.cmbClassification.DisplayMember = "Name";
this.cmbClassification.ValueMember = "ClassificationId";
this.cmbClassification.DataSource = db.Classifications.ToList();
this.cmbClassification.FormattingEnabled = true;
this.cmbClassification.Format += new ListControlConvertEventHandler(formatComboLabel);
}
}
private void Form1_Load(object sender, EventArgs e)
{
using (var db = new DrugInfoContext())
{
db.Database.Connection.Open();
this.comboBox1.DisplayMember = "Name";
this.comboBox1.ValueMember = "ClassificationId";
this.comboBox1.DataSource = db.Classifications.ToList();
this.comboBox1.FormattingEnabled = true;
this.comboBox1.Format += new ListControlConvertEventHandler(comboBox1_Format);
}
}
/// <summary>
/// 登録処理
/// </summary>
private void addDrugInfo()
{
using (var db = new DrugInfoContext())
{
var drug = new Drugs();
drug.DrugCode = "";
drug.Name = this.txtName.Text;
drug.Company = this.txtCompany.Text;
drug.ClassificationId = (int)this.cmbClassification.SelectedValue;
db.Drugs.Add(drug);
db.SaveChanges();
}
}
/// <summary>
/// 登録処理
/// </summary>
private void addDrugInfo()
{
using (var db = new DrugInfoContext())
{
var drug = new Drugs();
drug.DrugCode = "";
drug.Name = this.txtName.Text;
drug.Company = this.txtCompany.Text;
drug.ClassificationId = (int)this.cmbClassification.SelectedValue;
db.Drugs.Add(drug);
db.SaveChanges();
}
}
/// <summary>
/// 薬品情報の読み込み
/// </summary>
private void loadDrugInfo()
{
using (var db = new DrugInfoContext())
{
var drug = db.Drugs
.Where(item => item.DrugId == this.drugId)
.FirstOrDefault();
if (drug != null)
{
this.lblCode.Text = drug.DrugCode;
this.txtName.Text = drug.Name;
this.txtCompany.Text = drug.Company;
this.cmbClassification.SelectedValue = drug.ClassificationId;
}
}
}
/// <summary>
/// OKボタンをクリックした際の動作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
// 現在選択されている薬効分類を取得する
System.Diagnostics.Debug.WriteLine(
string.Format("SelectedValue={0}", this.comboBox1.SelectedValue));
using (var db = new DrugInfoContext())
{
// 薬効分類IDを元に薬品情報を取得
int clsId = (int)this.comboBox1.SelectedValue;
var list = db.Drugs
.Where(item => item.ClassificationId == clsId)
.Select(item => new DrugViewModel { Id = item.DrugId,
Name = item.Name,
Code = item.DrugCode })
.ToList();
this.dataGridView1.DataSource = list;
this.dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
}
/// <summary>
/// 出力用データを取得する
/// </summary>
/// <param name="drugIdList"></param>
/// <returns></returns>
private List<List<string>> getDrugData(List<int> drugIdList)
{
List<List<string>> data = new List<List<string>>();
using (var db = new DrugInfoContext())
{
foreach (int id in drugIdList)
{
var drug = db.Drugs
.Where(item => item.DrugId == id)
.FirstOrDefault();
var line = new List<string>();
if (drug != null)
{
line.Add(drug.Classifications.ClassificationCode);
line.Add(drug.Classifications.Name);
line.Add(drug.DrugCode);
line.Add(drug.Name);
line.Add(drug.Company);
data.Add(line);
}
}
}
return data;
}
private void Form1_Load(object sender, EventArgs e)
{
using(var db = new DrugInfoContext())
{
db.Database.Connection.Open();
this.comboBox1.DisplayMember = "Name";
this.comboBox1.ValueMember = "ClassificationId";
this.comboBox1.DataSource = db.Classifications.ToList();
this.comboBox1.FormattingEnabled = true;
this.comboBox1.Format += new ListControlConvertEventHandler(comboBox1_Format);
}
}
/// <summary>
/// 更新処理
/// </summary>
private void updateDrugInfo()
{
using (var db = new DrugInfoContext())
{
var drug = db.Drugs.Where(item => item.DrugId == this.drugId).First();
drug.Name = this.txtName.Text;
drug.Company = this.txtCompany.Text;
drug.ClassificationId = (int)this.cmbClassification.SelectedValue;
db.SaveChanges();
}
}
/// <summary>
/// 薬品情報の読み込み
/// </summary>
private void loadDrugInfo()
{
using (var db = new DrugInfoContext())
{
var drug = db.Drugs
.Where(item => item.DrugId == this.drugId)
.FirstOrDefault();
if (drug != null)
{
this.lblCode.Text = drug.DrugCode;
this.txtName.Text = drug.Name;
this.txtCompany.Text = drug.Company;
this.cmbClassification.SelectedValue = drug.ClassificationId;
}
}
}
