public List <DMRVO> GetDMRMgt(DMRVO vo)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = "GetDMRMgt";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@plan_id", vo.plan_id);
cmd.Parameters.AddWithValue("@pro_id", vo.pro_id);
cmd.Parameters.AddWithValue("@WH", vo.factory_name);
cmd.Parameters.AddWithValue("@product_codename", vo.product_codename);
cmd.Connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
List <DMRVO> list = Helper.DataReaderMapToList <DMRVO>(reader);
cmd.Connection.Close();
return(list);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
List <WorkRecode_VO> lst = (List <WorkRecode_VO>)dataGridView1.DataSource;
ProcessService P_Service = new ProcessService();
List <DMRVO> D_lst = new List <DMRVO>();
DMRVO vo = new DMRVO();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
vo.product_codename = dataGridView1.Rows[i].Cells[6].Value.ToString(); //제품코드네임 6 "U_JOINT_C"
vo.factory_name = dataGridView1.Rows[i].Cells[16].Value.ToString(); //창고명 m_use_sector 15 "제품창고"
vo.pro_id = Convert.ToInt32(dataGridView1.Rows[i].Cells[1].Value.ToString()); //pro_id 1 57
vo.plan_id = dataGridView1.Rows[i].Cells[17].Value.ToString(); //plan_id
D_lst = (P_Service.GetDMRMgt(vo));
}
List <WorkRecode_VO> w_lst = (List <WorkRecode_VO>)dataGridView1.DataSource;
bool bResult = P_Service.FinishRecode(D_lst, w_lst);
List <WorkRecode_VO> n_lst = P_Service.GetWork();
dataGridView2.DataSource = n_lst;
if (bResult)
{
MessageBox.Show("등록 성공");
}
else
{
MessageBox.Show("등록 실패");
}
ProcessService P_service = new ProcessService();
n_lst = P_service.GetWork();
dataGridView2.DataSource = n_lst;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
//LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
public DataTable GetDMR_dt(DMRVO vo)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = "GetDMRMgt";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@plan_id", vo.plan_id);
cmd.Parameters.AddWithValue("@pro_id", vo.pro_id);
cmd.Parameters.AddWithValue("@WH", vo.factory_name);
cmd.Parameters.AddWithValue("@product_codename", vo.product_codename);
cmd.Connection.Open();
DataTable table = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(table);
da.Dispose();
cmd.Connection.Close();
return(table);
}
}
public DataTable GetDMR_dt(DMRVO vo)
{
ProcessDac dac = new ProcessDac();
return(dac.GetDMR_dt(vo));
}
public List <DMRVO> GetDMRMgt(DMRVO vo)
{
ProcessDac dac = new ProcessDac();
return(dac.GetDMRMgt(vo));
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
dataGridView2.DataSource = null;
dataGridView2.Columns.Clear();
dataGridView2.DataSource = null;
ndt = null;
List <DMRVO> lst = new List <DMRVO>();
ProcessService P_service = new ProcessService();
DMRVO vo = new DMRVO();
try
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (Convert.ToBoolean(dataGridView1.Rows[i].Cells[0].Value) == true) //체크박스가 true?
{
vo.product_codename = dataGridView1.Rows[i].Cells[9].Value.ToString(); //제품코드네임
vo.factory_name = dataGridView1.Rows[i].Cells[11].Value.ToString(); //창고명
vo.pro_id = Convert.ToInt32(dataGridView1.Rows[i].Cells[1].Value.ToString()); //pro_id
vo.plan_id = dataGridView1.Rows[i].Cells[2].Value.ToString(); //plan_id
if (P_service.GetDMRMgt(vo).Count >= 5)
{
lst = (P_service.GetDMRMgt(vo));
}
}
}
for (int i = 0; i < lst.Count; i++)
{
lst[i].req_date = DateTime.Now.ToShortDateString();
}
// lst = P_service.GetDMRMgt(vo);
//dt = P_service.GetProductionPlanCheckHis(dateTimePicker1.Value.ToShortDateString(), dateTimePicker2.Value.ToShortDateString());
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "pro_id", "pro_id", false, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "플랜id", "plan_id", false, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "product_id", "product_id", false, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "제품코드명", "product_codename", true, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "제품명", "product_name", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "", "factory_id", false, 100, DataGridViewContentAlignment.MiddleLeft); //
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "창고명", "factory_name", true, 100, DataGridViewContentAlignment.MiddleLeft); //ff
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "계획수량", "pro_count", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "소요량", "bom_use_count", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "소요수량", "plan_count", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "자재창고 재고", "w_count_present", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "이전재고", "w_count_past", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "요청창고id", "req_factory_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "요청창고", "req_factory", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "요청창고 재고", "nam", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "요청량", "req_count", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "사유", "reason", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "요청일", "req_date", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "w_id", "w_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "", "order_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
dataGridView2.RowsDefaultCellStyle.BackColor = Color.FromArgb(240, 240, 240);
dataGridView2.AlternatingRowsDefaultCellStyle.BackColor = Color.White;
dataGridView2.DefaultCellStyle.SelectionBackColor = Color.Gray; //Color.DimGray;
dataGridView2.DefaultCellStyle.SelectionForeColor = Color.White;
dataGridView2.DataSource = lst;
}
catch (Exception err)
{
string st = err.Message;
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
