private void BORPop_Load(object sender, EventArgs e) { R_survice = new ResourceService(); #region 콤보박스 바인딩 common_service = new CommonCodeService(); common_list = common_service.GetCommonCodeAll(); { //공정 var mCode = (from item in common_list where item.common_type == "route" select item).ToList(); ComboUtil.ComboBinding <CommonVO>(cboRoute, mCode, "common_value", "common_name", "미선택"); } { //사용유무 var mCode = (from item in common_list where item.common_type == "user_flag" select item).ToList(); ComboUtil.ComboBinding <CommonVO>(cboYN, mCode, "common_value", "common_name"); } R_survice = new ResourceService(); List <MachineVO> lst = R_survice.GetMachineAll(); ComboUtil.ComboBinding <MachineVO>(cboM_name, lst, "m_id", "m_name", "미선택"); ProductService product_service = new ProductService(); List <ProductVO> list = product_service.GetAllProducts(); ComboUtil.ComboBinding <ProductVO>(cboP_Name, list, "product_id", "product_name", "미선택"); #endregion if (mode == EditMode.Update) { R_survice = new ResourceService(); vo = R_survice.GetBORByID(Convert.ToInt32(lblID.Text), lblRoute.Text); lblID.Text = vo.bor_id.ToString(); cboP_Name.Text = vo.product_name; cboM_name.Text = vo.m_name; cboYN.Text = vo.bor_yn; cboRoute.Text = vo.common_name; txtComment.Text = vo.bor_comment; txtReadyTime.Text = vo.bor_readytime.ToString(); txtTactTime.Text = vo.bor_tacktime.ToString(); } }
private void btnSearch_Click(object sender, EventArgs e) { dataGridView1.Columns.Clear(); BORDB_VO vo = new BORDB_VO(); vo.product_name = txtItem.Text; if (cboProcess.Text == "미선택") { vo.common_name = ""; } else { vo.common_name = cboProcess.Text; } vo.m_name = txtFacility.Text; List <BORDB_VO> list = service.BOR_Search(vo); if (list == null) { return; } else { dataGridView1.DataSource = null; dgvColumnSet(); dataGridView1.DataSource = list; } if (dataGridView1.Rows.Count <= 0) { SetBottomStatusLabel("조회에 실패하였습니다. 다시 시도하여 주십시오."); } else { SetBottomStatusLabel("조회가 완료되었습니다."); } }
public List <BORDB_VO> BOR_Search(BORDB_VO vo) { using (SqlCommand cmd = new SqlCommand()) { StringBuilder sb = new StringBuilder(); sb.Append("select b.bor_id as bor_id, a.product_id as bom_id, a.product_codename as product_codename, a.product_name as product_name , "); sb.Append("c.common_value as common_type , c.common_name as common_name, d.m_code as m_code, d.m_name as m_name, b.bor_tacktime as bor_tacktime , "); sb.Append(" b.bor_readytime as bor_readytime, b.bor_yn as bor_yn, b.bor_comment as bor_comment from tbl_product a inner join tbl_bor b on "); sb.Append(" a.product_id = b.product_id inner join tbl_common_code c on c.common_value = b.bor_route and c.common_type = 'route' inner join "); sb.Append(" tbl_machine d on d.m_id = b.m_id where 1 = 1 "); cmd.Connection = new SqlConnection(this.ConnectionString); if (vo.product_name != "") { cmd.Parameters.AddWithValue("@product_name", vo.product_name); sb.Append(" and product_name = @product_name"); } if (vo.common_name != "") { cmd.Parameters.AddWithValue("@common_name", vo.common_name); sb.Append(" and common_name = @common_name"); } if (vo.m_name != "") { cmd.Parameters.AddWithValue("@m_name", vo.m_name); sb.Append(" and m_name = @m_name"); } cmd.CommandText = sb.ToString(); cmd.Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); List <BORDB_VO> list = Helper.DataReaderMapToList <BORDB_VO>(reader); cmd.Connection.Close(); return(list); } }
public List <BORDB_VO> BOR_Search(BORDB_VO vo) { return(dac.BOR_Search(vo)); }