public bool M_Kouza_Delete(M_Kouza_Entity mkze)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>()
{
{ "@KouzaCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.KouzaCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mkze.ChangeDate
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.InsertOperator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.ProcessMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Key
} }
};
UseTransaction = true;
return(InsertUpdateDeleteData(dic, "M_Kouza_Delete"));
}
private void F12()
{
if (ErrorCheck(12))
{
if (mtbbl.ShowMessage(OperationMode == EOperationMode.DELETE ? "Q102" : "Q101") == DialogResult.Yes)
{
mkze = GetKouzaEntity();
switch (OperationMode)
{
case EOperationMode.INSERT:
InsertUpdate(1);
break;
case EOperationMode.UPDATE:
InsertUpdate(2);
break;
case EOperationMode.DELETE:
Delete();
break;
}
}
else
{
PreviousCtrl.Focus();
}
}
}
private bool BindGrid()
{
mke = GetEntity();
DataTable dt = mbl.M_Kouza_SelectAll(mke);
if (dt.Rows.Count == 0)
{
return(false);
}
dgvDetail.DataSource = dt;
return(true);
}
public DataTable M_Kouza_SelectByDate(M_Kouza_Entity mke)
{
string sp = "M_Kouza_SelectByDate";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mke.ChangeDate
} }
};
return(SelectData(dic, sp));
}
//public bool M_Kouza_Exec(M_Kouza_Entity mbe, short operationMode, string operatorNm, string pc)
//{
// string sp = "PRC_MasterTouroku_Tempo";
// //Todo:パラメータを型指定に変更
// Dictionary<string, string> dic = new Dictionary<string, string>();
// dic.Add("@OperateMode", operationMode.ToString());
// dic.Add("@KouzaCD", mbe.KouzaCD);
// dic.Add("@ChangeDate", mbe.ChangeDate);
// dic.Add("@KouzaName", mbe.KouzaName);
// dic.Add("@KouzaKBN", mbe.KouzaKBN);
// dic.Add("@KouzaPlaceKBN", mbe.KouzaPlaceKBN);
// dic.Add("@MallCD", mbe.MallCD);
// dic.Add("@ZipCD1", mbe.ZipCD1);
// dic.Add("@ZipCD2", mbe.ZipCD2);
// dic.Add("@Address1", mbe.Address1);
// dic.Add("@Address2", mbe.Address2);
// dic.Add("@TelphoneNO", mbe.TelphoneNO);
// dic.Add("@FaxNO", mbe.FaxNO);
// dic.Add("@MailAddress", mbe.MailAddress);
// dic.Add("@ApprovalStaffCD11", mbe.ApprovalStaffCD11);
// dic.Add("@ApprovalStaffCD12", mbe.ApprovalStaffCD12);
// dic.Add("@ApprovalStaffCD21", mbe.ApprovalStaffCD21);
// dic.Add("@ApprovalStaffCD22", mbe.ApprovalStaffCD22);
// dic.Add("@ApprovalStaffCD31", mbe.ApprovalStaffCD31);
// dic.Add("@ApprovalStaffCD32", mbe.ApprovalStaffCD32);
// dic.Add("@DeliveryDate", mbe.DeliveryDate);
// dic.Add("@PaymentTerms", mbe.PaymentTerms);
// dic.Add("@DeliveryPlace", mbe.DeliveryPlace);
// dic.Add("@ValidityPeriod", mbe.ValidityPeriod);
// dic.Add("@Print1", mbe.Print1);
// dic.Add("@Print2", mbe.Print2);
// dic.Add("@Print3", mbe.Print3);
// dic.Add("@Print4", mbe.Print4);
// dic.Add("@Print5", mbe.Print5);
// dic.Add("@Print6", mbe.Print6);
// dic.Add("@KouzaCD", mbe.KouzaCD);
// dic.Add("@Remarks", mbe.Remarks);
// dic.Add("@DeleteFlg", mbe.DeleteFlg);
// dic.Add("@UsedFlg", mbe.UsedFlg);
// dic.Add("@Operator", operatorNm);
// dic.Add("@PC", pc);
// return InsertUpdateDeleteData(dic, sp);
//}
public DataTable M_Kouza_Bind(M_Kouza_Entity mke)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mke.ChangeDate
} },
{ "@DeleteFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mke.DeleteFlg
} },
};
return(SelectData(dic, "M_Kouza_Bind"));
}
public void Select_KouzaFee()
{
if (!string.IsNullOrWhiteSpace(SC_BankCD.TxtCode.Text) && !string.IsNullOrWhiteSpace(SC_BranchCD.TxtCode.Text) &&
!string.IsNullOrWhiteSpace(txtFeeKBN.Text) && bbl.Z_Set(txtAmount.Text).Equals(0))
{
M_Kouza_Entity mkze = new M_Kouza_Entity
{
KouzaCD = kouzaCD,
BankCD = SC_BankCD.TxtCode.Text,
BranchCD = SC_BranchCD.TxtCode.Text,
Amount = lblPayGaku.Text.Replace(",", ""),
};
DataTable dt = shnbl.M_Kouza_FeeSelect(mkze);
txtAmount.Text = bbl.Z_SetStr(dt.Rows[0]["Fee"]);
}
}
private M_Kouza_Entity GetKouzaEntity()
{
mkze = new M_Kouza_Entity
{
KouzaCD = ScKouzaCD.Code,
ChangeDate = ScKouzaCD.ChangeDate,
KouzaName = txtKouzaName.Text,
BankCD = ScBankCD.Code,
BranchCD = ScBranchCD.Code,
KouzaKBN = txtKouzaKBN.Text,
KouzaNO = txtKouzaNO.Text,
KouzaMeigi = txtKouzaMeigi.Text,
CompanyCD = txtCompanyCD.Text,
CompanyName = txtCompanyName.Text,
Print1 = txtPrint1.Text,
Print2 = txtPrint2.Text,
Print3 = txtPrint3.Text,
Print4 = txtPrint4.Text,
Fee11 = txtFee11.Text,
Tax11 = txtTax11.Text,
Amount1 = txtAmount1.Text,
Fee12 = txtFee12.Text,
Tax12 = txtTax12.Text,
Fee21 = txtFee21.Text,
Tax21 = txtTax21.Text,
Amount2 = txtAmount2.Text,
Fee22 = txtFee22.Text,
Tax22 = txtTax22.Text,
Fee31 = txtFee31.Text,
Tax31 = txtTax31.Text,
Amount3 = txtAmount3.Text,
Fee32 = txtFee32.Text,
Tax32 = txtTax32.Text,
Remarks = txtRemark.Text,
DeleteFlg = ChkDeleteFlg.Checked ? "1" : "0",
ProcessMode = ModeText,
InsertOperator = InOperatorCD,
ProgramID = InProgramID,
Key = ScKouzaCD.Code + " " + ScKouzaCD.ChangeDate,
PC = InPcID,
};
return(mkze);
}
public M_Kouza_Entity M_Kouza_Select(M_Kouza_Entity mspe)
{
DataTable dtKouza = mkzdl.M_Kouza_SelectByKouzaCD(mspe);
if (dtKouza.Rows.Count > 0)
{
mspe.KouzaName = dtKouza.Rows[0]["KouzaName"].ToString();
mspe.BankCD = dtKouza.Rows[0]["BankCD"].ToString();
mspe.BankName = dtKouza.Rows[0]["BankName"].ToString();
mspe.BranchCD = dtKouza.Rows[0]["BranchCD"].ToString();
mspe.BranchName = dtKouza.Rows[0]["BranchName"].ToString();
mspe.KouzaKBN = dtKouza.Rows[0]["KouzaKBN"].ToString();
mspe.KouzaMeigi = dtKouza.Rows[0]["KouzaMeigi"].ToString();
mspe.KouzaNO = dtKouza.Rows[0]["KouzaNO"].ToString();
mspe.Print1 = dtKouza.Rows[0]["Print1"].ToString();
mspe.Print2 = dtKouza.Rows[0]["Print2"].ToString();
mspe.Print3 = dtKouza.Rows[0]["Print3"].ToString();
mspe.Print4 = dtKouza.Rows[0]["Print4"].ToString();
mspe.Fee11 = dtKouza.Rows[0]["Fee11"].ToString();
mspe.Tax11 = dtKouza.Rows[0]["Tax11"].ToString();
mspe.Amount1 = dtKouza.Rows[0]["Amount1"].ToString();
mspe.Fee12 = dtKouza.Rows[0]["Fee12"].ToString();
mspe.Tax12 = dtKouza.Rows[0]["Tax12"].ToString();
mspe.Fee21 = dtKouza.Rows[0]["Fee21"].ToString();
mspe.Tax21 = dtKouza.Rows[0]["Tax21"].ToString();
mspe.Amount2 = dtKouza.Rows[0]["Amount2"].ToString();
mspe.Fee22 = dtKouza.Rows[0]["Fee22"].ToString();
mspe.Tax22 = dtKouza.Rows[0]["Tax22"].ToString();
mspe.Fee31 = dtKouza.Rows[0]["Fee31"].ToString();
mspe.Tax31 = dtKouza.Rows[0]["Tax31"].ToString();
mspe.Amount3 = dtKouza.Rows[0]["Amount3"].ToString();
mspe.Fee32 = dtKouza.Rows[0]["Fee32"].ToString();
mspe.Tax32 = dtKouza.Rows[0]["Tax32"].ToString();
mspe.CompanyCD = dtKouza.Rows[0]["CompanyCD"].ToString();
mspe.CompanyName = dtKouza.Rows[0]["CompanyName"].ToString();
mspe.Remarks = dtKouza.Rows[0]["Remarks"].ToString();
mspe.DeleteFlg = dtKouza.Rows[0]["DeleteFlg"].ToString();
return(mspe);
}
return(null);
}
public DataTable M_Kouza_FeeSelect(M_Kouza_Entity mkze)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@KouzaCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.KouzaCD
} },
{ "@BankCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.BankCD
} },
{ "@BranchCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.BranchCD
} },
{ "@Amount", new ValuePair {
value1 = SqlDbType.Money, value2 = mkze.Amount
} },
};
return(SelectData(dic, "M_Kouza_FeeSelect"));
}
private M_Kouza_Entity GetEntity()
{
mke = new M_Kouza_Entity();
mke.DisplayKbn = radioButton1.Checked ? "0" : "1";
mke.ChangeDate = ckM_Label1.Text;
mke.KouzaCDFrom = detailControls[(int)EIndex.KouzaFrom].Text;
if (detailControls[(int)EIndex.KouzaTo].Text == "")
{
mke.KouzaCDTo = "ZZZ";
}
else
{
mke.KouzaCDTo = detailControls[(int)EIndex.KouzaTo].Text;
}
mke.KouzaName = detailControls[(int)EIndex.KouzaName].Text;
return(mke);
}
public void Select_KouzaFee()
{
if (!string.IsNullOrWhiteSpace(SC_BankCD.TxtCode.Text) && !string.IsNullOrWhiteSpace(SC_BranchCD.TxtCode.Text) &&
!string.IsNullOrWhiteSpace(txtFeeKBN.Text) && txtAmount.Text.Equals("0"))
{
mkze = new M_Kouza_Entity
{
KouzaCD = kouzaCD,
BankCD = SC_BankCD.TxtCode.Text,
BranchCD = SC_BranchCD.TxtCode.Text,
Amount = lblPayGaku.Text.Replace(",", ""),
};
DataTable dt = shnbl.M_Kouza_FeeSelect(mkze);
txtTransferAmount.Text = dt.Rows[0]["Fee"].ToString();
}
else
{
bbl.ShowMessage("E102");
txtTransferAmount.Focus();
}
}
public DataTable M_Kouza_SelectAll(M_Kouza_Entity mbe)
{
string sp = "M_Kouza_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("@KouzaCDFrom", SqlDbType.VarChar).Value = mbe.KouzaCDFrom;
//command.Parameters.Add("@KouzaCDTo", SqlDbType.VarChar).Value = mbe.KouzaCDTo;
//command.Parameters.Add("@KouzaName", SqlDbType.VarChar).Value = mbe.KouzaName;
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@DisplayKbn", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.DisplayKbn
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.ChangeDate
} },
{ "@KouzaCDFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.KouzaCDFrom
} },
{ "@KouzaCDTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.KouzaCDTo
} },
{ "@KouzaName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mbe.KouzaName
} },
};
//command.Parameters.Add("@KouzaKBN1", SqlDbType.TinyInt).Value = mbe.KouzaKBN1;
//command.Parameters.Add("@KouzaKBN2", SqlDbType.TinyInt).Value = mbe.KouzaKBN2;
//command.Parameters.Add("@KouzaKBN3", SqlDbType.TinyInt).Value = mbe.KouzaKBN3;
//return SelectData(sp);
return(SelectData(dic, sp));
}
public DataTable M_Kouza_Select(M_Kouza_Entity mke)
{
string sp = "M_Kouza_Select";
//KTP 2019-0529 全部のFunctionでをしなくてもいいように共通のFunctionでやり方を更新しました。
//command = new SqlCommand(sp, GetConnection());
//command.CommandType = CommandType.StoredProcedure;
//command.CommandTimeout = 0;
//command.Parameters.Add("@KouzaCD", SqlDbType.VarChar).Value = mke.KouzaCD;
//command.Parameters.Add("@ChangeDate", SqlDbType.VarChar).Value = mke.ChangeDate;
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@KouzaCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mke.KouzaCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mke.ChangeDate
} }
};
//return SelectData(sp);
return(SelectData(dic, sp));
}
public DataTable Kouza_Select(M_Kouza_Entity mke)
{
return(mkdl.M_Vendor_Kouza_Select(mke));
}
private void dgvPayment_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dgvPayment.CurrentCell.RowIndex > 0) // PTK added (Error Occurred if click on header)
{
if ((Convert.ToBoolean(dgvPayment.Rows[e.RowIndex].Cells["colChk"].EditedFormattedValue) == true))
{
if (!string.IsNullOrWhiteSpace(cboPaymentType.SelectedValue.ToString()))
{
if (cboPaymentType.SelectedValue.ToString() == "1")
{
//foreach (DataGridViewRow row in dgvPayment.Rows)
//{
// row.Cells["colPaymenttime"].Value = Convert.ToInt32(row.Cells["colScheduledPayment"].Value) - Convert.ToInt32(row.Cells["colAmountPaid"].Value);
// row.Cells["colTransferAmount"].Value = Convert.ToInt32(row.Cells["colScheduledPayment"].Value) - Convert.ToInt32(row.Cells["colAmountPaid"].Value);
// row.Cells["colUnpaidAmount"].Value = "0";
// row.Cells["colOtherThanTransfer"].Value = "0";
//}
dppe.PayPlanDate = dgvPayment.Rows[e.RowIndex].Cells["colPaymentdueDate"].Value.ToString();
dppe.PayeeCD = dgvPayment.Rows[e.RowIndex].Cells["colPayeeCD"].Value.ToString();
if (dt4Detail != null)
{
DataRow[] tblROWS1 = dt4Detail.Select("PayeeCD = '" + dppe.PayeeCD + "'" + "and PayPlanDate = '" + dppe.PayPlanDate + "'");
if (tblROWS1.Length > 0)
{
dtSiharai2 = tblROWS1.CopyToDataTable();
}
mke = new M_Kouza_Entity
{
KouzaCD = cboPaymentSourceAcc.SelectedValue.ToString(),
BankCD = dtSiharai2.Rows[0]["BankCD"].ToString(),
BranchCD = dtSiharai2.Rows[0]["BranchCD"].ToString(),
Amount = lblPayGaku.Text.Replace(",", ""),
};
DataTable dt = sibl.M_Kouza_FeeSelect(mke);
dgvPayment.Rows[e.RowIndex].Cells["colTransferFee"].Value = dt.Rows[0]["Fee"].ToString();
}
dgvPayment.Rows[e.RowIndex].Cells["colPaymenttime"].Value = Convert.ToInt32(dgvPayment.Rows[e.RowIndex].Cells["colScheduledPayment"].Value) - Convert.ToInt32(dgvPayment.Rows[e.RowIndex].Cells["colAmountPaid"].Value);
dgvPayment.Rows[e.RowIndex].Cells["colTransferAmount"].Value = Convert.ToInt32(dgvPayment.Rows[e.RowIndex].Cells["colScheduledPayment"].Value) - Convert.ToInt32(dgvPayment.Rows[e.RowIndex].Cells["colAmountPaid"].Value);
dgvPayment.Rows[e.RowIndex].Cells["colUnpaidAmount"].Value = "0";
dgvPayment.Rows[e.RowIndex].Cells["colOtherThanTransfer"].Value = "0";
if (dt4 != null)
{
for (int i = 0; i < dt4.Rows.Count; i++)
{
double a = Convert.ToDouble(dt4.Rows[i]["PayPlanGaku"].ToString());
double b = Convert.ToDouble(dt4.Rows[i]["PayConfirmGaku"].ToString());
double result = a - b;
dt4.Rows[i]["UnpaidAmount1"] = result.ToString();
dt4.Rows[i]["UnpaidAmount2"] = "0";
}
}
}
else
{
//foreach (DataGridViewRow row in dgvPayment.Rows)
//{
// row.Cells["colPaymenttime"].Value = Convert.ToInt32(row.Cells["colScheduledPayment"].Value) - Convert.ToInt32(row.Cells["colAmountPaid"].Value);
// row.Cells["colTransferAmount"].Value = "0";
// row.Cells["colTransferFee"].Value = "0";
// row.Cells["colUnpaidAmount"].Value = "0";
// row.Cells["colOtherThanTransfer"].Value = Convert.ToInt32(row.Cells["colScheduledPayment"].Value) - Convert.ToInt32(row.Cells["colAmountPaid"].Value);
//}
if (dt4 != null)
{
for (int i = 0; i < dt4.Rows.Count; i++)
{
dt4.Rows[i]["UnpaidAmount1"] = Convert.ToInt32(dt4.Rows[i]["PayPlanGaku"].ToString()) - Convert.ToInt32(dt4.Rows[i]["PayConfirmGaku"].ToString());
dt4.Rows[i]["UnpaidAmount2"] = "0";
}
}
dgvPayment.Rows[e.RowIndex].Cells["colPaymenttime"].Value = Convert.ToInt32(dgvPayment.Rows[e.RowIndex].Cells["colScheduledPayment"].Value) - Convert.ToInt32(dgvPayment.Rows[e.RowIndex].Cells["colAmountPaid"].Value);
dgvPayment.Rows[e.RowIndex].Cells["colTransferAmount"].Value = "0";
dgvPayment.Rows[e.RowIndex].Cells["colTransferFee"].Value = "0";
dgvPayment.Rows[e.RowIndex].Cells["colUnpaidAmount"].Value = "0";
dgvPayment.Rows[e.RowIndex].Cells["colOtherThanTransfer"].Value = Convert.ToInt32(dgvPayment.Rows[e.RowIndex].Cells["colScheduledPayment"].Value) - Convert.ToInt32(dgvPayment.Rows[e.RowIndex].Cells["colAmountPaid"].Value);
}
LabelDataBind();
}
}
}
}
public DataTable M_Kouza_Bind(M_Kouza_Entity mse)
{
return(mmdl.M_Kouza_Bind(mse));
}
public DataTable M_Kouza_SelectAll(M_Kouza_Entity mse)
{
return(mmdl.M_Kouza_SelectAll(mse));
}
public DataTable M_Kouza_Select(M_Kouza_Entity mke)
{
return(mmdl.M_Kouza_Select(mke));
}
public bool M_Kouza_Insert_Update(M_Kouza_Entity mspe, int mode)
{
return(mkzdl.M_Kouza_Insert_Update(mspe, mode));
}
public bool M_Kouza_Insert_Update(M_Kouza_Entity mkze, int mode)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@KouzaCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.KouzaCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mkze.ChangeDate
} },
{ "@KouzaName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.KouzaName
} },
{ "@BankCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.BankCD
} },
{ "@BranchCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.BranchCD
} },
{ "@KouzaKBN", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mkze.KouzaKBN
} },
{ "@KouzaMeigi", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.KouzaMeigi
} },
{ "@KouzaNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.KouzaNO
} },
{ "@Print1", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Print1
} },
{ "@Print2", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Print2
} },
{ "@Print3", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Print3
} },
{ "@Print4", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Print4
} },
{ "@Fee11", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Fee11
} },
{ "@Tax11", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Tax11
} },
{ "@Amount1", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Amount1
} },
{ "@Fee12", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Fee12
} },
{ "@Tax12", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Tax12
} },
{ "@Fee21", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Fee21
} },
{ "@Tax21", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Tax21
} },
{ "@Amount2", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Amount2
} },
{ "@Fee22", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Fee22
} },
{ "@Tax22", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Tax22
} },
{ "@Fee31", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Fee31
} },
{ "@Tax31", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Tax31
} },
{ "@Amount3", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Amount3
} },
{ "@Fee32", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Fee32
} },
{ "@Tax32", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Tax32
} },
{ "@CompanyCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.CompanyCD
} },
{ "@CompanyName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.CompanyName
} },
{ "@Remarks", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Remarks
} },
{ "@DeleteFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mkze.DeleteFlg
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.InsertOperator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.ProcessMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mkze.Key
} },
{ "@Mode", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mode.ToString()
} }
};
UseTransaction = true;
return(InsertUpdateDeleteData(dic, "M_Kouza_Insert_Update"));
}
private bool DisplayData(CKM_SearchControl sc)
{
mkze = new M_Kouza_Entity
{
KouzaCD = sc.Code,
ChangeDate = sc.ChangeDate
};
mkze = mtbbl.M_Kouza_Select(mkze);
if (mkze != null)
{
txtKouzaName.Text = mkze.KouzaName;
ScBankCD.Code = mkze.BankCD;
ScBankCD.LabelText = mkze.BankName;
ScBranchCD.Value1 = mkze.BankCD;
ScBranchCD.Value2 = mkze.BankName;
ScBranchCD.Code = mkze.BranchCD;
ScBranchCD.LabelText = mkze.BranchName;
txtKouzaKBN.Text = mkze.KouzaKBN;
txtKouzaMeigi.Text = mkze.KouzaMeigi;
txtKouzaNO.Text = mkze.KouzaNO;
txtPrint1.Text = mkze.Print1;
txtPrint2.Text = mkze.Print2;
txtPrint3.Text = mkze.Print3;
txtPrint4.Text = mkze.Print4;
txtFee11.Text = mkze.Fee11;
txtTax11.Text = mkze.Tax11;
txtAmount1.Text = mkze.Amount1;
txtFee12.Text = mkze.Fee12;
txtTax12.Text = mkze.Tax12;
txtFee21.Text = mkze.Fee21;
txtTax21.Text = mkze.Tax21;
txtAmount2.Text = mkze.Amount2;
txtFee22.Text = mkze.Fee22;
txtTax22.Text = mkze.Tax22;
txtFee31.Text = mkze.Fee31;
txtTax31.Text = mkze.Tax31;
txtAmount3.Text = mkze.Amount3;
txtFee32.Text = mkze.Fee32;
txtTax32.Text = mkze.Tax32;
txtCompanyCD.Text = mkze.CompanyCD;
txtCompanyName.Text = mkze.CompanyName;
txtRemark.Text = mkze.Remarks;
ChkDeleteFlg.Checked = mkze.DeleteFlg.Equals("1") ? true : false;
txtKouzaName.Focus();
return(true);
}
else
{
mtbbl.ShowMessage("E133");
return(false);
}
}
public DataTable M_Kouza_FeeSelect(M_Kouza_Entity mkze)
{
return(mkzdl.M_Kouza_FeeSelect(mkze));
}
public DataTable M_Kouza_SelectByDate(M_Kouza_Entity mke)
{
return(mkdl.M_Kouza_SelectByDate(mke));
}
public bool M_Kouza_Delete(M_Kouza_Entity mspe)
{
return(mkzdl.M_Kouza_Delete(mspe));
}
