private multipurposeEntity GetData()
{
multipurposeEntity mentity = new multipurposeEntity();
mentity.ID = txtID.Text;
mentity.Key = txtKEY.Text;
mentity.IdName = txtIDName.Text;
mentity.Char1 = txtChar1.Text;
mentity.Char2 = txtChar2.Text;
mentity.Char3 = txtChar3.Text;
mentity.Char4 = txtChar4.Text;
mentity.Char5 = txtChar5.Text;
mentity.Num1 = txtNum1.Text;
mentity.Num2 = txtNum2.Text;
mentity.Num3 = txtNum3.Text;
mentity.Num4 = txtNum4.Text;
mentity.Num5 = txtNum5.Text;
mentity.Date1 = txtDate1.Text;
mentity.Date2 = txtDate2.Text;
mentity.Date3 = txtDate3.Text;
mentity.InsertOperator = base_Entity.OperatorCD;
mentity.UpdateOperator = base_Entity.OperatorCD;
mentity.PC = base_Entity.PC;
mentity.ProgramID = base_Entity.ProgramID;
mentity.KeyItem = txtID.Text + " " + txtKEY.Text;
return(mentity);
}
private void MasterTouroku_Staff_Load(object sender, EventArgs e)
{
multipurposeEntity multipurpose_entity = new multipurposeEntity();
multipurpose_entity.id = 214;
ProgramID = "MasterTouroku_Staff";
StartProgram();
cboMode.Bind(false, multipurpose_entity);
cboStaff_Menu.Bind(true, multipurpose_entity);
cboStaff_authority.Bind(true, multipurpose_entity);
cboStaff_Position.Bind(true, multipurpose_entity);
SetButton(ButtonType.BType.Close, F1, "終了(F1)", true);
SetButton(ButtonType.BType.New, F2, "新規(F2)", true);
SetButton(ButtonType.BType.Update, F3, "修正(F3)", true);
SetButton(ButtonType.BType.Delete, F4, "削除(F4)", true);
SetButton(ButtonType.BType.Inquiry, F5, "照会(F5)", true);
SetButton(ButtonType.BType.Cancel, F6, "ｷｬﾝｾﾙ(F6)", true);
SetButton(ButtonType.BType.Search, F9, "検索(F9)", false);
SetButton(ButtonType.BType.Save, F12, "登録(F12)", true);
SetButton(ButtonType.BType.Empty, F7, "", false);
SetButton(ButtonType.BType.Empty, F8, "", false);
SetButton(ButtonType.BType.Empty, F10, "", false);
SetButton(ButtonType.BType.Empty, F11, "", false);
ChangeMode(GetMode(Mode.New));
txt_Staff.Focus();
base_Entity = _GetBaseData();
txt_Staff.ChangeDate = txtStaff_CDate;
txtStaff_Copy.ChangeDate = txtStaff_CopyDate;
}
private void MasterTouroku_Tokuisaki_Load(object sender, EventArgs e)
{
multipurposeEntity multipurposeEntity = new multipurposeEntity();
ProgramID = "MasterTouroku_Tokuisaki";
StartProgram();
cboMode.Bind(false, multipurposeEntity);
txtStaffCharge.lblName = lblStaffCD_Name;
SetButton(ButtonType.BType.Close, F1, "終了(F1)", true);
SetButton(ButtonType.BType.New, F2, "新規(F2)", true);
SetButton(ButtonType.BType.Update, F3, "修正(F3)", true);
SetButton(ButtonType.BType.Delete, F4, "削除(F4)", true);
SetButton(ButtonType.BType.Inquiry, F5, "照会(F5)", true);
SetButton(ButtonType.BType.Cancel, F6, "ｷｬﾝｾﾙ(F6)", true);
SetButton(ButtonType.BType.Search, F9, "検索(F9)", false);
SetButton(ButtonType.BType.Save, F12, "登録(F12)", true);
SetButton(ButtonType.BType.Empty, F7, "", false);
SetButton(ButtonType.BType.Empty, F8, "", false);
SetButton(ButtonType.BType.Import, F10, "CSV取込(F10)", true);
SetButton(ButtonType.BType.Empty, F11, "", false);
txt_Tokuisaki.Focus();
ChangeMode(GetMode(Mode.New));
base_Entity = _GetBaseData();
txtStaffCharge.ChangeDate = txtChange_Date;
txt_Tokuisaki.ChangeDate = txtChange_Date;
txtTokuisakiCopy.ChangeDate = txtTokuisaki_CopyDate;
panel2.GotFocus += RadioPanel_GotFocus;
panel3.GotFocus += RadioPanel_GotFocus;
}
public DataTable M_Multiporpose_Search(multipurposeEntity multipurpose_entity)
{
ckmdl = new CKMDL();
multipurpose_entity.Sqlprms = new SqlParameter[6];
multipurpose_entity.Sqlprms[0] = new SqlParameter("@ID1", SqlDbType.Int)
{
Value = multipurpose_entity.ID1
};
multipurpose_entity.Sqlprms[1] = new SqlParameter("@ID2", SqlDbType.Int)
{
Value = multipurpose_entity.ID2
};
multipurpose_entity.Sqlprms[2] = new SqlParameter("@Key1", SqlDbType.VarChar)
{
Value = multipurpose_entity.Key1
};
multipurpose_entity.Sqlprms[3] = new SqlParameter("@Key2", SqlDbType.VarChar)
{
Value = multipurpose_entity.Key2
};
multipurpose_entity.Sqlprms[4] = new SqlParameter("@IDName", SqlDbType.VarChar)
{
Value = multipurpose_entity.IdName
};
multipurpose_entity.Sqlprms[5] = new SqlParameter("@Type", SqlDbType.VarChar)
{
Value = multipurpose_entity.Type
};
DataTable dt = ckmdl.SelectDatatable("M_Multiporpose_Search", GetConnectionString(), multipurpose_entity.Sqlprms);
return(dt);
}
private void MasterTourokuSouko_Load(object sender, EventArgs e)
{
multipurposeEntity multipurpose_entity = new multipurposeEntity();
ProgramID = "MasterTouroku_Souko";
StartProgram();
cboMode.Bind(false, multipurpose_entity);
SetButton(ButtonType.BType.Close, F1, "終了(F1)", true);
SetButton(ButtonType.BType.New, F2, "新規(F2)", true);
SetButton(ButtonType.BType.Update, F3, "修正(F3)", true);
SetButton(ButtonType.BType.Delete, F4, "削除(F4)", true);
SetButton(ButtonType.BType.Inquiry, F5, "照会(F5)", true);
SetButton(ButtonType.BType.Cancel, F6, "ｷｬﾝｾﾙ(F6)", true);
SetButton(ButtonType.BType.Search, F9, "検索(F9)", false);
SetButton(ButtonType.BType.Save, F12, "登録(F12)", true);
SetButton(ButtonType.BType.Empty, F7, "", false);
SetButton(ButtonType.BType.Empty, F8, "", false);
SetButton(ButtonType.BType.Empty, F10, "", false);
SetButton(ButtonType.BType.Empty, F11, "", false);
ChangeMode(GetMode(Mode.New));
txtSouko.Focus();
base_Entity = _GetBaseData();
//txtSouko.ChangeDate = txtSoukoName;
//txtCopySouko.ChangeDate = txtSoukoName;
}
private void MasterTouroku_DenpyouNO_Load(object sender, EventArgs e)
{
multipurposeEntity multipurpose_entity = new multipurposeEntity();
multipurpose_entity.id = 101;
ProgramID = "MasterTouroku_DenpyouNO";
StartProgram();
cboMode.Bind(false, multipurpose_entity);
cbDivision.Bind(true, multipurpose_entity);
SetButton(ButtonType.BType.Close, F1, "終了(F1)", true);
SetButton(ButtonType.BType.New, F2, "新規(F2)", true);
SetButton(ButtonType.BType.Update, F3, "修正(F3)", true);
SetButton(ButtonType.BType.Delete, F4, "削除(F4)", true);
SetButton(ButtonType.BType.Inquiry, F5, "照会(F5)", true);
SetButton(ButtonType.BType.Cancel, F6, "ｷｬﾝｾﾙ(F6)", true);
SetButton(ButtonType.BType.Search, F9, "検索(F9)", false);
SetButton(ButtonType.BType.Save, F12, "登録(F12)", true);
SetButton(ButtonType.BType.Empty, F7, "", false);
SetButton(ButtonType.BType.Empty, F8, "", false);
SetButton(ButtonType.BType.Empty, F10, "", false);
SetButton(ButtonType.BType.Empty, F11, "", false);
ChangeMode(GetMode(Mode.New));
entity = _GetBaseData();
txtSEQNO.Combo = cbDivision;
txtSEQNO.TxtBox = txt_Prefix;
txtSEQNO.ctrl_combo = cbDivision;
txt_Prefix.Combo = cbDivision;
txt_Prefix.TxtBox = txtSEQNO;
txt_Prefix.ctrl_combo = cbDivision;
}
public void Bind(bool UseBlankRow, multipurposeEntity multipurpose_entity)
{
multipurposeBL multipurposeBL = new multipurposeBL();
DataTable dtCombo;
switch (ComboType)
{
case CType.Mode1:
dtCombo = new DataTable();
dtCombo.Columns.Add("ID");
dtCombo.Columns.Add("Mode");
dtCombo.Rows.Add("1", "新規");
dtCombo.Rows.Add("2", "修正");
dtCombo.Rows.Add("3", "削除");
dtCombo.Rows.Add("4", "照会");
BindCombo("ID", "Mode", dtCombo, UseBlankRow);
break;
case CType.Menu:
dtCombo = new DataTable();
dtCombo.Columns.Add("MenuID");
dtCombo.Columns.Add("MenuName");
DataTable dt = multipurposeBL.GetMenu();
for (int i = 0; i < dt.Rows.Count; i++)
{
dtCombo.Rows.Add(dt.Rows[i]["MenuID"], dt.Rows[i]["MenuName"]);
}
BindCombo("MenuID", "MenuName", dtCombo, UseBlankRow);
break;
case CType.Authorization:
dtCombo = new DataTable();
dtCombo.Columns.Add("AuthorizationsCD");
dtCombo.Columns.Add("AuthorizationsName");
DataTable dtA = multipurposeBL.GetAuthorization();
for (int i = 0; i < dtA.Rows.Count; i++)
{
dtCombo.Rows.Add(dtA.Rows[i]["AuthorizationsCD"], dtA.Rows[i]["AuthorizationsName"]);
}
BindCombo("AuthorizationsCD", "AuthorizationsName", dtCombo, UseBlankRow);
break;
case CType.Position:
dtCombo = new DataTable();
dtCombo.Columns.Add("Key");
dtCombo.Columns.Add("Char1");
DataTable dtP = multipurposeBL.GetPosition(multipurpose_entity);
for (int i = 0; i < dtP.Rows.Count; i++)
{
dtCombo.Rows.Add(dtP.Rows[i]["Key"], dtP.Rows[i]["Char20"]);
}
BindCombo("Key", "Char1", dtCombo, UseBlankRow);
break;
}
}
public IdouNyuuryoku()
{
InitializeComponent();
cf = new CommonFunction();
multi_Entity = new multipurposeEntity();
base_Entity = new BaseEntity();
base_bl = new BaseBL();
Idou_BL = new IdouNyuuryokuBL();
gv1_to_dt1 = new DataTable();
F8_dt1 = new DataTable();
}
public SqlDbType()
{
InitializeComponent();
cf = new CommonFunction();
multi_Entity = new multipurposeEntity();
dt_Main = new DataTable();
create_dt = new DataTable();
dt = new DataTable();
bbl = new BaseBL();
SEntity = new TorikomiEntity();
ShukkaTorikomi_BL = new ShukkaTorikomi_BL();
}
private void GridViewBind()
{
multipurposeBL bl = new multipurposeBL();
multipurposeEntity mentity = new multipurposeEntity();
mentity.ID1 = txtID1.Text;
mentity.ID2 = txtID2.Text;
mentity.Key1 = txtKey1.Text;
mentity.Key2 = txtKey2.Text;
mentity.IdName = txtIDName.Text;
mentity.Type = Access_Type;
DataTable dt = bl.M_Multiporpose_Search(mentity);
gvMultiporpose.DataSource = dt;
if (dt.Rows.Count == 0) //HET
{
ClearSession();
}
}
public DataTable GetPosition(multipurposeEntity multipurpose_entity)
{
ckmdl = new CKMDL();
multipurpose_entity.Sqlprms = new SqlParameter[3];
multipurpose_entity.Sqlprms[0] = new SqlParameter("@id", DbType.Int32)
{
Value = multipurpose_entity.id
};
multipurpose_entity.Sqlprms[1] = new SqlParameter("@Key", SqlDbType.VarChar)
{
Value = multipurpose_entity.Key
};
multipurpose_entity.Sqlprms[2] = new SqlParameter("@ErrorType", SqlDbType.VarChar)
{
Value = multipurpose_entity.ErrorType
};
DataTable dt = ckmdl.SelectDatatable("M_MultiPorpose_Select", GetConnectionString(), multipurpose_entity.Sqlprms);
return(dt);
}
private void DBProcess()
{
multipurposeEntity entity = GetData();
if (cboMode.SelectedValue.Equals("1"))
{
entity.Mode = "New";
DoInsert(entity);
}
else if (cboMode.SelectedValue.Equals("2"))
{
entity.Mode = "Update";
DoUpdate(entity);
}
else if (cboMode.SelectedValue.Equals("3"))
{
entity.Mode = "Delete";
DoDelete(entity);
}
}
private void DenpyouNoSearch_Load(object sender, EventArgs e)
{
multipurposeEntity multi_entity = new multipurposeEntity();
multi_entity.id = 101;
cbDivision1.Bind(true, multi_entity);
cbDivision2.Bind(true, multi_entity);
SetButton(ButtonType.BType.Close, F1, "戻る(F1)", true);
SetButton(ButtonType.BType.Normal, F9, "検索(F9)", false);
SetButton(ButtonType.BType.Search, F11, "表示(F11)", true);
SetButton(ButtonType.BType.Save, F12, "確定(F12)", true);
gvDenpyouNo.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.TopRight;
gvDenpyouNo.UseRowNo(true);
gvDenpyouNo.SetGridDesign();
gvDenpyouNo.SetReadOnlyColumn("**");//readonly for search form
BindDataGrid();
cbDivision2.E106Check(true, cbDivision1, cbDivision2);
gvDenpyouNo.Select();
cbDivision1.Select();
}
private void ShukkaSiziNyuuryoku_Load(object sender, EventArgs e)
{
ProgramID = "ShukkaSiziNyuuryoku";
StartProgram();
cboMode.Bind(false, multi_Entity);
SetButton(ButtonType.BType.Close, F1, "終了(F1)", true);
SetButton(ButtonType.BType.New, F2, "新規(F2)", true);
SetButton(ButtonType.BType.Update, F3, "変更(F3)", true);
SetButton(ButtonType.BType.Delete, F4, "削除(F4)", true);
SetButton(ButtonType.BType.Inquiry, F5, "照会(F5)", true);
SetButton(ButtonType.BType.Cancel, F6, "ｷｬﾝｾﾙ(F6)", true);
SetButton(ButtonType.BType.Confirm, F8, "確認(F8)", true);
SetButton(ButtonType.BType.Search, F9, "検索(F9)", true);
SetButton(ButtonType.BType.Display, F10, "表示(F10)", true);
SetButton(ButtonType.BType.Search, F11, "保存(F11)", true);
SetButton(ButtonType.BType.Save, F12, "登録(F12)", true);
SetButton(ButtonType.BType.Empty, F7, "", false);
ChangeMode(Mode.New);
txtShippingNO.Focus();
multipurposeEntity multipurpose_entity = new multipurposeEntity();
}
public DataTable M_Multiporpose_Insert_Update(multipurposeEntity multipurpose_entity)
{
ckmdl = new CKMDL();
ckmdl.UseTran = true;
multipurpose_entity.Sqlprms = new SqlParameter[22];
multipurpose_entity.Sqlprms[0] = new SqlParameter("@id", SqlDbType.Int)
{
Value = multipurpose_entity.ID
};
multipurpose_entity.Sqlprms[1] = new SqlParameter("@Key", SqlDbType.VarChar)
{
Value = multipurpose_entity.Key
};
multipurpose_entity.Sqlprms[2] = new SqlParameter("@IdName", SqlDbType.VarChar)
{
Value = multipurpose_entity.IdName
};
multipurpose_entity.Sqlprms[3] = new SqlParameter("@Char1", SqlDbType.VarChar)
{
Value = multipurpose_entity.Char1
};
multipurpose_entity.Sqlprms[4] = new SqlParameter("@Char2", SqlDbType.VarChar)
{
Value = multipurpose_entity.Char2
};
multipurpose_entity.Sqlprms[5] = new SqlParameter("@Char3", SqlDbType.VarChar)
{
Value = multipurpose_entity.Char3
};
multipurpose_entity.Sqlprms[6] = new SqlParameter("@Char4", SqlDbType.VarChar)
{
Value = multipurpose_entity.Char4
};
multipurpose_entity.Sqlprms[7] = new SqlParameter("@Char5", SqlDbType.VarChar)
{
Value = multipurpose_entity.Char5
};
multipurpose_entity.Sqlprms[8] = new SqlParameter("@Num1", SqlDbType.Int)
{
Value = multipurpose_entity.Num1
};
multipurpose_entity.Sqlprms[9] = new SqlParameter("@Num2", SqlDbType.Int)
{
Value = multipurpose_entity.Num2
};
multipurpose_entity.Sqlprms[10] = new SqlParameter("@Num3", SqlDbType.Int)
{
Value = multipurpose_entity.Num3
};
multipurpose_entity.Sqlprms[11] = new SqlParameter("@Num4", SqlDbType.Int)
{
Value = multipurpose_entity.Num4
};
multipurpose_entity.Sqlprms[12] = new SqlParameter("@Num5", SqlDbType.Int)
{
Value = multipurpose_entity.Num5
};
multipurpose_entity.Sqlprms[13] = new SqlParameter("@Date1", SqlDbType.VarChar)
{
Value = multipurpose_entity.Date1
};
multipurpose_entity.Sqlprms[14] = new SqlParameter("@Date2", SqlDbType.VarChar)
{
Value = multipurpose_entity.Date2
};
multipurpose_entity.Sqlprms[15] = new SqlParameter("@Date3", SqlDbType.VarChar)
{
Value = multipurpose_entity.Date3
};
multipurpose_entity.Sqlprms[16] = new SqlParameter("@InsertOperator", SqlDbType.VarChar)
{
Value = multipurpose_entity.InsertOperator
};
multipurpose_entity.Sqlprms[17] = new SqlParameter("@UpdateOperator", SqlDbType.VarChar)
{
Value = multipurpose_entity.UpdateOperator
};
multipurpose_entity.Sqlprms[18] = new SqlParameter("@Mode", SqlDbType.VarChar)
{
Value = multipurpose_entity.Mode
};
multipurpose_entity.Sqlprms[19] = new SqlParameter("@Program", SqlDbType.VarChar)
{
Value = multipurpose_entity.ProgramID
};
multipurpose_entity.Sqlprms[20] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = multipurpose_entity.PC
};
multipurpose_entity.Sqlprms[21] = new SqlParameter("@KeyItem", SqlDbType.VarChar)
{
Value = multipurpose_entity.KeyItem
};
DataTable dt = ckmdl.SelectDatatable("M_Multiporpose_Insert_Update", GetConnectionString(), multipurpose_entity.Sqlprms);
return(dt);
}
private (bool, DataTable) TextBoxErrorCheck(STextBox sTextBox)
{
DataTable rDt = new DataTable();
if (sTextBox.E101 && !string.IsNullOrWhiteSpace(sTextBox.Text))
{
string result = string.Empty;
switch (sTextBox.E101Type)
{
case "souko":
SoukoBL bl = new SoukoBL();
rDt = bl.Souko_Select(sTextBox.ctrlE101_1.Text, "E101");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "M_Staff":
StaffBL sBL = new StaffBL();
rDt = sBL.Staff_Select_Check(sTextBox.ctrlE101_1.Text, sTextBox.ctrlE101_2.Text, "E101");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "M_Tokuisaki":
TokuisakiBL tBL = new TokuisakiBL();
rDt = tBL.M_Tokuisaki_Select(sTextBox.ctrlE101_1.Text, sTextBox.ctrlE101_2.Text, "E101");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "M_Kouriten":
KouritenBL kBL = new KouritenBL();
rDt = kBL.Kouriten_Select_Check(sTextBox.ctrlE101_1.Text, sTextBox.ctrlE101_2.Text, "E101");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "M_Siiresaki":
SiiresakiBL BL = new SiiresakiBL();
rDt = BL.Siiresaki_Select_Check(sTextBox.ctrlE101_1.Text, sTextBox.ctrlE101_2.Text, "E101");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "M_Shouhin":
ShouhinBL shouhin = new ShouhinBL();
string id = string.Empty;
switch (sTextBox.ctrlE101_1.Name)
{
case "txtTani":
id = "102";
break;
case "txtBrand":
id = "103";
break;
case "txtColor":
id = "104";
break;
case "txtCopyColor":
id = "104";
break;
case "txtSize":
id = "105";
break;
case "txtCopySize":
id = "105";
break;
case "txtIEvaluation":
id = "106";
break;
case "txtIManagement":
id = "107";
break;
case "txtTaxRate":
id = "221";
break;
}
rDt = shouhin.Shouhin_Check(id, sTextBox.ctrlE101_1.Text, string.Empty, string.Empty, "E101");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "HikiateHenkouShoukai":
switch (sTextBox.ctrlE101_1.Name)
{
case "txtTokuisakiCD":
TokuisakiBL tokuisakiBL = new TokuisakiBL();
rDt = tokuisakiBL.M_Tokuisaki_Select(sTextBox.ctrlE101_1.Text, sTextBox.E102Type, "E101");
break;
case "txtKouritenCD":
KouritenBL kouritenbl = new KouritenBL();
rDt = kouritenbl.Kouriten_Select_Check(sTextBox.ctrlE101_1.Text, sTextBox.E102Type, "E101");
break;
}
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "M_MultiPorpose":
multipurposeEntity m_obj = new multipurposeEntity();
int multiVal = 0;
if (sTextBox.SearchType == SearchType.ScType.Brand)
{
multiVal = 103;
}
else if (sTextBox.SearchType == SearchType.ScType.Partition)
{
multiVal = 101;
}
else if (sTextBox.SearchType == SearchType.ScType.Tani)
{
multiVal = 102;
}
else if (sTextBox.SearchType == SearchType.ScType.Color)
{
multiVal = 104;
}
else if (sTextBox.SearchType == SearchType.ScType.Size)
{
multiVal = 105;
}
else if (sTextBox.SearchType == SearchType.ScType.TaxRate)
{
multiVal = 221;
}
else if (sTextBox.SearchType == SearchType.ScType.Evaluation)
{
multiVal = 106;
}
else if (sTextBox.SearchType == SearchType.ScType.Management)
{
multiVal = 107;
}
else if (sTextBox.SearchType == SearchType.ScType.Kubun)
{
multiVal = 109;
}
m_obj.id = multiVal;
m_obj.ErrorType = "E101";
m_obj.Key = sTextBox.ctrlE101_1.Text;
multipurposeBL m_BL = new multipurposeBL();
rDt = m_BL.GetPosition(m_obj);
result = rDt.Rows[0]["MessageID"].ToString();
break;
}
if (result.Equals("E101"))
{
ShowErrorMessage("E101");
sTextBox.Text = string.Empty;
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E102)
{
if (string.IsNullOrWhiteSpace(sTextBox.Text))
{
ShowErrorMessage("E102");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E102Multi)
{
if (string.IsNullOrWhiteSpace(sTextBox.ctrlE102_1.Text) && !string.IsNullOrWhiteSpace(sTextBox.ctrlE102_2.Text))
{
ShowErrorMessage("E102");
sTextBox.ctrlE102_1.Focus();
return(true, rDt);
}
else if (!string.IsNullOrWhiteSpace(sTextBox.ctrlE102_1.Text) && string.IsNullOrWhiteSpace(sTextBox.ctrlE102_2.Text))
{
ShowErrorMessage("E102");
sTextBox.ctrlE102_2.Focus();
return(true, rDt);
}
}
if (sTextBox.E103)
{
cf = new CommonFunction();
if (!cf.DateCheck(sTextBox))
{
ShowErrorMessage("E103");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E104)
{
if (cf.CheckDateValue(sTextBox.ctrlE104_2.Text) && cf.CheckDateValue(sTextBox.ctrlE104_1.Text))
{
//if(!string.IsNullOrEmpty(sTextBox.ctrlE104_2.Text) && !string.IsNullOrEmpty(sTextBox.ctrlE104_1.Text))
//{
DateTime LDate = Convert.ToDateTime(sTextBox.ctrlE104_2.Text);
DateTime JDate = Convert.ToDateTime(sTextBox.ctrlE104_1.Text);
if (JDate.Date > LDate.Date)
{
ShowErrorMessage("E104");
sTextBox.Focus();
return(true, rDt);
}
}
}
if (sTextBox.E106)
{
if (!string.IsNullOrEmpty(sTextBox.ctrlE106_1.Text) && !string.IsNullOrEmpty(sTextBox.ctrlE106_2.Text))
{
bool bl = Matches(sTextBox.ctrlE106_2.Text, sTextBox.ctrlE106_1.Text);
if (!bl)
{
ShowErrorMessage("E106");
sTextBox.Focus();
return(true, rDt);
}
}
}
if (sTextBox.E115)
{
string result = string.Empty;
switch (sTextBox.E115Type)
{
case "JuchuuNyuuryoku":
JuchuuListBL jbl = new JuchuuListBL();
rDt = jbl.JuchuuNyuuryoku_Select_Check(string.Empty, sTextBox.ctrlE115_1.Text, "E115");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "ShukkaSiziNyuuryoku":
ShukkasiziNyuuryokuBL skszbl = new ShukkasiziNyuuryokuBL();
rDt = skszbl.ShukkasiziNyuuryoku_ErrorCheck(sTextBox.ctrlE115_1.Text, "E115");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "ShukkaNyuuryoku":
ShukkaNyuuryokuBL sbl = new ShukkaNyuuryokuBL();
rDt = sbl.ShukkaNyuuryoku_Select_Check(string.Empty, sTextBox.ctrlE115_1.Text, "E115");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "ChakuniNyuuryoku":
chakuniNyuuryoku_BL cbl = new chakuniNyuuryoku_BL();
rDt = cbl.ChakuniNyuuryoku_Select(string.Empty, sTextBox.ctrlE115_1.Text, "E115");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "IdouNyuuryoku":
IdouNyuuryokuBL ibl = new IdouNyuuryokuBL();
rDt = ibl.IdouNyuuryoku_Select_Check(string.Empty, sTextBox.ctrlE115_1.Text, "E115");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "ChakuniYoteiNyuuryoku":
ChakuniYoteiNyuuryoku_BL cybl = new ChakuniYoteiNyuuryoku_BL();
rDt = cybl.ChakuniYoteiNyuuryoku_Select(string.Empty, sTextBox.ctrlE115_1.Text, "E115");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "HacchuuNyuuryoku":
HacchuuNyuuryokuBL h_bl = new HacchuuNyuuryokuBL();
rDt = h_bl.HacchuuNyuuryoku_Select_Check(string.Empty, sTextBox.ctrlE115_1.Text, "E115");
result = rDt.Rows[0]["MessageID"].ToString();
break;
}
if (result.Equals("E115"))
{
ShowErrorMessage("E115");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E132)
{
string result = string.Empty;
DataTable dt = new DataTable();
switch (sTextBox.E132Type)
{
case "souko":
SoukoBL bl = new SoukoBL();
rDt = bl.Souko_Select(sTextBox.ctrlE132_1.Text, "E132");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "M_Staff":
StaffBL sBL = new StaffBL();
dt = sBL.Staff_Select_Check(sTextBox.ctrlE132_1.Text, sTextBox.ctrlE132_2.Text, string.Empty);
rDt = dt;
result = dt.Rows[0]["MessageID"].ToString();
break;
case "M_Siiresaki":
SiiresakiBL obj = new SiiresakiBL();
dt = obj.Siiresaki_Select_Check(sTextBox.ctrlE132_1.Text, sTextBox.ctrlE132_2.Text, string.Empty);
rDt = dt;
result = dt.Rows[0]["MessageID"].ToString();
break;
case "M_Tokuisaki":
TokuisakiBL tokuisakiBL = new TokuisakiBL();
dt = tokuisakiBL.M_Tokuisaki_Select(sTextBox.ctrlE132_1.Text, sTextBox.ctrlE132_2.Text, string.Empty);
rDt = dt;
result = dt.Rows[0]["MessageID"].ToString();
break;
case "M_Kouriten":
KouritenBL objK = new KouritenBL();
dt = objK.Kouriten_Select_Check(sTextBox.ctrlE132_1.Text, sTextBox.ctrlE132_2.Text, string.Empty, sTextBox.ctrlE132_3.Text);
rDt = dt;
result = dt.Rows[0]["MessageID"].ToString();
break;
case "ChakuniNyuuryoku":
chakuniNyuuryoku_BL cbl = new chakuniNyuuryoku_BL();
dt = cbl.ChakuniNyuuryoku_Select(sTextBox.ctrlE132_1.Text, null, string.Empty);
rDt = dt;
result = dt.Rows[0]["MessageID"].ToString();
break;
case "ChakuniYoteiNyuuryoku":
ChakuniYoteiNyuuryoku_BL cybl = new ChakuniYoteiNyuuryoku_BL();
dt = cybl.ChakuniYoteiNyuuryoku_Select(sTextBox.ctrlE132_1.Text, null, string.Empty);
rDt = dt;
result = dt.Rows[0]["MessageID"].ToString();
break;
case "denpyou":
DenpyouNOEntity denpyou_entity = new DenpyouNOEntity();
DenpyouNOBL denpyou_bl = new DenpyouNOBL();
denpyou_entity.RenbenKBN = sTextBox.ctrl_combo.SelectedValue.ToString();
denpyou_entity.seqno = sTextBox.ctrlE132_2.Text.ToString();
denpyou_entity.prefix = sTextBox.ctrlE132_1.Text;
denpyou_entity.MessageID = "E132";
rDt = denpyou_bl.DenpyouNO_Check(denpyou_entity);
result = rDt.Rows[0]["MessageID"].ToString();
break;
}
if (result.Equals("E132"))
{
ShowErrorMessage("E132");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E132Multi)
{
string result = string.Empty;
switch (sTextBox.E132Type)
{
case "M_Shouhin":
ShouhinBL shouhin = new ShouhinBL();
rDt = shouhin.Shouhin_Check(sTextBox.ctrlE132_1.Text, sTextBox.ctrlE132_2.Text, sTextBox.ctrlE132_3.Text, sTextBox.ctrlE132_4.Text, string.Empty);
result = rDt.Rows[0]["MessageID"].ToString();
break;
}
if (result.Equals("E132"))
{
ShowErrorMessage("E132");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E133)
{
DataTable dt = new DataTable();
string result = string.Empty;
StaffBL sBL = new StaffBL();
switch (sTextBox.E133Type)
{
case "M_Staff":
if (!string.IsNullOrEmpty(sTextBox.ctrlE133_1.Text) && !string.IsNullOrEmpty(sTextBox.ctrlE133_2.Text))
{
dt = sBL.Staff_Select_Check(sTextBox.ctrlE133_1.Text, sTextBox.ctrlE133_2.Text, string.Empty);
rDt = dt;
result = dt.Rows[0]["MessageID"].ToString();
}
break;
case "M_Siiresaki":
if (!string.IsNullOrEmpty(sTextBox.ctrlE133_1.Text) && !string.IsNullOrEmpty(sTextBox.ctrlE133_2.Text))
{
SiiresakiBL obj = new SiiresakiBL();
dt = obj.Siiresaki_Select_Check(sTextBox.ctrlE133_1.Text, sTextBox.ctrlE133_2.Text, string.Empty);
rDt = dt;
result = dt.Rows[0]["MessageID"].ToString();
}
break;
case "M_Tokuisaki":
if (!string.IsNullOrEmpty(sTextBox.ctrlE133_1.Text) && !string.IsNullOrEmpty(sTextBox.ctrlE133_2.Text))
{
TokuisakiBL tokuisakiBL = new TokuisakiBL();
dt = tokuisakiBL.M_Tokuisaki_Select(sTextBox.ctrlE133_1.Text, sTextBox.ctrlE133_2.Text, string.Empty);
rDt = dt;
result = dt.Rows[0]["MessageID"].ToString();
}
break;
case "M_Kouriten":
if (!string.IsNullOrEmpty(sTextBox.ctrlE133_1.Text) && !string.IsNullOrEmpty(sTextBox.ctrlE133_2.Text))
{
KouritenBL objK = new KouritenBL();
dt = objK.Kouriten_Select_Check(sTextBox.ctrlE133_1.Text, sTextBox.ctrlE133_2.Text, string.Empty, sTextBox.ctrlE133_3.Text);
rDt = dt;
result = dt.Rows[0]["MessageID"].ToString();
}
break;
case "denpyou":
DenpyouNOEntity denpyou_entity = new DenpyouNOEntity();
DenpyouNOBL denpyou_bl = new DenpyouNOBL();
denpyou_entity.RenbenKBN = sTextBox.ctrl_combo.SelectedValue.ToString();
denpyou_entity.seqno = sTextBox.ctrlE133_2.Text;
denpyou_entity.prefix = sTextBox.ctrlE133_1.Text;
denpyou_entity.MessageID = "E133";
rDt = denpyou_bl.DenpyouNO_Check(denpyou_entity);
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "ChakuniNyuuryoku":
chakuniNyuuryoku_BL cbl = new chakuniNyuuryoku_BL();
dt = cbl.ChakuniNyuuryoku_Select(sTextBox.ctrlE133_1.Text, string.Empty, "E133");
rDt = dt;
result = dt.Rows[0]["MessageID"].ToString();
break;
case "ChakuniYotei":
chakuniNyuuryoku_BL bl = new chakuniNyuuryoku_BL();
dt = bl.ChakuniNyuuryoku_Select(sTextBox.ctrlE133_1.Text, string.Empty, "E133");
rDt = dt;
result = dt.Rows[0]["MessageID"].ToString();
break;
case "ChakuniYoteiNyuuryoku":
ChakuniYoteiNyuuryoku_BL cybl = new ChakuniYoteiNyuuryoku_BL();
dt = cybl.ChakuniYoteiNyuuryoku_Select(sTextBox.ctrlE133_1.Text, string.Empty, "E133");
rDt = dt;
result = dt.Rows[0]["MessageID"].ToString();
break;
case "JuchuuNyuuryoku":
if (!string.IsNullOrEmpty(sTextBox.ctrlE133_1.Text))
{
JuchuuListBL jbl = new JuchuuListBL();
rDt = jbl.JuchuuNyuuryoku_Select_Check(sTextBox.ctrlE133_1.Text, string.Empty, string.Empty);
result = rDt.Rows[0]["MessageID"].ToString();
}
break;
case "ShukkaSiziNyuuryoku":
ShukkasiziNyuuryokuBL skszbl = new ShukkasiziNyuuryokuBL();
rDt = skszbl.ShukkasiziNyuuryoku_ErrorCheck(sTextBox.ctrlE133_1.Text, "E133");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "ShukkaNyuuryoku":
ShukkaNyuuryokuBL sbl = new ShukkaNyuuryokuBL();
rDt = sbl.ShukkaNyuuryoku_Select_Check(sTextBox.ctrlE133_1.Text, string.Empty, "E133");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "HikiateHenkouShoukai":
if (!string.IsNullOrEmpty(sTextBox.ctrlE133_1.Text.Trim()))
{
HikiateHenkouShoukaiBL hikiateHenkouShoukaiBL = new HikiateHenkouShoukaiBL();
rDt = hikiateHenkouShoukaiBL.Error_Check(sTextBox.ctrlE133_1.Text, string.Empty, "E133");
result = rDt.Rows[0]["MessageID"].ToString();
}
break;
case "IdouNyuuryoku":
if (!string.IsNullOrEmpty(sTextBox.ctrlE133_1.Text))
{
string errType = string.Empty;
if (sTextBox.ctrlE133_1.Name.Contains("Copy"))
{
errType = "Copy";
}
IdouNyuuryokuBL ibl = new IdouNyuuryokuBL();
rDt = ibl.IdouNyuuryoku_Select_Check(sTextBox.ctrlE133_1.Text, string.Empty, errType);
result = rDt.Rows[0]["MessageID"].ToString();
}
break;
case "HacchuuNyuuryoku":
if (!string.IsNullOrEmpty(sTextBox.ctrlE133_1.Text))
{
string errType = string.Empty;
if (sTextBox.ctrlE133_1.Name.Contains("Copy"))
{
errType = "Copy";
}
HacchuuNyuuryokuBL h_bl = new HacchuuNyuuryokuBL();
rDt = h_bl.HacchuuNyuuryoku_Select_Check(sTextBox.ctrlE133_1.Text, string.Empty, errType);
result = rDt.Rows[0]["MessageID"].ToString();
}
break;
}
if (result.Equals("E133"))
{
ShowErrorMessage("E133");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E133Multi)
{
string result = string.Empty;
switch (sTextBox.E133Type)
{
case "M_Shouhin":
if (!string.IsNullOrWhiteSpace(sTextBox.ctrlE133_1.Text) && !string.IsNullOrWhiteSpace(sTextBox.ctrlE133_2.Text))
{
ShouhinBL shouhin = new ShouhinBL();
rDt = shouhin.Shouhin_Check(sTextBox.ctrlE133_1.Text, sTextBox.ctrlE133_2.Text, sTextBox.ctrlE133_3.Text, sTextBox.ctrlE133_4.Text, string.Empty);
result = rDt.Rows[0]["MessageID"].ToString();
}
break;
}
if (result.Equals("E133"))
{
ShowErrorMessage("E133");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E135)
{
string result = string.Empty;
switch (sTextBox.E135Type)
{
case "M_Staff":
if (!string.IsNullOrEmpty(sTextBox.ctrlE135_1.Text) && !string.IsNullOrEmpty(sTextBox.ctrlE135_2.Text))
{
StaffBL bl = new StaffBL();
rDt = bl.Staff_Select_Check(sTextBox.ctrlE135_1.Text, sTextBox.ctrlE135_2.Text, "E135");
result = rDt.Rows[0]["MessageID"].ToString();
}
break;
}
if (result.Equals("E135"))
{
ShowErrorMessage("E135");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E159)
{
string result = string.Empty;
switch (sTextBox.E159Type)
{
case "ChakuniNyuuryoku":
chakuniNyuuryoku_BL cbl = new chakuniNyuuryoku_BL();
rDt = cbl.ChakuniNyuuryoku_Select(sTextBox.ctrlE159_1.Text, string.Empty, "E159");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "ShukkaSiziNyuuryoku":
ShukkasiziNyuuryokuBL skszbl = new ShukkasiziNyuuryokuBL();
rDt = skszbl.ShukkasiziNyuuryoku_ErrorCheck(sTextBox.ctrlE159_1.Text, "E159");
result = rDt.Rows[0]["MessageID"].ToString();
break;
}
if (result.Equals("E159"))
{
ShowErrorMessage("E159");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E160)
{
string result = string.Empty;
switch (sTextBox.E160Type)
{
case "ChakuniYoteiNyuuryoku":
ChakuniYoteiNyuuryoku_BL cybl = new ChakuniYoteiNyuuryoku_BL();
rDt = cybl.ChakuniYoteiNyuuryoku_Select(sTextBox.ctrlE160_1.Text, string.Empty, "E160");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "JuchuuNyuuryoku":
JuchuuListBL jbl = new JuchuuListBL();
rDt = jbl.JuchuuNyuuryoku_Select_Check(sTextBox.ctrlE160_1.Text, string.Empty, "E160");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "ShukkaSiziNyuuryoku":
ShukkasiziNyuuryokuBL skszbl = new ShukkasiziNyuuryokuBL();
rDt = skszbl.ShukkasiziNyuuryoku_ErrorCheck(sTextBox.ctrlE160_1.Text, "E160");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "ShukkaNyuuryoku":
ShukkaNyuuryokuBL sbl = new ShukkaNyuuryokuBL();
rDt = sbl.ShukkaNyuuryoku_Select_Check(sTextBox.ctrlE160_1.Text, string.Empty, "E160");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "JuchuuTorikomi":
JuchuuTorikomiBL jubl = new JuchuuTorikomiBL();
rDt = jubl.JuchuuTorikomi_Error_Check(sTextBox.ctrlE160_1.Text, "E160");
result = rDt.Rows[0]["MessageID"].ToString();
break;
}
if (result.Equals("E160"))
{
ShowErrorMessage("E160");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E165)
{
string result = string.Empty;
switch (sTextBox.E165Type)
{
case "ShukkaTorikom":
ShukkaTorikomi_BL sbl = new ShukkaTorikomi_BL();
rDt = sbl.ShukkaTorikomi_Error_Check(sTextBox.ctrlE165_1.Text, "E165");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "ShukkaNyuuryoku":
ShukkaNyuuryokuBL skbl = new ShukkaNyuuryokuBL();
rDt = skbl.ShukkaNyuuryoku_Select_Check(sTextBox.ctrlE165_1.Text, string.Empty, "E165");
result = rDt.Rows[0]["MessageID"].ToString();
break;
}
if (result.Equals("E165"))
{
bbl.ShowMessage("E165");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E166)
{
if (!sTextBox.ctrlE166_1.Text.Equals(sTextBox.ctrlE166_2.Text))
{
ShowErrorMessage("E166");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E227)
{
string result = string.Empty;
switch (sTextBox.E227Type)
{
case "M_Tokuisaki":
TokuisakiBL t_bl = new TokuisakiBL();
rDt = t_bl.M_Tokuisaki_Select(sTextBox.ctrlE227_1.Text, sTextBox.ctrlE227_2.Text, "E227");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "M_Kouriten":
KouritenBL k_bl = new KouritenBL();
rDt = k_bl.Kouriten_Select_Check(sTextBox.ctrlE227_1.Text, sTextBox.ctrlE227_2.Text, "E227");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "M_Siiresaki":
SiiresakiBL obj = new SiiresakiBL();
rDt = obj.Siiresaki_Select_Check(sTextBox.ctrlE227_1.Text, sTextBox.ctrlE227_2.Text, "E227");
result = rDt.Rows[0]["MessageID"].ToString();
break;
}
if (result.Equals("E227"))
{
bbl.ShowMessage("E227", "取引終了日");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E265)
{
string result = string.Empty;
switch (sTextBox.E265Type)
{
case "HacchuuNyuuryoku":
HacchuuNyuuryokuBL H_bl = new HacchuuNyuuryokuBL();
rDt = H_bl.HacchuuNyuuryoku_Select_Check(sTextBox.ctrlE266_1.Text, string.Empty, "E265");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "JuchuuTorikomi":
JuchuuTorikomiBL jubl = new JuchuuTorikomiBL();
rDt = jubl.JuchuuTorikomi_Error_Check(sTextBox.ctrlE265_1.Text, "E265");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "JuchuuNyuuryoku":
JuchuuListBL jbl = new JuchuuListBL();
rDt = jbl.JuchuuNyuuryoku_Select_Check(sTextBox.ctrlE265_1.Text, string.Empty, "E265");
result = rDt.Rows[0]["MessageID"].ToString();
break;
}
if (result.Equals("E265"))
{
bbl.ShowMessage("E265");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E266)
{
string result = string.Empty;
switch (sTextBox.E266Type)
{
case "HacchuuNyuuryoku":
HacchuuNyuuryokuBL H_bl = new HacchuuNyuuryokuBL();
rDt = H_bl.HacchuuNyuuryoku_Select_Check(sTextBox.ctrlE266_1.Text, string.Empty, "E266");
result = rDt.Rows[0]["MessageID"].ToString();
break;
}
if (result.Equals("E266"))
{
bbl.ShowMessage("E266");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E267)
{
string result = string.Empty;
switch (sTextBox.E267Type)
{
case "M_Tokuisaki":
TokuisakiBL t_bl = new TokuisakiBL();
rDt = t_bl.M_Tokuisaki_Select(sTextBox.ctrlE267_1.Text, sTextBox.ctrlE267_2.Text, "E267");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "M_Kouriten":
KouritenBL k_bl = new KouritenBL();
rDt = k_bl.Kouriten_Select_Check(sTextBox.ctrlE267_1.Text, sTextBox.ctrlE267_2.Text, "E267");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "M_Siiresaki":
SiiresakiBL obj = new SiiresakiBL();
rDt = obj.Siiresaki_Select_Check(sTextBox.ctrlE267_1.Text, sTextBox.ctrlE267_2.Text, "E267");
result = rDt.Rows[0]["MessageID"].ToString();
break;
}
if (result.Equals("E267"))
{
bbl.ShowMessage("E267", "取引開始日");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E268)
{
string result = string.Empty;
DataTable dt = new DataTable();
switch (sTextBox.E268Type)
{
case "ChakuniNyuuryoku":
chakuniNyuuryoku_BL cbl = new chakuniNyuuryoku_BL();
rDt = cbl.ChakuniNyuuryoku_Select(sTextBox.ctrlE268_1.Text, string.Empty, "E268");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "ChakuniYotei":
chakuniNyuuryoku_BL bl = new chakuniNyuuryoku_BL();
rDt = bl.ChakuniNyuuryoku_ErrorCheck(sTextBox.ctrlE268_1.Text, string.Empty, "E268");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "ChakuniYoteiNyuuryoku":
ChakuniYoteiNyuuryoku_BL cybl = new ChakuniYoteiNyuuryoku_BL();
rDt = cybl.ChakuniYoteiNyuuryoku_Select(sTextBox.ctrlE268_1.Text, string.Empty, "E268");
result = rDt.Rows[0]["MessageID"].ToString();
break;
}
if (result.Equals("E268"))
{
ShowErrorMessage("E268");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E270)
{
string result = string.Empty;
switch (sTextBox.E270Type)
{
case "souko":
if (!string.IsNullOrEmpty(sTextBox.ctrlE270_1.Text))
{
SoukoBL sBL = new SoukoBL();
rDt = sBL.Souko_Select(sTextBox.ctrlE270_1.Text, "E270");
result = rDt.Rows[0]["MessageID"].ToString();
}
break;
case "M_Staff":
if (!string.IsNullOrEmpty(sTextBox.ctrlE270_1.Text) && !string.IsNullOrEmpty(sTextBox.ctrlE270_2.Text))
{
StaffBL sBL = new StaffBL();
rDt = sBL.Staff_Select_Check(sTextBox.ctrlE270_1.Text, sTextBox.ctrlE270_2.Text, "E270");
result = rDt.Rows[0]["MessageID"].ToString();
}
break;
case "M_Siiresaki":
if (!string.IsNullOrEmpty(sTextBox.ctrlE270_1.Text) && !string.IsNullOrEmpty(sTextBox.ctrlE270_2.Text))
{
SiiresakiBL obj = new SiiresakiBL();
rDt = obj.Siiresaki_Select_Check(sTextBox.ctrlE270_1.Text, sTextBox.ctrlE270_2.Text, "E270");
result = rDt.Rows[0]["MessageID"].ToString();
}
break;
case "M_Tokuisaki":
if (!string.IsNullOrEmpty(sTextBox.ctrlE270_1.Text) && !string.IsNullOrEmpty(sTextBox.ctrlE270_2.Text))
{
TokuisakiBL tBL = new TokuisakiBL();
rDt = tBL.M_Tokuisaki_Select(sTextBox.ctrlE270_1.Text, sTextBox.ctrlE270_2.Text, "E270");
result = rDt.Rows[0]["MessageID"].ToString();
}
break;
case "M_Kouriten":
if (!string.IsNullOrEmpty(sTextBox.ctrlE270_1.Text) && !string.IsNullOrEmpty(sTextBox.ctrlE270_2.Text))
{
KouritenBL objK = new KouritenBL();
rDt = objK.Kouriten_Select_Check(sTextBox.ctrlE270_1.Text, sTextBox.ctrlE270_2.Text, "E270", sTextBox.ctrlE270_3.Text);
result = rDt.Rows[0]["MessageID"].ToString();
}
break;
}
if (result.Equals("E270"))
{
ShowErrorMessage("E270");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E270Multi)
{
string result = string.Empty;
switch (sTextBox.E270Type)
{
case "M_Shouhin":
if (!string.IsNullOrWhiteSpace(sTextBox.ctrlE270_1.Text) && !string.IsNullOrWhiteSpace(sTextBox.ctrlE270_2.Text))
{
ShouhinBL shouhin = new ShouhinBL();
rDt = shouhin.Shouhin_Check(sTextBox.ctrlE270_1.Text, sTextBox.ctrlE270_2.Text, sTextBox.ctrlE270_3.Text, sTextBox.ctrlE270_4.Text, "E270");
result = rDt.Rows[0]["MessageID"].ToString();
}
break;
}
if (result.Equals("E270"))
{
ShowErrorMessage("E270");
sTextBox.Focus();
return(true, rDt);
}
}
//HET
if (sTextBox.E279)
{
switch (sTextBox.E279Type)
{
case "IdouNyuuryoku":
if (sTextBox.ctrlE279_1.Text.ToString() == "3" && sTextBox.ctrlE279_2.Text.ToString() == sTextBox.ctrlE279_3.Text.ToString())
{
sTextBox.Focus();
bbl.ShowMessage("E279");
return(true, rDt);
}
break;
}
}
if (sTextBox.E280)
{
string result = string.Empty;
switch (sTextBox.E280Type)
{
case "ChakuniNyuuryoku":
chakuniNyuuryoku_BL bl = new chakuniNyuuryoku_BL();
rDt = bl.ChakuniNyuuryoku_Select(sTextBox.ctrlE280_1.Text, string.Empty, "E280");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "ShukkaSiziNyuuryoku":
ShukkasiziNyuuryokuBL skszbl = new ShukkasiziNyuuryokuBL();
rDt = skszbl.ShukkasiziNyuuryoku_ErrorCheck(sTextBox.ctrlE280_1.Text, "E280");
result = rDt.Rows[0]["MessageID"].ToString();
break;
case "ShukkaNyuuryoku":
ShukkaNyuuryokuBL sbl = new ShukkaNyuuryokuBL();
rDt = sbl.ShukkaNyuuryoku_Select_Check(sTextBox.ctrlE280_1.Text, string.Empty, "E280");
result = rDt.Rows[0]["MessageID"].ToString();
break;
}
if (result.Equals("E280"))
{
ShowErrorMessage("E280");
sTextBox.Focus();
return(true, rDt);
}
}
if (sTextBox.E128)
{
if (!System.IO.File.Exists(sTextBox.ctrlE128_1.Text) && !string.IsNullOrEmpty(sTextBox.ctrlE128_1.Text.Trim()))
{
sTextBox.Focus();
sTextBox.ctrlE128_2.ImageLocation = "";
sTextBox.ctrlE128_2.Image = null;
bbl.ShowMessage("E128");
return(true, rDt);
}
}
if (sTextBox.CYuubin_Juusho)
{
if (!string.IsNullOrEmpty(sTextBox.ctrl1Yuubin_Juusho.Text) && !string.IsNullOrEmpty(sTextBox.ctrl2Yuubin_Juusho.Text))
{
if ((sTextBox.ctrl1Yuubin_Juusho.Text != sTextBox.check1Yuubin_Juusho || sTextBox.ctrl2Yuubin_Juusho.Text != sTextBox.check2Yuubin_Juusho))
{
YuubinNOBL obj = new YuubinNOBL();
YuubinNOEntity entity = new YuubinNOEntity();
entity.YuubinNO1 = sTextBox.ctrl1Yuubin_Juusho.Text;
entity.YuubinNO2 = sTextBox.ctrl2Yuubin_Juusho.Text;
rDt = obj.Yuubin_Search(entity);
}
}
}
return(false, rDt);
}
private void DoDelete(multipurposeEntity mentity)
{
mbl.M_Multiporpose_Insert_Update(mentity);
bbl.ShowMessage("I102");
}
private void txtKEYCopy_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter && cboMode.SelectedValue.ToString() == "1")
{
DataTable dt = new DataTable();
multipurposeEntity mentity = new multipurposeEntity();
if (cboMode.SelectedValue.ToString() == "1")
{
//error check 183 ktp
dt = mbl.M_Multiporpose_SelectData(string.Empty, 2, txtID.Text, txtKEY.Text);
if (dt.Rows.Count > 0)
{
bbl.ShowMessage("E132");
txtKEY.Focus();
}
else if (ErrorCheck(PanelTitle))
{
if (!string.IsNullOrEmpty(txtCopyID.Text) && !string.IsNullOrEmpty(txtKEYCopy.Text))
{
mentity.ID = txtCopyID.Text;
mentity.Key = txtKEYCopy.Text;
dt = mbl.M_Multiporpose_SelectData(string.Empty, 2, txtCopyID.Text, txtKEYCopy.Text);
if (dt.Rows.Count > 0)
{
DisplayData(dt);
cf.EnablePanel(PanelDetail);
txtIDName.Focus();
cf.DisablePanel(PanelTitle);
}
else
{
bbl.ShowMessage("E133");
txtKEYCopy.Focus();
}
}
else if (string.IsNullOrEmpty(txtCopyID.Text) && !string.IsNullOrEmpty(txtKEYCopy.Text))
{
bbl.ShowMessage("E102");
txtCopyID.Focus();
}
else if (!string.IsNullOrEmpty(txtCopyID.Text) && string.IsNullOrEmpty(txtKEYCopy.Text))
{
bbl.ShowMessage("E102");
txtKEYCopy.Focus();
}
else
{
cf.EnablePanel(PanelDetail);
txtIDName.Focus();
cf.DisablePanel(PanelTitle);
}
}
else if (string.IsNullOrEmpty(txtCopyID.Text) && string.IsNullOrEmpty(txtKEYCopy.Text))
{
cf.EnablePanel(PanelDetail);
cf.DisablePanel(PanelTitle);
txtIDName.Focus();
}
else if (string.IsNullOrEmpty(txtCopyID.Text) || string.IsNullOrEmpty(txtKEYCopy.Text))
{
bbl.ShowMessage("E133");
txtCopyID.Focus();
}
}
}
}
