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