private void F11()
{
moe = GetSearchInfo();
RadioCheck();
dtMain = mskbl.M_ShiireKakeritsu_Select(moe);
if (dtMain.Rows.Count > 0)
{
for (int i = 0; i < dtMain.Rows.Count; i++)
{
var Brand = dtMain.Rows[i]["BrandCD"].ToString();
var Sports = dtMain.Rows[i]["SportsCD"].ToString();
var Segment = dtMain.Rows[i]["SegmentCD"].ToString();
var LastYearTerm = dtMain.Rows[i]["LastYearTerm"].ToString();
var LastSeason = dtMain.Rows[i]["LastSeason"].ToString();
if (String.IsNullOrEmpty(Brand) || String.IsNullOrEmpty(Sports) || String.IsNullOrEmpty(Segment) || String.IsNullOrEmpty(LastYearTerm) || String.IsNullOrEmpty(LastSeason))
{
string date = dtMain.Rows[i][11].ToString();
DateTime dtime = Convert.ToDateTime(date);
txtRevisionDate.Text = dtime.ToShortDateString();
txtRate1.Text = dtMain.Rows[i][12].ToString();
}
}
dgv_ShiireKakeritsu.DataSource = dtMain;
}
else
{
mskbl.ShowMessage("E128");
dgv_ShiireKakeritsu.DataSource = null;
scSupplierCD.SetFocus(1);
}
}
private void BindGrid()
{
string searchCondition = string.Empty;
if (!string.IsNullOrWhiteSpace(scBrandCD1.TxtCode.Text))
{
searchCondition = "BrandCD = '" + scBrandCD1.TxtCode.Text + "'";
}
if (!string.IsNullOrWhiteSpace(scSportsCD1.TxtCode.Text))
{
searchCondition = "SportsCD='" + scSportsCD1.TxtCode.Text + "'";
}
if (!string.IsNullOrWhiteSpace(scSegmentCD1.TxtCode.Text))
{
searchCondition = "SegmentCD= '" + scSegmentCD1.TxtCode.Text + "'";
}
if (!string.IsNullOrWhiteSpace(cbo_Year1.Text))
{
searchCondition = "LastYearTerm='" + cbo_Year1.Text + "'";
}
if (!string.IsNullOrWhiteSpace(cbo_Season1.Text))
{
searchCondition = "LastSeason= '" + cbo_Season1.Text + "'";
}
if (!string.IsNullOrWhiteSpace(txtDate.Text))
{
searchCondition = "ChangeDate= '" + txtDate.Text;
}
moe = GetSearchInfo();
dtMain = mskbl.M_ShiireKakeritsu_Select(moe);
dvMain = new DataView(dtMain);
dgv_ShiireKakeritsu.DataSource = dvMain;
}
public MasterTouroku_ShiireKakeritsu()
{
InitializeComponent();
mskbl = new MasterTouroku_ShiireKakeritsu_BL();
moe = new M_OrderRate_Entity();
mve = new M_Vendor_Entity();
mbe = new M_Brand_Entity();
dvMain = new DataView();
}
public DataTable MasterTouroku_ShiireKakeritsu_Select(M_OrderRate_Entity moe)
{
string sp = "M_ShiireKakeritsu_Select";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@VendorCD", new ValuePair {
value1 = System.Data.SqlDbType.VarChar, value2 = moe.VendorCD
} },
{ "@StoreCD", new ValuePair {
value1 = System.Data.SqlDbType.VarChar, value2 = moe.StoreCD
} }
};
return(SelectData(dic, sp));
}
public DataTable M_Shiirekakeritsu(M_OrderRate_Entity moe, string xml, L_Log_Entity log_data)
{
string sp = "M_OrderRate_Update";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@xml", new ValuePair {
value1 = SqlDbType.VarChar, value2 = xml
} },
{ "@VendorCD", new ValuePair {
value1 = System.Data.SqlDbType.VarChar, value2 = moe.VendorCD
} },
{ "@StoreCD", new ValuePair {
value1 = System.Data.SqlDbType.VarChar, value2 = moe.StoreCD
} },
{ "@ChangeDate", new ValuePair {
value1 = System.Data.SqlDbType.VarChar, value2 = moe.ChangeDate
} },
{ "@Rate", new ValuePair {
value1 = System.Data.SqlDbType.VarChar, value2 = moe.Rate
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = moe.Operator
} }, //ses
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = moe.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = moe.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = moe.ProcessMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = moe.Key
} }
};
return(SelectData(dic, sp));
}
private M_OrderRate_Entity GetSearchInfo()
{
moe = new M_OrderRate_Entity()
{
VendorCD = scSupplierCD.TxtCode.Text,
StoreCD = cbo_Store.SelectedValue.ToString(),
BrandCD = scBrandCD1.TxtCode.Text,
BrandName = scBrandCD1.LabelText,
SportsCD = scSportsCD1.TxtCode.Text,
SegmentCD = scSegmentCD1.TxtCode.Text,
LastYearTerm = cbo_Year1.SelectedText,
LastSeason = cbo_Season1.SelectedText,
ChangeDate = txtDate.Text,
Rate = txtRate.Text,
ProcessMode = ModeText,
ProgramID = InProgramID,
InsertOperator = InOperatorCD,
Key = scSupplierCD.Code,
PC = InPcID
};
return(moe);
}
public DataTable M_OrderRate_Update(M_OrderRate_Entity moe, string Xml, L_Log_Entity log_data)
{
return(mskdl.M_Shiirekakeritsu(moe, Xml, log_data));
}
public DataTable M_ShiireKakeritsu_Select(M_OrderRate_Entity moe)
{
return(mskdl.MasterTouroku_ShiireKakeritsu_Select(moe));
}
