private void UpdateItem_Load(object sender, EventArgs e) { string[] codes = { "A100", "B100" }; DataSet ds = items.GetCommonCode(codes); DataSet ds2 = items.GetRefName(); CommonUtil.BindingComboBox(cbRefName, ds2.Tables[0], "refID", "refName"); CommonUtil.BindingComboBox(cbItemType, ds.Tables["A100"], "codeID", "codeName"); CommonUtil.BindingComboBox(cbAmountType, ds.Tables["B100"], "codeID", "codeName"); //refItemID, itemID, refID, amount, count, leftCount, stoPlace, dDay //품목명, 냉장고명, 남은갯수, 남은용량 ,저장장소, CommonUtil.SetInitGridView(dgvUpdateItems); CommonUtil.AddGridTextColumn(dgvUpdateItems, "id", "refItemID", 35); CommonUtil.AddGridTextColumn(dgvUpdateItems, "품목명", "itemName", 100); CommonUtil.AddGridTextColumn(dgvUpdateItems, "냉장고명", "refName", 100); CommonUtil.AddGridTextColumn(dgvUpdateItems, "저장장소", "stoPlace", 80); CommonUtil.AddGridTextColumn(dgvUpdateItems, "남은갯수", "leftCount", 80); CommonUtil.AddGridTextColumn(dgvUpdateItems, "개당 용량", "amount", 80); CommonUtil.AddGridTextColumn(dgvUpdateItems, "남은용량", "leftAmount", 80); CommonUtil.AddGridTextColumn(dgvUpdateItems, "용량 단위", "ItemUnit", 80); CommonUtil.AddGridTextColumn(dgvUpdateItems, "품목타입", "itemType", 100); CommonUtil.AddGridTextColumn(dgvUpdateItems, "유통기한", "dDay", 100); DataLoad(); }
private void AddItem_Load(object sender, EventArgs e) { string[] codes = { "A100", "B100" }; DataSet ds = items.GetCommonCode(codes); DataSet ds2 = items.GetRefName(); CommonUtil.BindingComboBox(cbRefName, ds2.Tables[0], "refID", "refName"); CommonUtil.BindingComboBox(cbItemType, ds.Tables["A100"], "codeID", "codeName"); CommonUtil.BindingComboBox(cbAmountType, ds.Tables["B100"], "codeID", "codeName"); }