コード例 #1
0
ファイル: UserChangedEvent.cs プロジェクト: rivernli/SGP
 public void DoAction()
 {
     return;
     if (WasChanged)
     {
         BI.SGP.BLL.WF.Action.SendMailAction sma = new WF.Action.SendMailAction();
         sma.DoAction(_activity);
     }
 }
コード例 #2
0
ファイル: VVIQuotationDetail.cs プロジェクト: rivernli/SGP
        public void SpecialSendMail(int EntityID,string VendorRFQNumber,string VendorCode)
        {
            string vendormail = "";
            try
            {
                WF.WFUser user = new WF.WFUser(VendorCode);
                if (user != null)
                {
                    vendormail = user.Email;
                }
                else
                {
                    vendormail = "*****@*****.**";
                }
            }
            catch
            {
                vendormail = "*****@*****.**";
            }

            BI.SGP.BLL.WF.WFTemplate wftemplate = new WF.WFTemplate("SUPPLIERWF", EntityID, VendorRFQNumber);
            BI.SGP.BLL.WF.WFActivity wfactivity = wftemplate.FirstActivity;
            BI.SGP.BLL.WF.Action.SendMailAction sendmail = new WF.Action.SendMailAction();
            sendmail.DoActionForVVI(wfactivity, VendorCode, vendormail);
        }
コード例 #3
0
ファイル: DetailModelBase.cs プロジェクト: rivernli/SGP
        public SystemMessages AssignVVIData(int ID, string suppliercode, SystemMessages sysmgs)
        {
            this.ID = ID;
            //SystemMessages sysmgs = new SystemMessages();

            try
            {
                string strField = "", strValue = "";
                FieldInfoCollecton supplierfields = FieldCategory.GetAllFields(FieldCategory.Category_TYPE_SGPFORSUPPLIER);
                string number = "";
                foreach (FieldInfo fi in AllMasterFields)
                {
                    number += fi.FieldName == "Number" ? fi.DataValue.ToString() + "-" + suppliercode : "";

                    foreach (FieldInfo supplierfi in supplierfields)
                    {
                        if (fi.DisplayName == supplierfi.DisplayName)
                        {
                            if (supplierfi.FieldName == "NVARCHAR1")
                            {
                                fi.DataValue = number;
                                strField += supplierfi.FieldName + ",";
                                strValue += "'" + number + "',";
                            }

                            else
                            {
                                strField += supplierfi.FieldName + ",";
                                strValue += "'" + fi.DataValue.ToString() + "',";
                            }
                        }
                    }
                }

                strField += "DATETIME2,";
                strValue += "GetDate(),";

                string vendorname = DbHelperSQL.GetSingle<string>("select SupplierName from SYS_Supplier where SupplyCode=@SupplyCode", new SqlParameter("@SupplyCode",suppliercode));
                vendorname = suppliercode + "[" + vendorname + "]";

                strField += "NVARCHAR7,";
                strValue += "'" + vendorname + "',";

                strField = strField.TrimEnd(',');
                strValue = strValue.TrimEnd(',');
                bool existsRFQNumber = DbHelperSQL.Exists("select count(*) from SGP_SubData where NVARCHAR1=@Number and EntityName='VVIDETAIL' ", new SqlParameter("@Number", number));
                if (existsRFQNumber == false)
                {
                    try
                    {
                        int maxdataindex = -1;
                        maxdataindex = DbHelperSQL.GetSingle<int>("select Max(DataIndex) from SGP_SubData where EntityID=" + ID.ToString() + " and EntityName='VVIDETAIL'");
                        maxdataindex++;
                        string strSql = "insert into SGP_SubData(DataIndex,EntityID,EntityName," + strField + ") values(" + maxdataindex.ToString() + "," + ID.ToString() + ",'VVIDETAIL'," + strValue + ")";
                        DbHelperSQL.ExecuteSql(strSql);
                        string vendormail = "";
                        try
                        {
                            WF.WFUser user = new WF.WFUser(suppliercode);
                            if (user != null)
                            {
                                vendormail = user.Email;
                            }
                            else
                            {
                                vendormail = "*****@*****.**";
                            }
                        }
                        catch
                        {
                            vendormail = "*****@*****.**";
                        }

                       // wf.Run();
                        sysmgs.isPass = true;
                        sysmgs.MessageType = "Success";
                        sysmgs.Messages.Add("OK", number);
                        BI.SGP.BLL.WF.WFTemplate wftemplate = new WF.WFTemplate("SUPPLIERWF", ID, number);
                        BI.SGP.BLL.WF.WFActivity wfactivity = wftemplate.FirstActivity;
                        BI.SGP.BLL.WF.Action.SendMailAction sendmail = new WF.Action.SendMailAction();
                        sendmail.DoActionForVVI(wfactivity, vendorname, vendormail);

                        string strsql1 = "update SGP_RFQForVVI set ActivityID=102 where (ActivityID in(101) or ActivityID is null) and RFQID=@RFQID";

                        string strsql2 = "insert into SYS_WFProcessLog select @RFQID,3,@FromActivityID,@ToActivityID,0,GetDate(),@UserID,@Comment";

                        SqlParameter[] sp1 = new SqlParameter[] { new SqlParameter("@RFQID", ID) };

                        SqlParameter[] sp2 = new SqlParameter[] { new SqlParameter("@RFQID",ID),
                                                                  new SqlParameter("@FromActivityID",101),
                                                                  new SqlParameter("@ToActivityID",102),
                                                                  new SqlParameter("@UserID", BI.SGP.BLL.Utils.AccessControl.CurrentLogonUser.Uid),
                                                                  new SqlParameter("@Comment", "Assign RFQ")};

                        DbHelperSQL.ExecuteSql(strsql1, sp1.ToArray());
                        DbHelperSQL.ExecuteSql(strsql2, sp2.ToArray());

                        AddHistory();
                    }
                    catch (Exception ex)
                    {
                        sysmgs.isPass = false;
                        sysmgs.MessageType = "Error";
                        sysmgs.Messages.Add("Error",ex.Message);
                    }
                }
                else
                {
                    sysmgs.isPass = false;
                    sysmgs.MessageType = "already exists";
                    sysmgs.Messages.Add("already exists", number);
                }
            }
            catch (Exception ex)
            {
                sysmgs.isPass = false;
                sysmgs.MessageType = "Error";
                sysmgs.Messages.Add("Error", ex.Message);
            }
            return sysmgs;
        }