public DataTable ChakuniYoteiNyuuryoku_Search(ChakuniYoteiNyuuryokuEntity cyn)
{
CKMDL ckmdl = new CKMDL();
cyn.Sqlprms = new SqlParameter[11];
cyn.Sqlprms[0] = new SqlParameter("@DateFrom", SqlDbType.VarChar)
{
Value = cyn.ChakuniYoteiDateFrom
};
cyn.Sqlprms[1] = new SqlParameter("@DateTo", SqlDbType.VarChar)
{
Value = cyn.ChakuniYoteiDateTo
};
cyn.Sqlprms[2] = new SqlParameter("@SiiresakiCD", SqlDbType.VarChar)
{
Value = cyn.SiiresakiCD
};
cyn.Sqlprms[3] = new SqlParameter("@StaffCD", SqlDbType.VarChar)
{
Value = cyn.StaffCD
};
cyn.Sqlprms[4] = new SqlParameter("@ShouhinName", SqlDbType.VarChar)
{
Value = cyn.ShouhinName
};
cyn.Sqlprms[5] = new SqlParameter("@HacchuuDateFrom", SqlDbType.VarChar)
{
Value = cyn.HacchuuDateFrom
};
cyn.Sqlprms[6] = new SqlParameter("@HacchuuDateTo", SqlDbType.VarChar)
{
Value = cyn.HacchuuDateTo
};
cyn.Sqlprms[7] = new SqlParameter("@KanriNOFrom", SqlDbType.VarChar)
{
Value = cyn.KanriNOFrom
};
cyn.Sqlprms[8] = new SqlParameter("@KanriNOTo", SqlDbType.VarChar)
{
Value = cyn.KanriNOTo
};
cyn.Sqlprms[9] = new SqlParameter("@ShouhinCDFrom", SqlDbType.VarChar)
{
Value = cyn.ShouhinCDFrom
};
cyn.Sqlprms[10] = new SqlParameter("@ShouhinCDTo", SqlDbType.VarChar)
{
Value = cyn.ShouhinCDTo
};
DataTable dt = ckmdl.SelectDatatable("ChakuniYoteiNyuuryoku_Search", GetConnectionString(), cyn.Sqlprms);
return(dt);
}
public DataTable ChakuniYoteiDataCheck(ChakuniYoteiNyuuryokuEntity cyn)
{
CKMDL ckmdl = new CKMDL();
cyn.Sqlprms = new SqlParameter[1];
cyn.Sqlprms[0] = new SqlParameter("@KanriNO", SqlDbType.VarChar)
{
Value = cyn.KanriNO
};
DataTable dt = ckmdl.SelectDatatable("ChakuniYotei_DataCheck", GetConnectionString(), cyn.Sqlprms);
return(dt);
}
private void GridViewBind()
{
ChakuniYoteiNyuuryoku_BL cb = new ChakuniYoteiNyuuryoku_BL();
ChakuniYoteiNyuuryokuEntity cyn = new ChakuniYoteiNyuuryokuEntity();
if (cf.DateCheck(txtDateFrom)) //Task no. 147 - tza
{
cyn.ChakuniYoteiDateFrom = txtDateFrom.Text;
}
if (cf.DateCheck(txtDateTo)) //Task no. 147 - tza
{
cyn.ChakuniYoteiDateTo = txtDateTo.Text;
}
cyn.SiiresakiCD = sbSiiresaki.Text;
cyn.StaffCD = sbStaff.Text;
cyn.ShouhinName = txtShouhinName.Text;
if (cf.DateCheck(txtOrderDateFrom)) //Task no. 147 - tza
{
cyn.HacchuuDateFrom = txtOrderDateFrom.Text;
}
if (cf.DateCheck(txtOrderDateTo)) //Task no. 147 - tza
{
cyn.HacchuuDateTo = txtOrderDateTo.Text;
}
cyn.KanriNOFrom = txtControlNoFrom.Text;
cyn.KanriNOTo = txtControlNoTo.Text;
cyn.ShouhinCDFrom = sbHinbanCDFrom.Text;
cyn.ShouhinCDTo = sbHinbanCDTo.Text;
if (ErrorCheck(panel1)) //Task no. 147 - tza
{
DataTable dt = cb.ChakuniYoteiNyuuryoku_Search(cyn);
if (dt.Columns.Contains("CurrentDay"))
{
if (dt.Rows.Count > 0)
{
if (dt.Columns.Contains("CurrentDay"))
{
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();//ssa
}
}
dt.Columns.Remove("CurrentDay");//ssa
gvChakuniYoteiNyuuryoku.DataSource = dt;
}
}
public DataTable ChakuniYoteiNyuuryoku_Update_Select(ChakuniYoteiNyuuryokuEntity ce, int type)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[3];
parameters[0] = new SqlParameter("@ChakuniYoteiNo", SqlDbType.VarChar)
{
Value = ce.ChakuniYoteiNO
};
parameters[1] = new SqlParameter("@ChakuniYoteiDate", SqlDbType.VarChar)
{
Value = ce.ChakuniYoteiDate
};
parameters[2] = new SqlParameter("@ModeType", SqlDbType.TinyInt)
{
Value = type
};
DataTable dt = ckmdl.SelectDatatable("ChakuniYoteiNyuuryoku_Update_Select", GetConnectionString(), parameters);
return(dt);
}
public DataTable ChakuniYoteiNyuuryoku_Display(ChakuniYoteiNyuuryokuEntity cyn)
{
CKMDL ckmdl = new CKMDL();
cyn.Sqlprms = new SqlParameter[16];
cyn.Sqlprms[0] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = cyn.BrandCD
};
cyn.Sqlprms[1] = new SqlParameter("@HinbanCD", SqlDbType.VarChar)
{
Value = cyn.HinbanCD
};
cyn.Sqlprms[2] = new SqlParameter("@JANCD", SqlDbType.VarChar)
{
Value = cyn.JANCD
};
cyn.Sqlprms[3] = new SqlParameter("@ShouhinName", SqlDbType.VarChar)
{
Value = cyn.ShouhinName
};
cyn.Sqlprms[4] = new SqlParameter("@ColorNo", SqlDbType.VarChar)
{
Value = cyn.ColorNO
};
cyn.Sqlprms[5] = new SqlParameter("@SizeNo", SqlDbType.VarChar)
{
Value = cyn.SizeNO
};
cyn.Sqlprms[6] = new SqlParameter("@ChakuniYoteiDateFrom", SqlDbType.VarChar)
{
Value = cyn.ChakuniYoteiDateFrom
};
cyn.Sqlprms[7] = new SqlParameter("@ChakuniYoteiDateTo", SqlDbType.VarChar)
{
Value = cyn.ChakuniYoteiDateTo
};
cyn.Sqlprms[8] = new SqlParameter("@SoukoCD", SqlDbType.VarChar)
{
Value = cyn.SoukoCD
};
cyn.Sqlprms[9] = new SqlParameter("@YearTerm", SqlDbType.VarChar)
{
Value = cyn.YearTerm
};
cyn.Sqlprms[10] = new SqlParameter("@SeasonSS", SqlDbType.VarChar)
{
Value = cyn.SeasonSS
};
cyn.Sqlprms[11] = new SqlParameter("@SeasonFW", SqlDbType.VarChar)
{
Value = cyn.SeasonFW
};
cyn.Sqlprms[12] = new SqlParameter("@Operator", SqlDbType.VarChar)
{
Value = cyn.OperatorCD
};
cyn.Sqlprms[13] = new SqlParameter("@Program", SqlDbType.VarChar)
{
Value = cyn.ProgramID
};
cyn.Sqlprms[14] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = cyn.PC
};
cyn.Sqlprms[15] = new SqlParameter("@ChakuniYoteiDate", SqlDbType.VarChar)
{
Value = cyn.ChakuniYoteiDate
};
DataTable dt = ckmdl.SelectDatatable("ChakuniYoteiNyuuryoku_Display", GetConnectionString(), cyn.Sqlprms);
return(dt);
}
