//public DataTable Return_Value(D_APIControl_Entity dpch_entity,int Type)
//{
// Dictionary<string, ValuePair> dic = new Dictionary<string, ValuePair>
// {
// {"@ReferenceDate",new ValuePair{value1=SqlDbType.Date,value2=dpch_entity.pay} }
// {"@SlipType",new ValuePair{value1=SqlDbType.Int,value2=dpch_entity.SlipType } },
// { "@Type",new ValuePair {value1=SqlDbType.Int,value2=Type.ToString()} }
// };
//}
public bool Insert_ShiHaRaiShime_PaymentClose(D_PayCloseHistory_Entity dpch_entity, int InsertType)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@PaymentCloseCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpch_entity.PaymentCD
} },
{ "@PaymentCloseDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpch_entity.PaymentDate
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpch_entity.InsertOperator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpch_entity.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpch_entity.PC
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpch_entity.StoreCD
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpch_entity.ProcessMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpch_entity.Key
} },
{ "@InsertType", new ValuePair {
value1 = SqlDbType.Int, value2 = InsertType.ToString()
} }
};
return(InsertUpdateDeleteData(dic, "Insert_Update_ShiharaiShori"));
}
public Shiharai_ShimeShori()
{
InitializeComponent();
dtDisplay = new DataTable();
dpch_entity = new D_PayCloseHistory_Entity();
sss_bl = new Shiharai_Shimeshori_BL();
bbl = new Base_BL();
}
public bool Select_PaymentClose(D_PayCloseHistory_Entity dpch_entity, int Type)
{
if (dpch_DL.Select_PaymentClose(dpch_entity, Type).Rows.Count > 0)
{
return(true);
}
return(false);
}
public DataTable D_PayClose_Search(D_PayCloseHistory_Entity dpch_entity)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@PayeeCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpch_entity.PaymentCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = dpch_entity.PaymentDate
} },
};
return(SelectData(dic, "D_PayClose_Search"));
}
public DataTable CheckPayCloseHistory(D_PayCloseHistory_Entity dpe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@PayeeCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.PayeeCD
} },
{ "@PayCloseDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.PayCloseDate
} }
};
return(SelectData(dic, "CheckPayCloseHistory"));
}
/// <summary>
/// 締処理済の場合（以下のSelectができる場合）Error
/// </summary>
/// <param name="dpe"></param>
/// <returns></returns>
public bool CheckPayCloseHistory(D_PayCloseHistory_Entity dpe)
{
D_PayCloseHistory_DL dpd = new D_PayCloseHistory_DL();
DataTable dt = dpd.CheckPayCloseHistory(dpe);
bool ret = false;
if (dt.Rows.Count > 0)
{
dpe.PayCloseNO = dt.Rows[0]["PayCloseNO"].ToString();
ret = true;
}
return(ret);
}
/// <summary>
/// Get Data Value Bind
/// </summary>
/// <returns>Value Return</returns>
private D_PayCloseHistory_Entity GetDataEntity()
{
dpch_entity = new D_PayCloseHistory_Entity()
{
PaymentDate = txtPayCloseDate.Text,
PaymentCD = Shiiresaki.TxtCode.Text,
ProcessMode = ModeText,
InsertOperator = InOperatorCD,
ProgramID = InProgramID,
Key = Shiiresaki.TxtCode.Text + " " + txtPayCloseDate.Text,
PC = InPcID
};
return(dpch_entity);
}
public DataTable Select_PaymentClose(D_PayCloseHistory_Entity dpch_entity, int Type)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@PaymentCloseCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpch_entity.PaymentCD
} },
{ "@PaymentCloseDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpch_entity.PaymentDate
} },
{ "@Type", new ValuePair {
value1 = SqlDbType.Int, value2 = Type.ToString()
} }
};
return(SelectData(dic, "Select_PaymentClose_ValueCheck"));
}
private void F11()
{
dpch_entity = GetDataEntity();
BindGrid();
//string ItemType = cboProcessType.Text;
//switch (ItemType)
//{
// case "支払締":
// if (ErrorCheck(1))
// {
// BindGrid();
// }
// break;
// case "支払締キャンセル":
// if (ErrorCheck(2))
// {
// BindGrid();
// }
// break;
//}
}
private void F12()
{
dpch_entity = GetDataEntity();
string ItemType = cboProcessType.Text;
//if (dgvPaymentClose.DataSource != null)
//{
switch (ItemType)
{
case "支払締":
if (ErrorCheck(1))
{
if (bbl.ShowMessage("Q101") == DialogResult.Yes)
{
if (sss_bl.Insert_ShiHaRaiShime_PaymentClose(dpch_entity, 1))
{
sss_bl.ShowMessage("I101");
ChangeMode(EOperationMode.INSERT);
}
}
}
break;
case "支払締キャンセル":
if (ErrorCheck(2))
{
if (bbl.ShowMessage("Q102") == DialogResult.Yes)
{
if (sss_bl.Insert_ShiHaRaiShime_PaymentClose(dpch_entity, 2))
{
sss_bl.ShowMessage("I101");
ChangeMode(EOperationMode.INSERT);
}
}
}
break;
}
//}
}
public bool Insert_ShiHaRaiShime_PaymentClose(D_PayCloseHistory_Entity dpch_entity, int InUpType)
{
return(dpch_DL.Insert_ShiHaRaiShime_PaymentClose(dpch_entity, InUpType));
}
public DataTable D_PayClose_Search(D_PayCloseHistory_Entity dpdpch_entity)
{
return(dpch_DL.D_PayClose_Search(dpdpch_entity));
}
