public DataTable getPrintData(D_Cost_Entity dce)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@RecordDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dce.RecordedDateFrom
} },
{ "@RecordDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dce.RecordedDateTo
} },
{ "@ExpanseEntryDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dce.ExpanseEntryDateFrom
} },
{ "@ExpanseEntryDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dce.ExpanseEntryDateTo
} },
{ "@InsertDateTimeFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dce.Expense_TimeFrom
} },
{ "@InsertDateTimeTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dce.ExPense_TimeTo
} },
{ "@printTarget", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dce.PrintTarget
} },
{ "@StoreName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dce.Store
} },
};
return(SelectData(dic, "D_KeihiPrint"));
}
public keihiPrint(D_Cost_Entity dc, params string[] login)
{
InitializeComponent();
lst = login;
dce = new D_Cost_Entity();
dce2 = new D_Cost_Entity();
dce = dc;
kbl = new KeihiltiranHyou_BL();
AllEvent_PrintLog();
}
public DataTable D_Cost_Display(D_Cost_Entity cost)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@CostNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cost.CostNO
} }
};
return(SelectData(dic, "D_Cost_Display"));
}
public bool KehiNyuuryoku_Insert_Update(D_Cost_Entity cost, int mode)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@mode", new ValuePair {
value1 = SqlDbType.Int, value2 = mode.ToString()
} },
{ "@CostNOUpdate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cost.CostNO
} },
{ "@PayeeCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cost.PayeeCD
} },
{ "@RecordDate", new ValuePair {
value1 = SqlDbType.Date, value2 = cost.RecordedDate
} },
{ "@PayPlanDate", new ValuePair {
value1 = SqlDbType.Date, value2 = cost.PayPlanDate
} },
{ "@StaffCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cost.StaffCD
} },
{ "@RegularFLG", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = cost.RegularlyFLG
} },
{ "@TotalGaku", new ValuePair {
value1 = SqlDbType.Money, value2 = cost.TotalGaku
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cost.Operator
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cost.Store
} },
{ "@xml", new ValuePair {
value1 = SqlDbType.Xml, value2 = cost.xml1
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cost.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cost.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cost.ProcessMode
} }
//{ "@KeyItem", new ValuePair { value1 = SqlDbType.VarChar, value2 = cost.Key} }
};
UseTransaction = true;
return(InsertUpdateDeleteData(dic, "KehiNyuuryoku_Insert_Update"));
}
protected D_Cost_Entity GetCostData()
{
D_Cost_Entity de = new D_Cost_Entity();
de.RecordedDateFrom = txtRecordFrom.Text;
de.RecordedDateTo = txtRecordTo.Text;
de.PaymentDateFrom = txtPaymentFrom.Text;
de.PaymentDateTo = txtPaymentTo.Text;
de.ExpanseEntryDateFrom = txtExpenseFrom.Text;
de.ExpanseEntryDateTo = txtExpenseTo.Text;
de.Expense_TimeFrom = expense_timefrom.Text;
de.ExPense_TimeTo = expense_timeto.Text;
de.PrintTarget = rdb_unpaid.Checked ? "0" : rdb_paid.Checked ? "1" : "";
de.Store = cboStoreName.Text;
return(de);
}
public DataTable D_Cost_Search(D_Cost_Entity dcoste)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@RecordDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dcoste.RecordedDateFrom
} },
{ "@RecordDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dcoste.RecordedDateTo
} },
{ "@ExpanseEntryDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dcoste.ExpanseEntryDateFrom
} },
{ "@ExpanseEntryDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dcoste.ExpanseEntryDateTo
} },
{ "@PaymentDueDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dcoste.PaymentDueDateFrom
} },
{ "@PaymentDueDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dcoste.PaymentDueDateTo
} },
{ "@StaffCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dcoste.StaffCD
} },
{ "@PaymentDestinationCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dcoste.PayeeCD
} },
{ "@Paid", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = dcoste.Paid
} },
{ "@Unpaid", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = dcoste.Unpaid
} },
{ "@RegFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = dcoste.RegularlyFLG
} },
{ "@PaymentDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dcoste.PaymentDateFrom
} },
{ "@PaymentDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dcoste.PaymentDateTo
} },
};
return(SelectData(dic, "D_Cost_Search"));
}
public DataTable D_Cost_Copy_Display(D_Cost_Entity cost)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@CostNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cost.CostNO
} },
{ "@VendorCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = cost.VendorCD
} },
{ "@RecordDate", new ValuePair {
value1 = SqlDbType.Date, value2 = cost.RecordedDate
} }
};
return(SelectData(dic, "D_Cost_Copy_Display"));
}
// D_Cost_Entity dce;
public FrmKeihiltiranHyou()
{
InitializeComponent();
try
{
lst = new string[] { };
previewForm = new Viewer();
dce = new D_Cost_Entity();
this.KeyUp += FrmKeihiltiranHyou_KeyUp;
kbl = new KeihiltiranHyou_BL();
dce2 = new D_Cost_Entity();
vr = new CrystalDecisions.Windows.Forms.CrystalReportViewer();
dtlog = new DataTable();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//ZCO
//private void InitialControlArray()
//{
// detailControls = new Control[] { txtRecordDateFrom, txtRecordDateTo,SearchStaff.TxtCode, txtEntryDateFrom, txtEntryDateTo,chkTeiki,
// txtPaymentDueDateFrom,txtPaymentDueDateTo,searchPaymentDes.TxtCode,chkPaid,chkUnpaid,txtPaymentDateFrom,txtPaymentDateTo};
// foreach (Control ctl in detailControls)
// {
// ctl.KeyDown += new System.Windows.Forms.KeyEventHandler(DetailControl_KeyDown);
// //ctl.Enter += new System.EventHandler(DetailControl_Enter);
// }
//}
//private void DetailControl_KeyDown(object sender, KeyEventArgs e)
//{
// try
// {
// //Enterキー押下時処理
// //Returnキーが押されているか調べる
// //AltかCtrlキーが押されている時は、本来の動作をさせる
// if ((e.KeyCode == Keys.Return) &&
// ((e.KeyCode & (Keys.Alt | Keys.Control)) == Keys.None))
// {
// //bool ret = CheckDetail(Array.IndexOf(detailControls, sender));
// // if (ret)
// //{
// if (detailControls.Length - 1 > Array.IndexOf(detailControls, sender))
// detailControls[Array.IndexOf(detailControls, sender) + 1].Focus();
// else
// //あたかもTabキーが押されたかのようにする
// //Shiftが押されている時は前のコントロールのフォーカスを移動
// this.ProcessTabKey(!e.Shift);
// //}
// //else
// //{
// // ((Control)sender).Focus();
// //}
// }
// else
// {
// ((Control)sender).Focus();
// }
// }
// catch (Exception ex)
// {
// //エラー時共通処理
// MessageBox.Show(ex.Message);
// //EndSec();
// }
//}
private D_Cost_Entity GetSearchInfo()
{
dcoste = new D_Cost_Entity
{
RecordedDateFrom = txtRecordDateFrom.Text,
RecordedDateTo = txtRecordDateTo.Text,
ExpanseEntryDateFrom = txtEntryDateFrom.Text,
ExpanseEntryDateTo = txtEntryDateTo.Text,
PaymentDueDateFrom = txtPaymentDueDateFrom.Text,
PaymentDueDateTo = txtPaymentDueDateTo.Text,
StaffCD = scStaffCD.TxtCode.Text,
PayeeCD = PaymentCD.TxtCode.Text,
Paid = chkPaid.Checked ? "1" : "0", //更新 ssa
Unpaid = chkUnpaid.Checked ? "0" : "1", //更新 ssa
RegularlyFLG = chkTeiki.Checked ? "1" : "0",
PaymentDateFrom = txtPaymentDateFrom.Text,
PaymentDateTo = txtPaymentDateTo.Text
};
return(dcoste);
}
private void F11()
{
//更新 ssa
dgvCostSearch.ClearSelection();
if (ErrorCheck())//エラーチェック事
{
//<Remark>フォームデータを取る事</Remark>
dcoste = GetSearchInfo();
//<Remark>データベースに登録したデータを取る事</Remark>
DataTable dtCost = skhnobl.D_Cost_Search(dcoste);
for (int i = 0; i < dtCost.Rows.Count; i++)
{
string R_Flag = dtCost.Rows[i]["RegularlyFLG"].ToString();
if (R_Flag.Equals("1"))
//if (dtCost.Rows[i]["RegularlyFLG"].ToString() == "1")//zco
{
dtCost.Rows[i]["RegularlyFLG"] = "〇";
}
else
{
dtCost.Rows[i]["RegularlyFLG"] = "";
}
}
if (dtCost.Rows.Count > 0)
{
dgvCostSearch.Refresh();
dgvCostSearch.DataSource = dtCost;
dgvCostSearch.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
dgvCostSearch.CurrentRow.Selected = true;
dgvCostSearch.Enabled = true;
dgvCostSearch.Focus();
}
else
{
skhnobl.ShowMessage("E128"); //更新 ssa
dgvCostSearch.DataSource = null;
}
}
}
public DataTable D_Cost_Search(D_Cost_Entity dcoste)
{
return(dcostdl.D_Cost_Search(dcoste));
}
public DataTable getPrintData(D_Cost_Entity dce)
{
return(dcdl.getPrintData(dce));
}
public bool KehiNyuuryoku_Delete(D_Cost_Entity cost)
{
return(costDL.KehiNyuuryoku_Delete(cost));
}
public bool KehiNyuuryoku_Insert_Update(D_Cost_Entity cost, int mode)
{
return(costDL.KehiNyuuryoku_Insert_Update(cost, mode));
}
public DataTable D_Cost_Copy_Display(D_Cost_Entity cost)
{
return(costDL.D_Cost_Copy_Display(cost));
}
