protected override void ExecDisp()
{
//if (CboStoreCD.SelectedValue == null)
// return;
M_StoreClose_Entity me = new M_StoreClose_Entity
{
StoreCD = CboStoreCD.SelectedValue == null ? "": CboStoreCD.SelectedValue.ToString(),
FiscalYYYYMM = lblChangeDate.Text.Replace("/", ""),
Operator = InOperatorCD,
Mode = Mode
};
if (Mode.Equals(1))
{
M_Store_Entity mse = new M_Store_Entity();
mse.ChangeDate = gsbl.GetDate();
me.StoreCD = gsbl.GetHonsha(mse);
}
bool ret = gsbl.M_StoreClose_SelectAll(me);
if (!ret)
{
//Insertしたあとに再度Select
ret = gsbl.M_StoreClose_SelectAll(me);
}
if (!string.IsNullOrWhiteSpace(me.FiscalYYYYMM))
{
lblChangeDate.Text = me.FiscalYYYYMM.Substring(0, 4) + "/" + me.FiscalYYYYMM.Substring(4, 2);
lblKakutei.Text = lblChangeDate.Text;
}
SetProperty(me.ClosePosition1, lblUriage, BtnUriage);
SetProperty(me.ClosePosition3, lblNyukin, BtnNyukin);
SetProperty(me.ClosePosition2, lblShiire, BtnShiire);
SetProperty(me.ClosePosition4, lblShiharai, BtnShiharai);
SetProperty(me.ClosePosition5, lblZaiko, BtnZaiko);
SetPropertyShukei(me.MonthlyClaimsFLG, lblSaiken, BtnSaiken);
SetPropertyShukei(me.MonthlyDebtFLG, lblSaimu, BtnSaimu);
SetPropertyShukei(me.MonthlyStockFLG, lblZaikoShukei, BtnZaikoShukei);
BtnAllShukei.Text = "まとめて\n計算する";
BtnKakutei.Text = "確定する(翌月度へ)";
BtnKaijo.Text = "解除する(前月度へ)";
if (me.ClosePosition1.Equals("1") && me.ClosePosition2.Equals("1") && me.ClosePosition3.Equals("1") && me.ClosePosition4.Equals("1") && me.ClosePosition5.Equals("1") &&
me.MonthlyClaimsFLG.Equals("1") && me.MonthlyDebtFLG.Equals("1") && me.MonthlyStockFLG.Equals("1"))
{
BtnKakutei.BackColor = Color.FromArgb(255, 192, 0);
BtnKakutei.Enabled = true;
BtnKaijo.Enabled = true;
}
else
{
BtnKakutei.BackColor = Color.FromArgb(255, 255, 0);
BtnKakutei.Enabled = false;
BtnKaijo.Enabled = true;
}
}
public DataTable M_Store_Select(M_Store_Entity mbe)
{
string sp = "M_Store_Select";
//command = new SqlCommand(sp, GetConnection());
//command.CommandType = CommandType.StoredProcedure;
//command.CommandTimeout = 0;
//command.Parameters.Add("@StoreCD", SqlDbType.VarChar).Value = mbe.StoreCD;
//command.Parameters.Add("@ChangeDate", SqlDbType.VarChar).Value = mbe.ChangeDate;
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.StoreCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mbe.ChangeDate
} },
};
return(SelectData(dic, sp));
//return SelectData(sp);
}
private bool CheckDetail(int index)
{
switch (index)
{
case (int)EIndex.StoreCD:
//入力なければチェックなし
if (detailControls[index].Text == "")
{
ScStore.LabelText = "";
return(true);
}
else
{
//ストアマスタデータチェック
Store_BL mbl = new Store_BL();
M_Store_Entity mse = new M_Store_Entity
{
StoreCD = detailControls[index].Text,
ChangeDate = ckM_Label1.Text
};
DataTable dt = mbl.M_Store_Select(mse);
if (dt.Rows.Count > 0)
{
ScStore.LabelText = dt.Rows[0]["StoreName"].ToString();
}
else
{
//Ｅ１３６
mbl.ShowMessage("E136");
ScStore.LabelText = "";
return(false);
}
}
break;
case (int)EIndex.StaffName:
break;
case (int)EIndex.StaffTo:
if (detailControls[index].Text != "")
{
int result = detailControls[index].Text.CompareTo(detailControls[index - 1].Text);
if (result < 0)
{
//Ｅ１０６
mbl.ShowMessage("E106");
detailControls[index].Focus();
return(false);
}
}
break;
}
return(true);
}
public DataTable GetHonsha(M_Store_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ChangeDate
} }
};
return(SelectData(dic, "SelectHonshaStore"));
}
public DataTable M_Store_BindData(M_Store_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = ""
} }
};
return(SelectData(dic, "M_Store_BindData"));
}
private DataTable StoreData()
{
storedata = new M_Store_Entity()
{
StoreCD = ScStore.Code,
ChangeDate = ScStore.ChangeDate
};
dtStore = mstaffBL.StoreCheck(storedata);
return(dtStore);
}
/// <summary>
/// 改定日として有効なレコードで違う店舗で同じAPIKeyがあればTrue
/// </summary>
/// <param name="mse"></param>
/// <returns></returns>
public bool Store_SelectByApiKey(M_Store_Entity mse)
{
DataTable dt = storedl.M_Store_SelectByApiKey(mse);
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public string GetHonsha(M_Store_Entity me)
{
M_Store_DL dl = new M_Store_DL();
DataTable dt = dl.GetHonsha(me);
if (dt.Rows.Count > 0)
{
me.StoreCD = dt.Rows[0]["StoreCD"].ToString();
return(me.StoreCD);
}
return("");
}
public M_Store_Entity M_Store_InitSelect(M_Staff_Entity mse, M_Store_Entity mste)
{
DataTable dt = mstoredl.M_Store_InitSelect(mse);
if (dt.Rows.Count > 0)
{
mste.StoreName = dt.Rows[0]["StoreName"].ToString();
mste.SysDate = dt.Rows[0]["sysDate"].ToString();
mste.StoreCD = dt.Rows[0]["StoreCD"].ToString();
Base_DL.iniEntity.DatabaseDate = mste.SysDate;
}
return(mste);
}
public bool M_Store_SelectByKbn(M_Store_Entity me)
{
M_Store_DL dl = new M_Store_DL();
DataTable dt = dl.M_Store_SelectByKbn(me);
if (dt.Rows.Count > 0)
{
me.StoreCD = dt.Rows[0]["StoreCD"].ToString();
return(true);
}
else
{
return(false);
}
}
public DataTable M_Store_SelectAll(M_Store_Entity mbe)
{
string sp = "M_Store_SelectAll";
//KTP 2019-0529 全部のFunctionでをしなくてもいいように共通のFunctionでやり方を更新しました。
//command = new SqlCommand(sp, GetConnection());
//command.CommandType = CommandType.StoredProcedure;
//command.CommandTimeout = 0;
//command.Parameters.Add("@DisplayKbn", SqlDbType.TinyInt).Value = mbe.DisplayKbn;
//command.Parameters.Add("@ChangeDate", SqlDbType.VarChar).Value = mbe.ChangeDate;
//command.Parameters.Add("@StoreCDFrom", SqlDbType.VarChar).Value = mbe.StoreCDFrom;
//command.Parameters.Add("@StoreCDTo", SqlDbType.VarChar).Value = mbe.StoreCDTo;
//command.Parameters.Add("@StoreName", SqlDbType.VarChar).Value = mbe.StoreName;
//command.Parameters.Add("@StoreKBN1", SqlDbType.TinyInt).Value = mbe.StoreKBN1;
//command.Parameters.Add("@StoreKBN2", SqlDbType.TinyInt).Value = mbe.StoreKBN2;
//command.Parameters.Add("@StoreKBN3", SqlDbType.TinyInt).Value = mbe.StoreKBN3;
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@DisplayKbn", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mbe.DisplayKbn
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.ChangeDate
} },
{ "@StoreCDFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.StoreCDFrom
} },
{ "@StoreCDTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.StoreCDTo
} },
{ "@StoreName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.StoreName
} },
{ "@StoreKBN1", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mbe.StoreKBN1
} },
{ "@StoreKBN2", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mbe.StoreKBN2
} },
{ "@StoreKBN3", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mbe.StoreKBN3
} },
};
//return SelectData(sp);
return(SelectData(dic, sp));
}
/// <summary>
/// Select Store's info
/// StoreKBN IN 1のStore情報をBind
/// </summary>
/// <param name="mse">staff info</param>
/// <returns></returns>
public DataTable M_Store_Bind_Juchu(M_Store_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.StoreCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mse.ChangeDate
} },
{ "@DeleteFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mse.DeleteFlg
} }
};
return(SelectData(dic, "M_Store_Bind_Juchu"));
}
public DataTable M_Store_SelectByApiKey(M_Store_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.StoreCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ChangeDate
} },
{ "@APIKey", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mse.APIKey
} }
};
return(SelectData(dic, "M_Store_SelectByApiKey"));
}
/// <summary>
/// EXEではなくFormとして起動した場合に必要な処理
/// </summary>
public void StartProgramForForm()
{
//[M_Staff]
M_Staff_Entity mse = new M_Staff_Entity
{
StaffCD = InOperatorCD
};
mse = loginbl.M_Staff_InitSelect(mse);
this.lblOperatorName.Text = mse.StaffName;
M_Store_Entity mste = new M_Store_Entity
{
SysDate = mse.SysDate
};
mste = loginbl.M_Store_InitSelect(mse, mste);
this.lblStoreName.Text = mste.StoreName;
}
/// Select Store's info
/// StoreKBN,StorePlaceKBNの条件でStore情報を取得
/// </summary>
/// <param name="mse">store info</param>
/// <returns></returns>
public DataTable M_Store_SelectByKbn(M_Store_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mse.StoreKBN
} },
{ "@StorePlaceKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mse.StorePlaceKBN
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mse.ChangeDate
} },
{ "@DeleteFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mse.DeleteFlg
} }
};
return(SelectData(dic, "M_Store_SelectByKbn"));
}
/// <summary>
/// 店舗マスタ取得処理
/// MasterTouroku_Tempoよりデータ抽出時に使用
/// </summary>
public DataTable M_Store_SelectData(M_Store_Entity mbe)
{
string sp = "M_Store_SelectData";
//KTP 2019-0529 全部のFunctionでをしなくてもいいように共通のFunctionでやり方を更新しました。
//command = new SqlCommand(sp, GetConnection());
//command.CommandType = CommandType.StoredProcedure;
//command.CommandTimeout = 0;
//command.Parameters.Add("@StoreCD", SqlDbType.VarChar).Value = mbe.StoreCD;
//command.Parameters.Add("@ChangeDate", SqlDbType.VarChar).Value = mbe.ChangeDate;
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.StoreCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.ChangeDate
} }
};
//return SelectData(sp);
return(SelectData(dic, sp));
}
/// <summary>
/// 店舗マスタ取得処理
/// MasterTouroku_Tempoよりデータ抽出時に使用
/// </summary>
public DataTable Store_SelectData(M_Store_Entity mse)
{
return(storedl.M_Store_SelectData(mse));
}
public DataTable BindStore(M_Store_Entity storedata)
{
return(SimpleSelect1("25", storedata.ChangeDate));
}
/// <summary>
/// 画面クリア(0:全項目、1:KEY部以外)
/// </summary>
/// <param name="Kbn"></param>
private void Scr_Clr(short Kbn)
{
foreach (Control ctl in detailControls)
{
if (ctl.GetType().Equals(typeof(CKM_Controls.CKM_RadioButton)))
{
((RadioButton)ctl).Checked = false;
}
else if (ctl.GetType().Equals(typeof(Panel)))
{
}
else if (ctl.GetType().Equals(typeof(CKM_Controls.CKM_ComboBox)))
{
((CKM_Controls.CKM_ComboBox)ctl).SelectedIndex = -1;
}
else
{
ctl.Text = "";
}
}
//初期値セット
string ymd = nnbl.GetDate();
//スタッフマスター(M_Staff)に存在すること
//[M_Staff]
M_Staff_Entity mse = new M_Staff_Entity
{
StaffCD = InOperatorCD,
ChangeDate = ymd
};
Staff_BL bl = new Staff_BL();
bool ret = bl.M_Staff_Select(mse);
if (ret)
{
CboStoreCD.SelectedValue = mse.StoreCD;
//パラメータ 基準日：Form.日付,店舗：Form.店舗 ,得意先区分：3
ScCustomer.Value2 = mse.StoreCD;
}
//[M_Store]
M_Store_Entity mse2 = new M_Store_Entity
{
StoreCD = mse.StoreCD,
ChangeDate = ymd
};
Store_BL sbl = new Store_BL();
DataTable dt = sbl.M_Store_Select(mse2);
if (dt.Rows.Count > 0)
{
}
else
{
bbl.ShowMessage("E133");
EndSec();
}
((RadioButton)detailControls[(int)EIndex.RdoZan]).Checked = true;
GvDetail.DataSource = null;
GvDetail.Enabled = false;
}
/// <summary>
/// 起動時共通処理
///
/// check Authorization
/// insert to log(form open)
/// </summary>
/// <remarks>プログラム起動時に呼び出してください</remarks>
protected void StartProgram()
{
//共通処理 受取パラメータ、接続情報
//コマンドライン引数より情報取得
//Iniファイルより情報取得
//this.GetCmdLine() == false ||
if (this.GetCmdLine() == false || loginbl.ReadConfig() == false)
{
//起動時エラー DB接続不可能
this.Close();
System.Environment.Exit(0);
}
//共通処理 Operator 確認
//[M_Staff]
M_Staff_Entity mse = new M_Staff_Entity
{
StaffCD = InOperatorCD
};
mse = loginbl.M_Staff_InitSelect(mse);
// MessageBox.Show(bbl.GetConnectionString());
this.lblOperatorName.Text = mse.StaffName;
//this.lblLoginDate.Text = mse.SysDate;
DataTable dtShopName = bbl.SimpleSelect1("42", null, "222", "1");
this.lblShopName.Text = dtShopName.Rows[0]["Char1"].ToString();
M_Store_Entity mste = new M_Store_Entity
{
SysDate = mse.SysDate
};
mste = loginbl.M_Store_InitSelect(mse, mste);
this.lblStoreName.Text = mste.StoreName;
StoreCD = mste.StoreCD;
ChangeDate = mste.SysDate;
//共通処理 プログラム
//KTP - 2019-05-29 ProgramのチェックはM_Authorizations_AccessCheck にやっています。
//[M_Program]
//mpe = new M_Program_Entity
//{
// ProgramID = InProgramID,
// Type = "1" //仮
//};
//bool ret = loginbl.M_Program_InitSelect(mpe);
//if (ret == false)
//{
// //Ｓ０１２
// bbl.ShowMessage("S012");
// //起動時エラー
// this.Close();
// System.Environment.Exit(0);
//}
//Authorizations判断
M_Authorizations_Entity mae;
mae = new M_Authorizations_Entity
{
ProgramID = this.InProgramID,
StaffCD = InOperatorCD,
PC = InPcID
};
made = bbl.M_Authorizations_AccessCheck(mae);
if (made == null)
{
bbl.ShowMessage(mae.MessageID);
//起動時エラー
this.Close();
System.Environment.Exit(0);
}
//KTP 2019-05-29 Set ProgrameName, ProgramID
this.Text = made.ProgramID;
//lblHeaderTitle.Text = made.ProgramName;
//KTP 2019-05-29 M_Authorizations_AccessCheckにやっています。 line no 513 to 521
//Program type判断
//switch (mpe.Type)
//{
// case "1":
// if (made.Insertable == "0" && made.Updatable == "0" && made.Deletable == "0" && made.Inquirable == "0")
// {
// //Ｓ００３
// bbl.ShowMessage("S003");
// //起動時エラー
// this.Close();
// System.Environment.Exit(0);
// }
// break;
// case "2":
// if (made.Printable == "0")
// {
// //Ｓ００３
// bbl.ShowMessage("S003");
// //起動時エラー
// this.Close();
// System.Environment.Exit(0);
// }
// break;
// case "3":
// if (made.Printable == "0" && made.Outputable == "0")
// {
// //Ｓ００３
// bbl.ShowMessage("S003");
// //起動時エラー
// this.Close();
// System.Environment.Exit(0);
// }
// break;
// case "4":
// if (made.Outputable == "0")
// {
// //Ｓ００３
// bbl.ShowMessage("S003");
// //起動時エラー
// this.Close();
// System.Environment.Exit(0);
// }
// break;
// case "5":
// if (made.Inquirable == "0")
// {
// //Ｓ００３
// bbl.ShowMessage("S003");
// //起動時エラー
// this.Close();
// System.Environment.Exit(0);
// }
// break;
// case "6":
// if (made.Runable == "0")
// {
// //Ｓ００３
// bbl.ShowMessage("S003");
// //起動時エラー
// this.Close();
// System.Environment.Exit(0);
// }
// break;
//}
//処理可能店舗
//[M_StoreAuthorizations]
M_StoreAuthorizations_Entity msa = new M_StoreAuthorizations_Entity();
msa.StoreAuthorizationsCD = made.StoreAuthorizationsCD;
DataTable dt = bbl.M_StoreAuthorizations_Select(msa);
if (dt.Rows.Count > 0)
{
availableStores = new string[dt.Rows.Count];
int i = 0;
foreach (DataRow row in dt.Rows)
{
availableStores[i] = row["StoreCD"].ToString();
i++;
}
}
///Added by ETZ ,To close when StoreAuthorization isn't accessed
else
{
bbl.ShowMessage(mae.MessageID);
//起動時エラー
this.Close();
System.Environment.Exit(0);
}
//プログラム起動履歴
//InsertLog(Get_L_Log_Entity(true));
//KTP 2019-05-29 Program Type Select from M_Authorizations_AccessCheck function
//Todo:入力プログラム以外を考慮
//switch (mpe.Type)
//switch (made.ProgramType)
//{
// case "1":
// if (made.Insertable == "1")
// {
// // 新規ボタン押下処理
// FunctionProcess((int)EOperationMode.INSERT);
// }
// else if (made.Updatable == "1")
// {
// // 修正ボタン押下処理
// FunctionProcess((int)EOperationMode.UPDATE);
// }
// else if (made.Deletable == "1")
// {
// // 削除ボタン押下処理
// FunctionProcess((int)EOperationMode.DELETE);
// }
// else
// {
// // 照会ボタン押下処理
// FunctionProcess((int)EOperationMode.SHOW);
// }
// break;
//}
}
public DataTable M_Store_Bind(M_Store_Entity mse)
{
return(msdl.M_Store_Bind(mse));
}
/// <summary>
/// StoreKBN IN 1のStore情報をBind
/// </summary>
/// <param name="mse"></param>
/// <returns></returns>
public DataTable M_Store_Bind_Juchu(M_Store_Entity mse)
{
return(storedl.M_Store_Bind_Juchu(mse));
}
/// <summary>
/// 画面クリア(0:全項目、1:KEY部以外)
/// </summary>
/// <param name="Kbn"></param>
private void Scr_Clr(short Kbn)
{
foreach (Control ctl in detailControls)
{
if (ctl.GetType().Equals(typeof(CKM_Controls.CKM_CheckBox)))
{
((CheckBox)ctl).Checked = false;
}
else if (ctl.GetType().Equals(typeof(Panel)))
{
}
else if (ctl.GetType().Equals(typeof(CKM_Controls.CKM_ComboBox)))
{
((CKM_Controls.CKM_ComboBox)ctl).SelectedIndex = -1;
}
else
{
ctl.Text = "";
}
}
ScVendor.LabelText = "";
//foreach (Control ctl in detailLabels)
//{
// ((CKM_SearchControl)ctl).LabelText = "";
//}
//初期値セット
string ymd = ssbl.GetDate();
//スタッフマスター(M_Staff)に存在すること
//[M_Staff]
M_Staff_Entity mse = new M_Staff_Entity
{
StaffCD = InOperatorCD,
ChangeDate = ymd
};
Staff_BL bl = new Staff_BL();
bool ret = bl.M_Staff_Select(mse);
if (ret)
{
CboStoreCD.SelectedValue = mse.StoreCD;
}
//[M_Store]
M_Store_Entity mse2 = new M_Store_Entity
{
StoreCD = mse.StoreCD,
ChangeDate = ymd
};
Store_BL sbl = new Store_BL();
DataTable dt = sbl.M_Store_Select(mse2);
if (dt.Rows.Count > 0)
{
}
else
{
bbl.ShowMessage("E133");
EndSec();
}
((CheckBox)detailControls[(int)EIndex.ChkMiNyuka]).Checked = true;
((CheckBox)detailControls[(int)EIndex.ChkNyukaZumi]).Checked = true;
for (int i = (int)EIndex.ChkJuchuAri; i <= (int)EIndex.ChkEdi; i++)
{
if (detailControls[i].GetType().Equals(typeof(CKM_Controls.CKM_CheckBox)))
{
((CheckBox)detailControls[i]).Checked = true;
}
}
GvDetail.DataSource = null;
GvDetail.Enabled = false;
Btn_F10.Enabled = false;
detailControls[0].Focus();
}
/// <summary>
/// 店舗マスタ更新処理
/// MasterTouroku_Tempoより更新時に使用
/// </summary>
public bool Store_Exec(M_Store_Entity mse, short operationMode, string operatorNm, string pc)
{
return(storedl.M_Store_Exec(mse, operationMode, operatorNm, pc));
}
public DataTable M_Store_SelectAll(M_Store_Entity mse)
{
return(storedl.M_Store_SelectAll(mse));
}
/// <summary>
/// StoreKBN NOT IN 2のStore情報をBind（権限のある店舗のみ）
/// </summary>
/// <param name="mse"></param>
/// <returns></returns>
public DataTable M_Store_Bind_Getsuji(M_Store_Entity mse)
{
return(storedl.M_Store_Bind_Getsuji(mse));
}
/// <summary>
/// 画面クリア(0:全項目、1:KEY部以外)
/// </summary>
/// <param name="Kbn"></param>
private void Scr_Clr(short Kbn)
{
foreach (Control ctl in detailControls)
{
if (ctl.GetType().Equals(typeof(CKM_Controls.CKM_CheckBox)))
{
((CheckBox)ctl).Checked = false;
}
else if (ctl.GetType().Equals(typeof(Panel)))
{
}
else if (ctl.GetType().Equals(typeof(CKM_Controls.CKM_ComboBox)))
{
((CKM_Controls.CKM_ComboBox)ctl).SelectedIndex = -1;
}
else
{
ctl.Text = "";
}
}
foreach (Control ctl in detailLabels)
{
((CKM_SearchControl)ctl).LabelText = "";
}
//初期値セット
string ymd = mibl.GetDate();
//スタッフマスター(M_Staff)に存在すること
//[M_Staff]
M_Staff_Entity mse = new M_Staff_Entity
{
StaffCD = InOperatorCD,
ChangeDate = mibl.GetDate()
};
Staff_BL bl = new Staff_BL();
bool ret = bl.M_Staff_Select(mse);
if (ret)
{
CboStoreCD.SelectedValue = mse.StoreCD;
}
//[M_Store]
M_Store_Entity mse2 = new M_Store_Entity
{
StoreCD = mse.StoreCD,
ChangeDate = ymd
};
Store_BL sbl = new Store_BL();
DataTable dt = sbl.M_Store_Select(mse2);
if (dt.Rows.Count > 0)
{
}
else
{
bbl.ShowMessage("E133");
EndSec();
}
CboSoukoName.Enabled = false;
detailControls[1].Focus();
}
public DataTable BindStore(M_Store_Entity mse)// Bind datat to comboBox
{
return(storedl.M_Store_Bind(mse));
//return storedl.SimpleSelect("StoreName,StoreCD", "F_Store ('" + changedate + "')","DeleteFlg = 0 And (StoreKBN = 2 OR StoreKBN = 3) Order By StoreCD");
}
public DataTable StoreCheck(M_Store_Entity storedata)
{
return(SimpleSelect1("17", storedata.ChangeDate, storedata.StoreCD));
}
public DataTable BindData(M_Store_Entity mse)
{
return(storedl.M_Store_BindData(mse));
}