private void F12()
{
if (ErrorCheck(12))
{
dpe = GetPayData();
if (bbl.ShowMessage(OperationMode == EOperationMode.DELETE ? "Q102" : "Q101") == DialogResult.Yes)
{
switch (OperationMode)
{
case EOperationMode.INSERT:
Insert();
break;
case EOperationMode.UPDATE:
Update();
break;
case EOperationMode.DELETE:
Delete();
break;
}
}
else
{
PreviousCtrl.Focus();
}
}
}
public bool D_Pay_Insert(D_Pay_Entity dpe)
{
dpe.xml1 = DataTableToXml(dpe.dtTemp1);
dpe.xml2 = DataTableToXml(dpe.dtTemp2);
dpe.xml3 = DataTableToXml(dpe.dtTemp3);
return(dpdl.D_Pay_Insert(dpe));
}
public bool D_Pay_Update(D_Pay_Entity dpe)
{
dpe.xml4 = DataTableToXml(dpe.dtTemp4);
dpe.xml5 = DataTableToXml(dpe.dtTemp5);
dpe.xml6 = DataTableToXml(dpe.dtTemp6);
return(dpdl.D_Pay_Update(dpe));
}
public bool D_Pay_Delete(D_Pay_Entity dpe)
{
//dpe.xml1 = DataTableToXml(dpe.dtTemp4);
//dpe.xml2 = DataTableToXml(dpe.dtTemp5);
//dpe.xml3 = DataTableToXml(dpe.dtTemp6);
return(dpdl.D_Pay_Delete(dpe));
}
public bool D_Pay_Delete(D_Pay_Entity dpe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@PayNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.PayNo
} },
{ "@LargePayNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.LargePayNO
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.Operator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.ProcessMode
} }
//{ "@KeyItem", new ValuePair { value1 = SqlDbType.VarChar, value2 = dpe.StoreCD +" "+ dpe.Key } }
};
return(InsertUpdateDeleteData(dic, "D_Pay_Delete"));
}
public SiharaiItiranHyou()
{
InitializeComponent();
bbl = new Base_BL();
Ichiran_BL = new Shiharai_ItiranHyou_BL();
dpe = new D_Pay_Entity();
dt = new DataTable();
dtResult = new DataTable();
previewForm = new Viewer();
}
private D_Pay_Entity GetDataInfo()
{
dpe = new D_Pay_Entity()
{
PurchaseDateFrom = txtPurchaseDateFrom.Text,
PurchaseDateTo = txtPurChaseDateTo.Text,
PayeeCD = SC_Payment.TxtCode.Text,
StaffCD = SC_Staff.TxtCode.Text
};
return(dpe);
}
public D_Pay_Entity GetData()
{
dpe = new D_Pay_Entity()
{
PayDateFrom = txtPaymentDateFrom.Text,
PayDateTo = txtPaymentDateTo.Text,
InputDateTimeFrom = txtPaymentInputDateFrom.Text,
InputDateTimeTo = txtPaymentInputDateTo.Text
};
return(dpe);
}
public DataTable D_Pay_LargePayNoSelect(D_Pay_Entity dpe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@LargePayNo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.LargePayNO
} }
};
return(SelectData(dic, "D_Pay_LargePayNoSelect"));
}
public DataTable D_Payee_PayeeNameSelect(D_Pay_Entity dpe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@PayeeCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.PayeeCD
} },
{ "@PayDate", new ValuePair {
value1 = SqlDbType.Date, value2 = dpe.PayDate
} }
};
return(SelectData(dic, "D_Payee_PayeeNameSelect"));
}
public DataTable D_PayDetail_Select(D_Pay_Entity dpe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>()
{
{ "@LargePayNo", new ValuePair {
value1 = SqlDbType.Int, value2 = dpe.LargePayNO
} },
{ "@PayNo", new ValuePair {
value1 = SqlDbType.Int, value2 = dpe.PayNo
} }
};
return(SelectData(dic, "D_PayDetail_Select"));
}
public DataTable D_Pay_Select02(D_Pay_Entity dpe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>()
{
{ "@LargePayNo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.LargePayNO
} },
{ "@PayNo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.PayNo
} },
//{"@VendorCD", new ValuePair {value1 = SqlDbType.VarChar, value2= dpe.PayeeCD } },
//{"@PayeeDate", new ValuePair {value1 = SqlDbType.Date, value2= dpe.PayPlanDate} }
};
return(SelectData(dic, "D_Pay_Select02"));
}
public bool D_Pay_Update(D_Pay_Entity dpe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StaffCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.StaffCD
} },
{ "@PayDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.PayDate
} },
{ "@Xml1", new ValuePair {
value1 = SqlDbType.Xml, value2 = dpe.xml4
} },
{ "@Xml2", new ValuePair {
value1 = SqlDbType.Xml, value2 = dpe.xml5
} },
{ "@Xml3", new ValuePair {
value1 = SqlDbType.Xml, value2 = dpe.xml6
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.PC
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.Operator
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.StoreCD
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.ProcessMode
} },
{ "@TotalPayGaku", new ValuePair {
value1 = SqlDbType.Money, value2 = dpe.PayGakuTotol
} },
{ "@PayNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.PayNo
} },
{ "@LargePayNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.LargePayNO
} }
};
return(InsertUpdateDeleteData(dic, "D_Pay_Update"));
}
public SiharaiTouroku_2(D_Pay_Entity dpe1, DataTable dt, DataTable dtDetail)
{
InitializeComponent();
dpe = dpe1;
kouzaCD = dpe.MotoKouzaCD;
payeeCD = dpe.PayeeCD;
payPlanDate = dpe.PayPlanDate;
dtGdv = dt;
dtDetails = dtDetail;
DataRow[] tblROWS1 = dtDetail.Select("PayeeCD = '" + payeeCD + "'" + "and PayPlanDate = '" + payPlanDate + "'");
if (tblROWS1.Length > 0)
{
dtSiharai2 = tblROWS1.CopyToDataTable();
}
}
private DataTable CheckData()
{
DataTable dt = null;
if (ErrorCheck())
{
dpe = GetDataInfo();
dt = Ichiran_BL.ItiranHyou_SelectForPrint(dpe);
//以下の条件でデータが存在しなければエラー (Error if record does not exist)Ｅ１３３
if (dt.Rows.Count == 0)
{
bbl.ShowMessage("E128");
return(null);
}
}
return(dt);
}
public void F11()
{
if (ErrorCheck())
{
dpe = GetData();
DataTable dt = new DataTable();
dt = sssbl.D_Pay_Search(dpe);
if (dt.Rows.Count > 0)
{
dgvSiharaiShoriNO.DataSource = dt;
}
else
{
sssbl.ShowMessage("E128");
txtPaymentDateFrom.Focus();
}
}
}
public DataTable D_Pay_Search(D_Pay_Entity dpe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>()
{
{ "@PayDateFrom", new ValuePair {
value1 = SqlDbType.Date, value2 = dpe.PayDateFrom
} },
{ "@PayDateTo", new ValuePair {
value1 = SqlDbType.Date, value2 = dpe.PayDateTo
} },
{ "@InputDateTimeFrom", new ValuePair {
value1 = SqlDbType.Date, value2 = dpe.InputDateTimeFrom
} },
{ "@InputDateTimeTo", new ValuePair {
value1 = SqlDbType.Date, value2 = dpe.InputDateTimeTo
} }
};
return(SelectData(dic, "D_Pay_Search"));
}
public DataTable D_Pay_SelectForPrint(D_Pay_Entity dpe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>()
{
{ "@PurchaseDateFrom", new ValuePair {
value1 = SqlDbType.Date, value2 = dpe.PurchaseDateFrom
} },
{ "@PurchaseDateTo", new ValuePair {
value1 = SqlDbType.Date, value2 = dpe.PurchaseDateTo
} },
{ "@VendorCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.PayeeCD
} },
{ "@StaffCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpe.StaffCD
} }
};
return(SelectData(dic, "D_Pay_ShiharaiItianHyou"));
}
/// <summary>
/// Get D_Pay_Entity
/// </summary>
/// <returns></returns>
private D_Pay_Entity GetPayData()
{
dpe = new D_Pay_Entity()
{
StaffCD = ScStaff.TxtCode.Text,
StoreCD = InOperatorCD,
PayDate = txtPaymentDate.Text,
Operator = InOperatorCD,
ProgramID = InProgramID,
PayGakuTotol = lblPayGaku.Text.Replace(",", ""),
PC = InPcID,
PayNo = ScPaymentNum.TxtCode.Text,
LargePayNO = ScPaymentProcessNum.TxtCode.Text,
dtTemp1 = dtpayplan,
dtTemp2 = dt4Detail,
dtTemp3 = dt4,
dtTemp4 = dtPay1,
dtTemp5 = dt2,
dtTemp6 = dt3
};
return(dpe);
}
public bool D_Siharai_Exec(D_Pay_Entity dpe, DataTable dt, DataTable dtD, short operationMode)
{
string sp = "PRC_SiharaiToroku";
command = new SqlCommand(sp, GetConnection());
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 0;
AddParam(command, "@OperateMode", SqlDbType.Int, operationMode.ToString());
AddParam(command, "@PayNo", SqlDbType.VarChar, dpe.PayNo);
AddParam(command, "@LargePayNO", SqlDbType.VarChar, dpe.LargePayNO);
//AddParam(command, "@StoreCD", SqlDbType.VarChar, dpe.StoreCD);
AddParam(command, "@PayDate", SqlDbType.VarChar, dpe.PayDate);
AddParam(command, "@StaffCD", SqlDbType.VarChar, dpe.StaffCD);
AddParamForDataTable(command, "@Table", SqlDbType.Structured, dt);
AddParamForDataTable(command, "@TableD", SqlDbType.Structured, dtD);
AddParam(command, "@Operator", SqlDbType.VarChar, dpe.Operator);
AddParam(command, "@PC", SqlDbType.VarChar, dpe.PC);
//OUTパラメータの追加
string outPutParam = "@OutPayNo";
command.Parameters.Add(outPutParam, SqlDbType.VarChar, 11);
command.Parameters[outPutParam].Direction = ParameterDirection.Output;
UseTransaction = true;
bool ret = InsertUpdateDeleteData(sp, ref outPutParam);
if (ret)
{
dpe.PayNo = outPutParam;
}
return(ret);
}
public DataTable D_Pay_PayNoSelect(D_Pay_Entity dpe)
{
return(dpdl.D_Pay_PayNoSelect(dpe));
}
public DataTable ItiranHyou_SelectForPrint(D_Pay_Entity dpe)
{
return(dpdl.D_Pay_SelectForPrint(dpe));
}
public DataTable D_Pay_SelectForSiharaiNo(D_Pay_Entity dpe)
{
return(dpdl.D_Pay_SelectForSiharaiNo(dpe));
}
public DataTable D_Pay_Search(D_Pay_Entity dpe)
{
return(dpdl.D_Pay_Search(dpe));
}
public DataTable D_PayDetail_Select(D_Pay_Entity dpe)
{
return(dpddl.D_PayDetail_Select(dpe));
}
public DataTable M_Payee_Select(D_Pay_Entity dpe)
{
return(mpdl.D_Payee_PayeeNameSelect(dpe));
}
public DataTable D_Pay_Select3(D_Pay_Entity dpe)
{
return(dpdl.D_Pay_Select3(dpe));
}
public bool D_Siharai_Exec(D_Pay_Entity dpe, DataTable dt, DataTable dtD, short operationMode)
{
return(dpdl.D_Siharai_Exec(dpe, dt, dtD, operationMode));
}
