存储过程创建
CREATE proc P_Smtp_Addr_By_GRP_Code_Get_FOR_PIC(@Cust_NO varchar(50), @Address varchar(100) output, @Passward varchar(100) output, @smtpDomain varchar(100) output, @ErrMessage varchar(100) output)as beginSELECT --GRP_Code, --GRP_Desc, @Address=Address, @Passward=Passward, @smtpDomain=smtpDomainfrom SMTP_Address_Enable left join Base_Customer_Info on SMTP_Address_Enable.Cust_NO=Base_Customer_Info.Customer_NO left join SMTP_SendAddress on Base_Customer_Info.CUST_GRP_CODE=SMTP_SendAddress.GRP_Code where SMTP_Address_Enable.Cust_NO=@Cust_NO
if(@Address='')begin SELECT --GRP_Code, --GRP_Desc, @Address=Address, @Passward=Passward, @smtpDomain=smtpDomainfrom SMTP_SendAddresswhere GRP_Code='other'end
if(@Address='')begin set @ErrMessage='无邮箱'end
endGO
类代码：
using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;using System.Configuration;using NDO;namespace SMTPBusiLogic{ public class P_Smtp_Addr_By_GRP_Code_Get_FOR_PIC { private string _Address; private string _Passward; private string _smtpDomain; private string _ErrMessage;
public string Address { get { return _Address; } set { _Address = value; }
} public string Passward { get { return _Passward; } set { _Passward = value; }
}
public string smtpDomain { get { return _smtpDomain; } set { _smtpDomain = value; }
} public string ErrMessage { get { return _ErrMessage; } set { _ErrMessage = value; }
}
public static P_Smtp_Addr_By_GRP_Code_Get_FOR_PIC Smtp_Addr_By_GRP_Code_Get_FOR_PIC(string cust_no) { P_Smtp_Addr_By_GRP_Code_Get_FOR_PIC Smtp_Addr_FOR_PIC_class = new P_Smtp_Addr_By_GRP_Code_Get_FOR_PIC(); try { string ConnString = "";
ConnString = ConfigurationManager.ConnectionStrings["ConnectLocal"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(ConnString); sqlConn.Open(); string sql = "P_Smtp_Addr_By_GRP_Code_Get_FOR_PIC"; SqlCommand sqlCmd = new SqlCommand(sql, sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandTimeout = 9999999; SqlParameter par_sendaddress = new SqlParameter("@Cust_NO", System.Data.SqlDbType.VarChar, 100); par_sendaddress.Direction = ParameterDirection.Input; par_sendaddress.Value = cust_no;
sqlCmd.Parameters.Add(par_sendaddress); sqlCmd.Parameters.Add("@Address", System.Data.SqlDbType.VarChar, 100).Direction = ParameterDirection.Output; sqlCmd.Parameters.Add("@Passward", System.Data.SqlDbType.VarChar, 100).Direction = ParameterDirection.Output; sqlCmd.Parameters.Add("@smtpDomain", System.Data.SqlDbType.VarChar, 100).Direction = ParameterDirection.Output; sqlCmd.Parameters.Add("@ErrMessage", System.Data.SqlDbType.VarChar, 100).Direction = ParameterDirection.Output;
sqlCmd.ExecuteNonQuery(); Smtp_Addr_FOR_PIC_class.Address = sqlCmd.Parameters["@Address"].Value.ToString(); Smtp_Addr_FOR_PIC_class.Passward = sqlCmd.Parameters["@Passward"].Value.ToString(); Smtp_Addr_FOR_PIC_class.smtpDomain = sqlCmd.Parameters["@smtpDomain"].Value.ToString(); Smtp_Addr_FOR_PIC_class.ErrMessage = sqlCmd.Parameters["@ErrMessage"].Value.ToString();
sqlConn.Close();
} catch (System.Exception ex) {
throw new System.Exception(ex.StackTrace); } return Smtp_Addr_FOR_PIC_class; }
}}
前台界面：
P_SMTP_SendAddress_Get_Send_For_STOCK class_SendAddress = P_SMTP_SendAddress_Get_Send_For_STOCK.Class_SMTP_SendAddress_Get_Send_For_STOCK(cust_no); if (class_SendAddress.ErrMessage != "") { MessageBox.Show(cust_no + " 没有设置发送邮件!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; }
转载于:https://www.cnblogs.com/yuxh/archive/2011/11/24/2261448.html
