public DataTable M_Denomination_cboSelect(M_DenominationKBN_Entity me)
{
string sp = "M_Denomination_cboSelect";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@SystemKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = me.SystemKBN
} }
};
return(SelectData(dic, sp));
}
public DataTable M_DenominationKBN_Select(M_DenominationKBN_Entity me)
{
string sp = "M_DenominationKBN_Select";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@DenominationCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = me.DenominationCD
} }
};
return(SelectData(dic, sp));
}
private void Bind(CKM_Controls.CKMShop_ComboBox combo, int kbn = 0)
{
DenominationKBN_BL dbl = new DenominationKBN_BL();
M_DenominationKBN_Entity me = new M_DenominationKBN_Entity();
if (kbn.Equals(0))
{
me.SystemKBN = "2";
}
DataTable dtNyukinhouhou = dbl.BindKbn(me, kbn);
BindCombo(combo, "DenominationCD", "DenominationName", dtNyukinhouhou);
;
}
public bool M_DenominationKBN_Select(M_DenominationKBN_Entity mde)
{
DataTable dt = mdl.M_DenominationKBN_Select(mde);
if (dt.Rows.Count > 0)
{
//mde.ChangeDate = dt.Rows[0]["ChangeDate"].ToString();
mde.DenominationName = dt.Rows[0]["DenominationName"].ToString();
mde.SystemKBN = dt.Rows[0]["SystemKBN"].ToString();
mde.CardCompany = dt.Rows[0]["CardCompany"].ToString();
mde.CalculationKBN = dt.Rows[0]["CalculationKBN"].ToString();
mde.MainFLG = dt.Rows[0]["MainFLG"].ToString();
return(true);
}
else
{
return(false);
}
}
public DataTable M_Denomination_cboSelect(M_DenominationKBN_Entity me, int kbn)
{
DataTable dt = mdl.M_DenominationKBN_SelectAll(me);
int count = dt.Columns.Count;
if (kbn == 1)
{
//DataRow[] rows = dt.Select("SystemKBN NOT IN (1,2,3,5,8,9)"); 2019/12/20 "1:現金,2:カード,3:ポイント,4:商品券,5:振込,6:小切手,7:相殺,8:値引,9:掛,10:Paypay
DataRow[] rows = dt.Select("SystemKBN IN (1,2,3,8,9)");
for (int i = 0; i < rows.Length; i++)
{
if (rows[i].RowState != DataRowState.Deleted)
{
rows[i].Delete();
}
}
}
ArrayList arrlst = new ArrayList();
arrlst.Add("DenominationCD");
arrlst.Add("DenominationName");
//arrlst.Add("Char1");
for (int i = 0; i < count; i++)
{
if (!arrlst.Contains(dt.Columns[i].ColumnName))
{
dt.Columns.RemoveAt(i);
i--;
count--;
dt.AcceptChanges();
}
}
return(dt);
}
