public bool M_Brand_Delete(M_Brand_Entity mbe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>()
{
{ "@Brand", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.BrandCD
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.InsertOperator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.ProcessMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.BrandCD + " " + mbe.ChangeDate
} }
};
return(InsertUpdateDeleteData(dic, "M_Brand_Delete"));
}
private void F12()
{
if (ErrorCheck(12))
{
if (mtkbl.ShowMessage(OperationMode == EOperationMode.DELETE ? "Q102" : "Q101") == DialogResult.Yes)
{
//*** Create Entity Object
mbe = GetBrandEntity();
switch (OperationMode)
{
case EOperationMode.INSERT:
InsertUpdate(1);
break;
case EOperationMode.UPDATE:
InsertUpdate(2);
break;
case EOperationMode.DELETE:
Delete();
break;
}
}
else
{
PreviousCtrl.Focus();
}
}
}
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 M_Brand_Select(M_Brand_Entity m_Brand_Data)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("@BrandCode", m_Brand_Data.BrandCD);
dic.Add("@BrandName", m_Brand_Data.BrandName);
return(SelectData(dic, "M_Brand_Select"));
}
private M_Brand_Entity GetEntity()
{
mbe = new M_Brand_Entity();
mbe.DisplayKbn = radioButton1.Checked ? "0" : "1";
mbe.ChangeDate = ckM_Label1.Text;
mbe.MakerCD = detailControls[(int)EIndex.MakerCD].Text;
mbe.BrandName = detailControls[(int)EIndex.BrandName].Text;
return(mbe);
}
public DataTable M_BrandSelect(M_Brand_Entity mbe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@Brand", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.BrandCD
} }
};
return(SelectData(dic, "M_BrandSelect"));
}
/// <summary>
/// bind grid data
/// </summary>
private void BindGrid()
{
m_Brand_Data = new M_Brand_Entity();
m_Brand_Data.BrandName = txtBrandName.Text;
DataTable dt_Brand = new DataTable();
dt_Brand = Brand_List_BL.Brand_Select(m_Brand_Data);
dgvBrand.DataSource = dt_Brand;
if (dt_Brand.Rows.Count > 0)
{
dgvBrand.Rows[0].Selected = true;
}
}
public DataTable M_Brand_Select(M_Brand_Entity mme)
{
string sp = "M_Brand_Select";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@BrandCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mme.BrandCD
} },
};
return(SelectData(dic, sp));
}
private bool BindGrid()
{
mbe = GetEntity();
DataTable dt = mbl.M_Brand_SelectAll(mbe);
if (dt.Rows.Count == 0)
{
return(false);
}
dgvDetail.DataSource = dt;
return(true);
}
private void BrandCD_Validating(object sender, CancelEventArgs e)
{
TextBox txt = sender as TextBox;
int row = dgvM_MakerZaiko.CurrentCell.RowIndex;
if (string.IsNullOrWhiteSpace(txt.Text))
{
dgvM_MakerZaiko.Rows[row].Cells["colBrandName"].Value = string.Empty;
dgvM_MakerZaiko.Rows[row].Cells["colMakerCd"].Value = string.Empty;
dgvM_MakerZaiko.Rows[row].Cells["colMakerName"].Value = string.Empty;
dgvM_MakerZaiko.Rows[row].Cells["colData"].Value = string.Empty;
dgvM_MakerZaiko.Rows[row].Cells["colDataName"].Value = string.Empty;
dgvM_MakerZaiko.Rows[row].Cells["colPatternCD"].Value = string.Empty;
dgvM_MakerZaiko.Rows[row].Cells["colPatternName"].Value = string.Empty;
return;
}
mbe = new M_Brand_Entity();
mbe.BrandCD = txt.Text;
DataTable dt = psks0102mbl.M_Brand_Select(mbe);
if (dt.Rows.Count > 0)
{
dgvM_MakerZaiko.Rows[row].Cells["colBrandName"].Value = dt.Rows[0]["vm_brand"].ToString();
if (!string.IsNullOrWhiteSpace(ucMaker.UC_Code))
{
dgvM_MakerZaiko.Rows[row].Cells[dgvM_MakerZaiko.Columns["colMakerCD"].Index].Value = ucMaker.UC_Code;
dgvM_MakerZaiko.Rows[row].Cells[dgvM_MakerZaiko.Columns["colMakerName"].Index].Value = ucMaker.UC_Name;
}
CheckRowAdd(dgvM_MakerZaiko.Rows[row]);
}
else
{
DSP_MSG("E101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
dgvM_MakerZaiko.Rows[row].Cells["colBrandName"].Value = string.Empty;
dgvM_MakerZaiko.CurrentCell = dgvM_MakerZaiko[dgvM_MakerZaiko.Columns["colBrandCD"].Index, row];
if (lastKeyIsEnter)
{
SendKeys.Send("+{TAB}");
}
else
{
e.Cancel = true;
}
}
}
private M_Brand_Entity GetBrandEntity()
{
mbe = new M_Brand_Entity
{
BrandCD = ScBrandCD.Code,
BrandName = txtBrandName.Text,
BrandKana = txtKanaName.Text,
ChangeDate = DateTime.Today.ToShortDateString(),
ProcessMode = ModeText,
InsertOperator = InOperatorCD,
ProgramID = InProgramID,
PC = InPcID
};
return(mbe);
}
public bool M_Brand_Select(M_Brand_Entity me)
{
DataTable dt = mmdl.M_Brand_Select(me);
if (dt.Rows.Count > 0)
{
me.BrandCD = dt.Rows[0]["BrandCD"].ToString();
me.BrandName = dt.Rows[0]["BrandName"].ToString();
me.BrandKana = dt.Rows[0]["BrandKana"].ToString();
me.UsedFlg = dt.Rows[0]["UsedFlg"].ToString();
return(true);
}
else
{
return(false);
}
}
public DataTable M_Brand_SelectAll(M_Brand_Entity mme)
{
string sp = "M_Brand_SelectAll";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@DisplayKbn", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mme.DisplayKbn
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mme.ChangeDate
} },
{ "@BrandName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mme.BrandName
} },
{ "@MakerCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mme.MakerCD
} },
};
return(SelectData(dic, sp));
}
public bool M_Brand_Insert_Update(M_Brand_Entity mbe, int mode)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@Brand", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.BrandCD
} },
{ "@BrandName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.BrandName
} },
{ "@BrandKana", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.BrandKana
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.InsertOperator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.ProcessMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.BrandCD + " " + mbe.ChangeDate
} },
{ "@Mode", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mode.ToString()
} }
};
UseTransaction = true;
return(InsertUpdateDeleteData(dic, "M_Brand_Insert_Update"));
}
public DataTable Brand_Select(M_Brand_Entity m_Brand_Data)
{
return(m_Brand_DL.M_Brand_Select(m_Brand_Data));
}
private bool CheckDetail(int index)
{
bool ret;
switch (index)
{
case (int)EIndex.VendorCd:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
ScMaker.LabelText = "";
return(true);
}
else
{
M_Vendor_Entity mve = new M_Vendor_Entity
{
VendorCD = detailControls[index].Text,
ChangeDate = string.IsNullOrWhiteSpace(this.ChangeDate) ? sbl.GetDate() : this.ChangeDate,
DeleteFlg = "0"
};
Vendor_BL vbl = new Vendor_BL();
ret = vbl.M_Vendor_SelectTop1(mve);
if (ret)
{
ScMaker.LabelText = mve.VendorName;
}
else
{
sbl.ShowMessage("E101");
ScMaker.LabelText = "";
return(false);
}
}
break;
case (int)EIndex.BrandCD:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
ScBrand.LabelText = "";
}
else
{
//[M_Brand]
M_Brand_Entity mme = new M_Brand_Entity
{
//ChangeDate = string.IsNullOrWhiteSpace(this.ChangeDate) ? sbl.GetDate() : this.ChangeDate,
BrandCD = detailControls[index].Text
};
Brand_BL bbl = new Brand_BL();
ret = bbl.M_Brand_Select(mme);
if (ret)
{
ScBrand.LabelText = mme.BrandName;
}
else
{
//Ｅ１０１
sbl.ShowMessage("E101");
ScBrand.LabelText = "";
return(false);
}
}
break;
case (int)EIndex.SportsCD:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
ScSports.LabelText = "";
}
else
{
//以下の条件でM_MultiPorposeが存在しない場合、エラー
//[M_MultiPorpose]
M_MultiPorpose_Entity mme = new M_MultiPorpose_Entity
{
ID = MultiPorpose_BL.ID_SPORTS,
Key = detailControls[index].Text,
ChangeDate = string.IsNullOrWhiteSpace(this.ChangeDate) ? sbl.GetDate() : this.ChangeDate
};
MultiPorpose_BL mbl = new MultiPorpose_BL();
DataTable dt = mbl.M_MultiPorpose_Select(mme);
if (dt.Rows.Count > 0)
{
ScSports.LabelText = dt.Rows[0]["Char1"].ToString();
}
else
{
//Ｅ１０１
sbl.ShowMessage("E101");
ScSports.LabelText = "";
return(false);
}
}
break;
//case (int)EIndex.ClassificationA:
// if (string.IsNullOrWhiteSpace(detailControls[index].Text))
// {
// scClassificationA.LabelText = "";
// }
// else
// {
// //以下の条件でM_ClassificationAが存在しない場合、エラー
// //[M_ClassificationA]
// M_Classification_Entity mce = new M_Classification_Entity
// {
// ClassificationA = detailControls[index].Text
// };
// Classification_BL mbl = new Classification_BL();
// ret = mbl.M_ClassificationA_Select(mce);
// if (ret)
// {
// scClassificationA.LabelText = mce.ClassificationAName;
// }
// else
// {
// //Ｅ１０１
// sbl.ShowMessage("E101");
// scClassificationA.LabelText = "";
// return false;
// }
// }
// break;
//case (int)EIndex.ClassificationB:
// if (string.IsNullOrWhiteSpace(detailControls[index].Text))
// {
// scClassificationB.LabelText = "";
// }
// else
// {
// //以下の条件でM_ClassificationBが存在しない場合、エラー
// //[M_ClassificationB]
// M_Classification_Entity mce = new M_Classification_Entity
// {
// ClassificationA = detailControls[index - 1].Text,
// ClassificationB = detailControls[index].Text
// };
// Classification_BL mbl = new Classification_BL();
// ret = mbl.M_ClassificationB_Select(mce);
// if (ret)
// {
// scClassificationA.LabelText = mce.ClassificationAName;
// scClassificationB.LabelText = mce.ClassificationBName;
// }
// else
// {
// //Ｅ１０１
// sbl.ShowMessage("E101");
// scClassificationB.LabelText = "";
// return false;
// }
// }
// break;
//case (int)EIndex.ClassificationC:
// if (string.IsNullOrWhiteSpace(detailControls[index].Text))
// {
// scClassificationC.LabelText = "";
// }
// else
// {
// //以下の条件でM_ClassificationCが存在しない場合、エラー
// //[M_ClassificationC]
// M_Classification_Entity mce = new M_Classification_Entity
// {
// ClassificationA = detailControls[index - 2].Text,
// ClassificationB = detailControls[index - 1].Text,
// ClassificationC = detailControls[index].Text
// };
// Classification_BL mbl = new Classification_BL();
// ret = mbl.M_ClassificationC_Select(mce);
// if (ret)
// {
// scClassificationA.LabelText = mce.ClassificationAName;
// scClassificationB.LabelText = mce.ClassificationBName;
// scClassificationC.LabelText = mce.ClassificationCName;
// }
// else
// {
// //Ｅ１０１
// sbl.ShowMessage("E101");
// scClassificationC.LabelText = "";
// return false;
// }
// }
// break;
case (int)EIndex.DayStart:
case (int)EIndex.DayEnd:
case (int)EIndex.InputStart:
case (int)EIndex.InputEnd:
case (int)EIndex.UpdateStart:
case (int)EIndex.UpdateEnd:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
return(true);
}
detailControls[index].Text = this.sbl.FormatDate(detailControls[index].Text);
//日付として正しいこと(Be on the correct date)Ｅ１０３
if (!this.sbl.CheckDate(detailControls[index].Text))
{
//Ｅ１０３
this.sbl.ShowMessage("E103");
return(false);
}
//見積日(From) ≧ 見積日(To)である場合Error
if (index == (int)EIndex.DayEnd || index == (int)EIndex.InputEnd || index == (int)EIndex.UpdateEnd)
{
if (!string.IsNullOrWhiteSpace(detailControls[index - 1].Text) && !string.IsNullOrWhiteSpace(detailControls[index].Text))
{
int result = detailControls[index].Text.CompareTo(detailControls[index - 1].Text);
if (result < 0)
{
//Ｅ１０６
this.sbl.ShowMessage("E104");
detailControls[index].Focus();
return(false);
}
}
}
break;
}
return(true);
}
public DataTable M_Brand_Select(M_Brand_Entity mbe)
{
return(brandDL.M_Brand_Select(mbe));
}
public bool M_Brand_Delete(M_Brand_Entity mbe)
{
return(bdl.M_Brand_Delete(mbe));
}
public bool M_Brand_Insert_Update(M_Brand_Entity mbe, int mode)
{
return(bdl.M_Brand_Insert_Update(mbe, mode));
}
public DataTable Brand_Select(M_Brand_Entity mbe)
{
return(bdl.M_BrandSelect(mbe));
}
/// <summary>
/// ErrorCheck
/// </summary>
/// <param name="index"></param>
/// <returns></returns>
private bool ErrorCheck(int index)
{
if (index == 11)
{
//HeaderCheck on F11
mbe = GetBrandEntity();
if (OperationMode == EOperationMode.INSERT)
{
if (type == 1)//New
{
if (!RequireCheck(new Control[] { ScBrandCD.TxtCode }))
{
return(false);
}
DataTable dtbrand = new DataTable();
mbe.BrandCD = ScBrandCD.Code;
dtbrand = mtkbl.Brand_Select(mbe);
if (dtbrand.Rows.Count > 0)
{
mtkbl.ShowMessage("E132");
ScBrandCD.SetFocus(1);
return(false);
}
}
else//Copy
{
if (!RequireCheck(new Control[] { ScBrandCD.TxtCode }))
{
return(false);
}
DataTable dtbrand = new DataTable();
mbe.BrandCD = ScBrandCD.Code;
dtbrand = mtkbl.Brand_Select(mbe);
if (dtbrand.Rows.Count > 0)
{
mtkbl.ShowMessage("E132");
ScBrandCD.SetFocus(1);
return(false);
}
else
{
if (!string.IsNullOrWhiteSpace(ScCopyBrand.TxtCode.Text))
{
mbe.BrandCD = ScCopyBrand.Code;
DataTable dtcopybrand = new DataTable();
dtcopybrand = mtkbl.Brand_Select(mbe);
if (dtcopybrand.Rows.Count > 0)
{
txtBrandName.Text = dtcopybrand.Rows[0]["BrandName"].ToString();
}
else
{
mtkbl.ShowMessage("E133");
ScCopyBrand.SetFocus(1);
return(false);
}
}
}
}
}
else
{
DataTable dtbrand = new DataTable();
mbe.BrandCD = ScBrandCD.Code;
dtbrand = mtkbl.Brand_Select(mbe);
if (dtbrand.Rows.Count == 0)
{
mtkbl.ShowMessage("E133");
ScBrandCD.SetFocus(1);
return(false);
}
}
}
else if (index == 12)
{
if (!RequireCheck(new Control[] { ScBrandCD.TxtCode }))
{
return(false);
}
if (string.IsNullOrWhiteSpace(txtBrandName.Text))
{
mtkbl.ShowMessage("E102");
txtBrandName.Focus();
return(false);
}
if (string.IsNullOrWhiteSpace(txtKanaName.Text))
{
mtkbl.ShowMessage("E102");
txtKanaName.Focus();
return(false);
}
if (OperationMode == EOperationMode.INSERT)
{
DataTable dtbrand = new DataTable();
mbe = GetBrandEntity();
dtbrand = mtkbl.Brand_Select(mbe);
if (dtbrand.Rows.Count > 0)
{
mtkbl.ShowMessage("E132");
ScBrandCD.SetFocus(1);
return(false);
}
}
else if (OperationMode == EOperationMode.DELETE)
{
DataTable dtbrand = new DataTable();
mbe = GetBrandEntity();
dtbrand = mtkbl.Brand_Select(mbe);
if (dtbrand.Rows.Count > 0)
{
if (dtbrand.Rows[0]["UsedFlg"].ToString() == "1")
{
mtkbl.ShowMessage("E154");
ScBrandCD.SetFocus(1);
return(false);
}
}
}
}
return(true);
}
public DataTable M_Brand_SelectAll(M_Brand_Entity me)
{
return(mmdl.M_Brand_SelectAll(me));
}
