Пример #1
0
        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);
        }
Пример #4
0
        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));
        }
Пример #5
0
        //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"));
        }
Пример #6
0
 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);
        }
Пример #8
0
        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);
        }
Пример #9
0
        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"));
        }
Пример #10
0
        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();
     }
 }
Пример #12
0
        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));
        }
Пример #13
0
        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));
        }
Пример #14
0
 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();
                    }
                }
            }
        }
Пример #16
0
 public DataTable M_Kouza_Bind(M_Kouza_Entity mse)
 {
     return(mmdl.M_Kouza_Bind(mse));
 }
Пример #17
0
 public DataTable M_Kouza_SelectAll(M_Kouza_Entity mse)
 {
     return(mmdl.M_Kouza_SelectAll(mse));
 }
Пример #18
0
 public DataTable M_Kouza_Select(M_Kouza_Entity mke)
 {
     return(mmdl.M_Kouza_Select(mke));
 }
Пример #19
0
 public bool M_Kouza_Insert_Update(M_Kouza_Entity mspe, int mode)
 {
     return(mkzdl.M_Kouza_Insert_Update(mspe, mode));
 }
Пример #20
0
        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);
            }
        }
Пример #22
0
 public DataTable M_Kouza_FeeSelect(M_Kouza_Entity mkze)
 {
     return(mkzdl.M_Kouza_FeeSelect(mkze));
 }
Пример #23
0
 public DataTable M_Kouza_SelectByDate(M_Kouza_Entity mke)
 {
     return(mkdl.M_Kouza_SelectByDate(mke));
 }
Пример #24
0
 public bool M_Kouza_Delete(M_Kouza_Entity mspe)
 {
     return(mkzdl.M_Kouza_Delete(mspe));
 }