/// <summary>
/// 그리드뷰 버튼, 콤보박스세팅
/// </summary>
private void ControlSetting()
{
///combobox
Item_Level_Master first = new Item_Level_Master()
{
Level_Name = "",
Level_Code = ""
};
var level1list = itemgrouplist.FindAll(level => level.Item_lvl1 == "Y");
level1list.Insert(0, first);
cbbLevel_1.DisplayMember = "Level_Name";
cbbLevel_1.ValueMember = "Level_Code";
cbbLevel_1.DataSource = level1list;
var level2list = itemgrouplist.FindAll(level => level.Item_lvl2 == "Y");
level2list.Insert(0, first);
cbbLevel_2.DisplayMember = "Level_Name";
cbbLevel_2.ValueMember = "Level_Code";
cbbLevel_2.DataSource = new BindingSource(level2list, null);
var level3list = itemgrouplist.FindAll(level => level.Item_lvl3 == "Y");
level3list.Insert(0, first);
cbbLevel_3.DisplayMember = "Level_Name";
cbbLevel_3.ValueMember = "Level_Code";
cbbLevel_3.DataSource = new BindingSource(level3list, null);
var level4list = itemgrouplist.FindAll(level => level.Item_lvl4 == "Y");
level4list.Insert(0, first);
cbbLevel_4.DisplayMember = "Level_Name";
cbbLevel_4.ValueMember = "Level_Code";
cbbLevel_4.DataSource = new BindingSource(level4list, null);
var level5list = itemgrouplist.FindAll(level => level.Item_lvl5 == "Y");
level5list.Insert(0, first);
cbbLevel_5.DisplayMember = "Level_Name";
cbbLevel_5.ValueMember = "Level_Code";
cbbLevel_5.DataSource = new BindingSource(level5list, null);
///
}
/// <summary>
/// 그룹 저장 수정
/// </summary>
/// <returns></returns>
public bool InsertUpdateItem_Level_Master(Item_Level_Master item)
{
try
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = new SqlConnection(Connstr);
comm.CommandText = "InsertUpdateItem_Level_Master";
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.AddWithValue("@Level_Code", item.Level_Code);
comm.Parameters.AddWithValue("@Level_Name", item.Level_Name);
comm.Parameters.AddWithValue("@Item_lvl1", item.Item_lvl1);
comm.Parameters.AddWithValue("@Item_lvl2", item.Item_lvl2);
comm.Parameters.AddWithValue("@Item_lvl3", item.Item_lvl3);
comm.Parameters.AddWithValue("@Item_lvl4", item.Item_lvl4);
comm.Parameters.AddWithValue("@Item_lvl5", item.Item_lvl5);
comm.Parameters.AddWithValue("@Box_Qty", item.Box_Qty);
comm.Parameters.AddWithValue("@Pcs_Qty", item.Pcs_Qty);
comm.Parameters.AddWithValue("@Mat_Qty", item.Mat_Qty);
comm.Parameters.AddWithValue("@Ins_Emp", item.Ins_Emp);
comm.Connection.Open();
int result = Convert.ToInt32(comm.ExecuteNonQuery());
comm.Connection.Close();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
}
catch
{
return(false);
}
}
/// <summary>
/// 그룹 저장 수정
/// </summary>
/// <returns></returns>
public bool InsertUpdateItem_Level_Master(Item_Level_Master item)
{
return(DAC.InsertUpdateItem_Level_Master(item));
}
