コード例 #1
0
        private void GetCon()
        {
            Condition_Service service = new Condition_Service();
            Condition_Vo      vo      = new Condition_Vo();

            vo.Item_Name             = txt_Item.Text;
            vo.Wc_Name               = txt_WorkPlace.Text;
            dataGridView1.DataSource = service.GetCondition(vo);
        }
コード例 #2
0
ファイル: Condition_Dac.cs プロジェクト: mwkim0402/Team1_MES2
        public List <Condition_Vo> GetCondition(Condition_Vo item)
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.Connection  = new SqlConnection(this.ConnectionString);
                cmd.CommandText = "GetCondition";
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@Wc_Name", item.Wc_Name);
                cmd.Parameters.AddWithValue("@Item_Name", item.Item_Name);
                cmd.Connection.Open();
                SqlDataReader       reader = cmd.ExecuteReader();
                List <Condition_Vo> list   = Helper.DataReaderMapToList <Condition_Vo>(reader);
                cmd.Connection.Close();

                return(list);
            }
        }
コード例 #3
0
        public List <Condition_Vo> GetCondition(Condition_Vo item)
        {
            Condition_Dac dac = new Condition_Dac();

            return(dac.GetCondition(item));
        }