プロジェクト

全般

プロフィール

リビジョン 452

堀内 が約6年前に追加

入金入力：掲示板メッセージ修正・掲示板対象者同一人物を複数出さないように修正

差分を表示:

trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/Request/SelectPayment/FrmEntryDeposit.cs
913 913 
                strContentText.AppendFormat("{0}様より入金がありました。\r\n", OrderersName.Text);
914 914 
                strContentText.Append("入金内容の確認をよろしくお願いします。");
915 915 

  		




  916
  
  
    
                // 備考があれば掲示板へ載せる


  		




  917
  
  
    
                if (deposit.Note.Length > 0)


  		




  918
  
  
    
                {


  		




  919
  
  
    
                    strContentText.Append("\r\n");


  		




  920
  
  
    
                    strContentText.Append(" \r\n");


  		




  921
  
  
    
                    strContentText.AppendFormat("{0}/{1}:{2}", deposit.DepositDate.Month


  		




  922
  
  
    
                                                                , deposit.DepositDate.Day


  		




  923
  
  
    
                                                                , deposit.Note);


  		




  924
  
  
    
                }


  		




  
  916
  
    
                // 入金情報


  		




  
  917
  
    
                strContentText.Append("\r\n");


  		




  
  918
  
    
                strContentText.Append(" \r\n");


  		




  
  919
  
    
                strContentText.Append("|  入金日 |   入金金額(現金)  |   入金金額(手形)  |   備考\r\n");


  		




  
  920
  
    
                strContentText.Append("----------+------------------+------------------+----------\r\n");


  		




  
  921
  
    
                strContentText.AppendFormat("|　{0}/{1}　|", deposit.DepositDate.Month.ToString("00"), deposit.DepositDate.Day.ToString("00"));


  		




  
  922
  
    

  		




  
  923
  
    
                string strwrk = deposit.DepositAmountCash.ToString("#,0");


  		




  
  924
  
    
                for (int i = 0; i < (16 - strwrk.Length); i++) strContentText.Append(" ");


  		




  
  925
  
    
                strContentText.AppendFormat("{0}  |", strwrk);


  		




  
  926
  
    

  		




  
  927
  
    
                strwrk = deposit.DepositAmountBill.ToString("#,0");


  		




  
  928
  
    
                for (int i = 0; i < (16 - strwrk.Length); i++) strContentText.Append(" ");


  		




  
  929
  
    
                strContentText.AppendFormat("{0}  |", strwrk);


  		




  
  930
  
    
                strContentText.AppendFormat(" {0}", deposit.Note);


  		




  925
  931
  
    
                data.MessageContent = strContentText.ToString();


  		




  926
  932
  
    

  		




  927
  933
  
    
                // リンク情報


  		




  ......




  967
  973
  
    
                {


  		




  968
  974
  
    
                    cbiDDB.connect();


  		




  969
  975
  
    

  		




  970
  
  
    
                    string strSQL = "SELECT A.ConstructionCode, B.PERSONCODE SCODE, B.PERSONNAME SNAME, C.PERSONCODE CCODE, C.PERSONNAME CNAME";


  		




  971
  
  
    
                    strSQL += " FROM CONSTRUCTIONBASEINFO P";


  		




  972
  
  
    
                    strSQL += " INNER JOIN REQUESTHEAD H ON H.REQCONSTRUCTIONCODE = P.CONSTRUCTIONCODE";


  		




  973
  
  
    
                    strSQL += string.Format(" AND H.ORDERERSDIVISION = {0}", deposit.OrderersDivision);


  		




  974
  
  
    
                    strSQL += string.Format(" AND H.ORDERERSCODE = {0}", deposit.OrderersCode);


  		




  975
  
  
    
                    strSQL += string.Format(" AND H.REQUESTMONTH = {0}", deposit.TargetDate);


  		




  976
  
  
    
                    strSQL += " LEFT JOIN PERSONINCHARGEMASTER B ON B.PERSONCODE = P.SALESPERSONCODE";


  		




  977
  
  
    
                    strSQL += " LEFT JOIN PERSONINCHARGEMASTER C ON C.PERSONCODE = P.CONSTRUCTIONPERSONCODE";


  		




  978
  
  
    
                    strSQL += ", CONSTRUCTIONBASEINFODETAIL A";


  		




  979
  
  
    
                    strSQL += " WHERE P.CONSTRUCTIONCODE = H.REQCONSTRUCTIONCODE";


  		




  980
  
  
    
                    strSQL += string.Format(" AND A.CONSTRUCTIONCODE = P.CONSTRUCTIONCODE AND A.DETAILNO = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);


  		




  
  976
  
    
                    StringBuilder strSQL = new StringBuilder();


  		




  
  977
  
    
                    strSQL.Append("SELECT A.ConstructionCode, B.PERSONCODE SCODE, B.PERSONNAME SNAME, C.PERSONCODE CCODE, C.PERSONNAME CNAME");


  		




  
  978
  
    
                    strSQL.Append(" FROM CONSTRUCTIONBASEINFO P");


  		




  
  979
  
    
                    strSQL.Append(" INNER JOIN REQUESTHEAD H ON H.REQCONSTRUCTIONCODE = P.CONSTRUCTIONCODE");


  		




  
  980
  
    
                    strSQL.AppendFormat(" AND H.ORDERERSDIVISION = {0}", deposit.OrderersDivision);


  		




  
  981
  
    
                    strSQL.AppendFormat(" AND H.ORDERERSCODE = {0}", deposit.OrderersCode);


  		




  
  982
  
    
                    strSQL.AppendFormat(" AND H.REQUESTMONTH = {0}", deposit.TargetDate);


  		




  
  983
  
    
                    strSQL.Append(" LEFT JOIN PERSONINCHARGEMASTER B ON B.PERSONCODE = P.SALESPERSONCODE");


  		




  
  984
  
    
                    strSQL.Append(" LEFT JOIN PERSONINCHARGEMASTER C ON C.PERSONCODE = P.CONSTRUCTIONPERSONCODE");


  		




  
  985
  
    
                    strSQL.Append(", CONSTRUCTIONBASEINFODETAIL A");


  		




  
  986
  
    
                    strSQL.Append(" WHERE P.CONSTRUCTIONCODE = H.REQCONSTRUCTIONCODE");


  		




  
  987
  
    
                    strSQL.AppendFormat(" AND A.CONSTRUCTIONCODE = P.CONSTRUCTIONCODE AND A.DETAILNO = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);


  		




  981
  988
  
    
                    ArrayList arList = new ArrayList();


  		




  982
  
  
    
                    if (!cbiDDB.ExecuteReader(strSQL, ref arList)) return false;


  		




  
  989
  
    
                    if (!cbiDDB.ExecuteReader(strSQL.ToString(), ref arList)) return false;


  		




  983
  990
  
    

  		




  984
  991
  
    
                    string ConstructionCode = string.Empty;


  		




  985
  992
  
    
                    int SalesPersonCode = 0;


  		




  ......




  996
  1003
  
    
                        ConstructionPersonCode = CommonMotions.cnvInt(onjwrk[3]);


  		




  997
  1004
  
    
                        ConstructionPersonName = CommonMotions.cnvString(onjwrk[4]);


  		




  998
  1005
  
    

  		




  
  1006
  
    
                        MessageBoardTerget[] wrkRec = terList.Cast<MessageBoardTerget>().Where(x => x.ToCode == ConstructionPersonCode).ToArray();


  		




  
  1007
  
    
                        if (wrkRec.Count() > 0) continue;


  		




  
  1008
  
    

  		




  999
  1009
  
    
                        // 営業担当は掲示板データを作成しない


  		




  1000
  1010
  
    
                        // キーコードセット


  		




  1001
  1011
  
    
                        //wrkTer = new MessageBoardTerget();


  		












  

    
      trunk/src/ProcessManagement/ProcessManagement/Forms/SubForms/FrmMessageBoardReader.designer.cs
    
  





  49
  49
  
    
            this.lblLinkLine = new System.Windows.Forms.Label();


  		




  50
  50
  
    
            this.lblComent = new System.Windows.Forms.Label();


  		




  51
  51
  
    
            this.label6 = new System.Windows.Forms.Label();


  		




  
  52
  
    
            this.btnPA = new System.Windows.Forms.Button();


  		




  52
  53
  
    
            this.dgvAllDisplay = new ProcessManagement.Forms.CustomControls.DataGridViewEX();


  		




  53
  54
  
    
            this.Column1 = new System.Windows.Forms.DataGridViewTextBoxColumn();


  		




  54
  55
  
    
            this.Column2 = new System.Windows.Forms.DataGridViewTextBoxColumn();


  		




  55
  56
  
    
            this.Column3 = new System.Windows.Forms.DataGridViewTextBoxColumn();


  		




  56
  
  
    
            this.btnPA = new System.Windows.Forms.Button();


  		




  57
  57
  
    
            ((System.ComponentModel.ISupportInitialize)(this.dgvAllDisplay)).BeginInit();


  		




  58
  58
  
    
            this.SuspendLayout();


  		




  59
  59
  
    
            // 


  		




  ......




  137
  137
  
    
            // txtMessage


  		




  138
  138
  
    
            // 


  		




  139
  139
  
    
            this.txtMessage.BackColor = System.Drawing.Color.White;


  		




  
  140
  
    
            this.txtMessage.Font = new System.Drawing.Font("ＭＳ 明朝", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));


  		




  140
  141
  
    
            this.txtMessage.ImeMode = System.Windows.Forms.ImeMode.On;


  		




  141
  142
  
    
            this.txtMessage.Location = new System.Drawing.Point(8, 377);


  		




  142
  143
  
    
            this.txtMessage.Multiline = true;


  		




  ......




  257
  258
  
    
            this.label6.Text = "閲覧者履歴";


  		




  258
  259
  
    
            this.label6.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;


  		




  259
  260
  
    
            // 


  		




  
  261
  
    
            // btnPA


  		




  
  262
  
    
            // 


  		




  
  263
  
    
            this.btnPA.BackColor = System.Drawing.Color.DimGray;


  		




  
  264
  
    
            this.btnPA.ForeColor = System.Drawing.Color.White;


  		




  
  265
  
    
            this.btnPA.Location = new System.Drawing.Point(1018, 8);


  		




  
  266
  
    
            this.btnPA.Name = "btnPA";


  		




  
  267
  
    
            this.btnPA.Size = new System.Drawing.Size(150, 30);


  		




  
  268
  
    
            this.btnPA.TabIndex = 10;


  		




  
  269
  
    
            this.btnPA.TabStop = false;


  		




  
  270
  
    
            this.btnPA.Text = "期限チェック解除";


  		




  
  271
  
    
            this.btnPA.UseVisualStyleBackColor = false;


  		




  
  272
  
    
            this.btnPA.Visible = false;


  		




  
  273
  
    
            this.btnPA.Click += new System.EventHandler(this.btnPA_Click);


  		




  
  274
  
    
            // 


  		




  260
  275
  
    
            // dgvAllDisplay


  		




  261
  276
  
    
            // 


  		




  262
  277
  
    
            this.dgvAllDisplay.AllowUserToAddRows = false;


  		




  ......




  323
  338
  
    
            this.Column3.ReadOnly = true;


  		




  324
  339
  
    
            this.Column3.Width = 180;


  		




  325
  340
  
    
            // 


  		




  326
  
  
    
            // btnPA


  		




  327
  
  
    
            // 


  		




  328
  
  
    
            this.btnPA.BackColor = System.Drawing.Color.DimGray;


  		




  329
  
  
    
            this.btnPA.ForeColor = System.Drawing.Color.White;


  		




  330
  
  
    
            this.btnPA.Location = new System.Drawing.Point(1018, 8);


  		




  331
  
  
    
            this.btnPA.Name = "btnPA";


  		




  332
  
  
    
            this.btnPA.Size = new System.Drawing.Size(150, 30);


  		




  333
  
  
    
            this.btnPA.TabIndex = 10;


  		




  334
  
  
    
            this.btnPA.TabStop = false;


  		




  335
  
  
    
            this.btnPA.Text = "期限チェック解除";


  		




  336
  
  
    
            this.btnPA.UseVisualStyleBackColor = false;


  		




  337
  
  
    
            this.btnPA.Visible = false;


  		




  338
  
  
    
            this.btnPA.Click += new System.EventHandler(this.btnPA_Click);


  		




  339
  
  
    
            // 


  		




  340
  341
  
    
            // FrmMessageBoardReader


  		




  341
  342
  
    
            // 


  		




  342
  343
  
    
            this.AutoScaleDimensions = new System.Drawing.SizeF(96F, 96F);


  		












他の形式にエクスポート:  Unified diff