public DataTable JuchuuNyuuryoku_Search(JuchuuNyuuryokuEntity obj)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[11];
parameters[0] = new SqlParameter("@JuchuuDateFrom", SqlDbType.VarChar)
{
Value = obj.JuchuuDateFrom
};
parameters[1] = new SqlParameter("@JuchuuDateTo", SqlDbType.VarChar)
{
Value = obj.JuchuuDateTo
};
parameters[2] = new SqlParameter("@TokuisakiCD", SqlDbType.VarChar)
{
Value = obj.TokuisakiCD
};
parameters[3] = new SqlParameter("@StaffCD", SqlDbType.VarChar)
{
Value = obj.StaffCD
};
parameters[4] = new SqlParameter("@ShouhinName", SqlDbType.VarChar)
{
Value = obj.ShouhinName
};
parameters[5] = new SqlParameter("@JuchuuNoFrom", SqlDbType.VarChar)
{
Value = obj.JuchuuNoFrom
};
parameters[6] = new SqlParameter("@JuchuuNoTo", SqlDbType.VarChar)
{
Value = obj.JuchuuNoTo
};
parameters[7] = new SqlParameter("@HacchuNoFrom", SqlDbType.VarChar)
{
Value = obj.HacchuNoFrom
};
parameters[8] = new SqlParameter("@HacchuNoTo", SqlDbType.VarChar)
{
Value = obj.HacchuNoTo
};
parameters[9] = new SqlParameter("@ShouhinCDFrom", SqlDbType.VarChar)
{
Value = obj.ShouhinCDFrom
};
parameters[10] = new SqlParameter("@ShouhinCDTo", SqlDbType.VarChar)
{
Value = obj.ShouhinCDTo
};
DataTable dt = ckmdl.SelectDatatable("JuchuuNyuuryoku_Search", GetConnectionString(), parameters);
return(dt);
}
public DataTable JuchuuNyuuryoku_Display(JuchuuNyuuryokuEntity obj)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[11];
parameters[0] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = obj.BrandCD
};
parameters[1] = new SqlParameter("@ShouhinCD", SqlDbType.VarChar)
{
Value = obj.ShouhinCD
};
parameters[2] = new SqlParameter("@ShouhinName", SqlDbType.VarChar)
{
Value = obj.ShouhinName
};
parameters[3] = new SqlParameter("@JANCD", SqlDbType.VarChar)
{
Value = obj.JANCD
};
parameters[4] = new SqlParameter("@YearTerm", SqlDbType.VarChar)
{
Value = obj.YearTerm
};
parameters[5] = new SqlParameter("@SeasonSS", SqlDbType.VarChar)
{
Value = obj.SeasonSS
};
parameters[6] = new SqlParameter("@SeasonFW", SqlDbType.VarChar)
{
Value = obj.SeasonFW
};
parameters[7] = new SqlParameter("@ColorNo", SqlDbType.VarChar)
{
Value = obj.ColorNO
};
parameters[8] = new SqlParameter("@SizeNo", SqlDbType.VarChar)
{
Value = obj.SizeNO
};
parameters[9] = new SqlParameter("@SiiresakiCD", SqlDbType.VarChar)
{
Value = obj.SiiresakiCD
};
parameters[10] = new SqlParameter("@ChangeDate", SqlDbType.VarChar)
{
Value = obj.ChangeDate
};
DataTable dt = ckmdl.SelectDatatable("JuchuuNyuuryoku_Display", GetConnectionString(), parameters);
return(dt);
}
private void DataGridviewBind()
{
JuchuuNyuuryokuEntity obj = new JuchuuNyuuryokuEntity();
if (cf.DateCheck(txtJuchuuDateFrom)) //Task no. 147 - tza
{
obj.JuchuuDateFrom = txtJuchuuDateFrom.Text;
}
if (cf.DateCheck(txtJuchuuDateTo)) //Task no. 147 - tza
{
obj.JuchuuDateTo = txtJuchuuDateTo.Text;
}
obj.TokuisakiCD = txtTokuisaki.Text;
obj.StaffCD = txtStaffCD.Text;
obj.ShouhinName = txtShouhinName.Text;
obj.JuchuuNoFrom = txtJuchuuNoFrom.Text;
obj.JuchuuNoTo = txtJuchuuNoTo.Text;
obj.HacchuNoFrom = txtHacchuNoFrom.Text;
obj.HacchuNoTo = txtHacchuNoTo.Text;
obj.ShouhinCDFrom = txtShouhinFrom.Text;
obj.ShouhinCDTo = txtShouhinTo.Text;
JuchuuNyuuryokuBL objMethod = new JuchuuNyuuryokuBL();
if (ErrorCheck(panel1)) //Task no. 147 - tza
{
DataTable dt = objMethod.JuchuuNyuuryoku_Search(obj);
if (dt.Columns.Contains("CurrentDay"))
{
if (dt.Rows.Count > 0)
{
lbl_Date.Text = String.Format("{0:yyyy/MM/dd}", dt.Rows[0]["CurrentDay"]);
txtCurrentDate.Text = String.Format("{0:yyyy/MM/dd}", dt.Rows[0]["CurrentDay"]);
}
else
{
ClearSession();
}
}
gv_1.DataSource = dt;
}
}
