/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateTime(Panther.Email.Entity.Model.EmailAccount model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update EmailAccount set ");
strSql.Append("EmailAccountRemainEmailCount=@EmailAccountRemainEmailCount,");
strSql.Append("EmailAccountLastTime=@EmailAccountLastTime");
strSql.Append(" where EmailAccountID=@EmailAccountID");
SqlParameter[] parameters =
{
new SqlParameter("@EmailAccountID", SqlDbType.VarChar, 40),
new SqlParameter("@EmailAccountRemainEmailCount", SqlDbType.Int),
new SqlParameter("@EmailAccountLastTime", SqlDbType.Date)
};
parameters[0].Value = model.EmailAccountID;
parameters[1].Value = model.EmailAccountRemainEmailCount;
parameters[3].Value = model.EmailAccountLastTime;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Panther.Email.Entity.Model.EmailAccount model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into EmailAccount(");
strSql.Append("EmailAccountID,EmailAccountAddress,EmailAccountPassWord,EmailAccountName,EmailAccountSMTP,EmailAccountSMTPPort,EmailAccountPOP3,EmailAccountPOP3Port,EmailAccountIsSSL,EmailAccountMaxEmailCount,EmailAccountRemainEmailCount,EmailAccountSpace,EmailAccountCreateTime,EmailAccountLastTime,SendState,SendMode)");
strSql.Append(" values (");
strSql.Append("@EmailAccountID,@EmailAccountAddress,@EmailAccountPassWord,@EmailAccountName,@EmailAccountSMTP,@EmailAccountSMTPPort,@EmailAccountPOP3,@EmailAccountPOP3Port,@EmailAccountIsSSL,@EmailAccountMaxEmailCount,@EmailAccountRemainEmailCount,@EmailAccountSpace,@EmailAccountCreateTime,@EmailAccountLastTime,0,@SendMode)");
SqlParameter[] parameters =
{
new SqlParameter("@EmailAccountID", SqlDbType.VarChar, 40),
new SqlParameter("@EmailAccountAddress", SqlDbType.VarChar, 0),
new SqlParameter("@EmailAccountPassWord", SqlDbType.VarChar, 255),
new SqlParameter("@EmailAccountName", SqlDbType.VarChar, 255),
new SqlParameter("@EmailAccountSMTP", SqlDbType.VarChar, 255),
new SqlParameter("@EmailAccountSMTPPort", SqlDbType.Int),
new SqlParameter("@EmailAccountPOP3", SqlDbType.VarChar, 255),
new SqlParameter("@EmailAccountPOP3Port", SqlDbType.Int),
new SqlParameter("@EmailAccountIsSSL", SqlDbType.Bit, 1),
new SqlParameter("@EmailAccountMaxEmailCount", SqlDbType.Int),
new SqlParameter("@EmailAccountRemainEmailCount", SqlDbType.Int),
new SqlParameter("@EmailAccountSpace", SqlDbType.Int),
new SqlParameter("@EmailAccountCreateTime", SqlDbType.Date),
new SqlParameter("@EmailAccountLastTime", SqlDbType.Date),
new SqlParameter("@SendMode", SqlDbType.Int)
};
parameters[0].Value = model.EmailAccountID;
parameters[1].Value = model.EmailAccountAddress;
parameters[2].Value = model.EmailAccountPassWord;
parameters[3].Value = model.EmailAccountName == null ? "" : model.EmailAccountName;
parameters[4].Value = model.EmailAccountSMTP == null ? "" : model.EmailAccountSMTP;
parameters[5].Value = model.EmailAccountSMTPPort;
parameters[6].Value = model.EmailAccountPOP3 == null ? "" : model.EmailAccountPOP3;
parameters[7].Value = model.EmailAccountPOP3Port;
parameters[8].Value = model.EmailAccountIsSSL;
parameters[9].Value = model.EmailAccountMaxEmailCount;
parameters[10].Value = model.EmailAccountMaxEmailCount;
parameters[11].Value = model.EmailAccountSpace;
parameters[12].Value = model.EmailAccountCreateTime;
parameters[13].Value = model.EmailAccountLastTime;
parameters[14].Value = model.SendMode;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Panther.Email.Entity.Model.EmailAccount GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select EmailAccountID,EmailAccountAddress,EmailAccountPassWord,EmailAccountName,EmailAccountSMTP,EmailAccountSMTPPort,EmailAccountPOP3,EmailAccountPOP3Port,EmailAccountIsSSL,EmailAccountMaxEmailCount,EmailAccountRemainEmailCount,EmailAccountSpace,EmailAccountCreateTime,EmailAccountLastTime,SendMode,SendState from EmailAccount ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
Panther.Email.Entity.Model.EmailAccount model = new Panther.Email.Entity.Model.EmailAccount();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public bool UpdateState(Panther.Email.Entity.Model.EmailAccount model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update EmailAccount set ");
strSql.Append(" SendState=1 ");
strSql.Append(" where EmailAccountID=@EmailAccountID");
SqlParameter[] parameters =
{
new SqlParameter("@EmailAccountID", SqlDbType.VarChar, 40)
};
parameters[0].Value = model.EmailAccountID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Panther.Email.Entity.Model.EmailAccount model, bool isupdate)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update EmailAccount set ");
strSql.Append("EmailAccountAddress=@EmailAccountAddress,");
strSql.Append("EmailAccountPassWord=@EmailAccountPassWord,");
strSql.Append("EmailAccountName=@EmailAccountName,");
strSql.Append("EmailAccountSMTP=@EmailAccountSMTP,");
strSql.Append("EmailAccountSMTPPort=@EmailAccountSMTPPort,");
strSql.Append("EmailAccountPOP3=@EmailAccountPOP3,");
strSql.Append("EmailAccountPOP3Port=@EmailAccountPOP3Port,");
strSql.Append("EmailAccountIsSSL=@EmailAccountIsSSL,");
strSql.Append("EmailAccountMaxEmailCount=@EmailAccountMaxEmailCount,");
strSql.Append("EmailAccountRemainEmailCount=@EmailAccountRemainEmailCount,");
strSql.Append("EmailAccountSpace=@EmailAccountSpace,");
strSql.Append("EmailAccountCreateTime=@EmailAccountCreateTime,");
//strSql.Append("EmailAccountLastTime=@EmailAccountLastTime,");
strSql.Append("SendState=0,");
strSql.Append("SendMode=@SendMode ");
strSql.Append(" where EmailAccountID=@EmailAccountID");
SqlParameter[] parameters =
{
new SqlParameter("@EmailAccountAddress", SqlDbType.VarChar, 1000),
new SqlParameter("@EmailAccountPassWord", SqlDbType.VarChar, 255),
new SqlParameter("@EmailAccountName", SqlDbType.VarChar, 255),
new SqlParameter("@EmailAccountSMTP", SqlDbType.VarChar, 255),
new SqlParameter("@EmailAccountSMTPPort", SqlDbType.Int),
new SqlParameter("@EmailAccountPOP3", SqlDbType.VarChar, 255),
new SqlParameter("@EmailAccountPOP3Port", SqlDbType.Int),
new SqlParameter("@EmailAccountIsSSL", SqlDbType.Bit, 1),
new SqlParameter("@EmailAccountMaxEmailCount", SqlDbType.Int),
new SqlParameter("@EmailAccountRemainEmailCount", SqlDbType.Int),
new SqlParameter("@EmailAccountSpace", SqlDbType.Int),
new SqlParameter("@EmailAccountCreateTime", SqlDbType.DateTime),
//new SqlParameter("@EmailAccountLastTime", SqlDbType.DateTime),
new SqlParameter("@SendMode", SqlDbType.Int),
new SqlParameter("@EmailAccountID", SqlDbType.VarChar, 40)
};
parameters[0].Value = model.EmailAccountAddress;
parameters[1].Value = model.EmailAccountPassWord;
parameters[2].Value = model.EmailAccountName;
parameters[3].Value = model.EmailAccountSMTP;
parameters[4].Value = model.EmailAccountSMTPPort;
parameters[5].Value = model.EmailAccountPOP3;
parameters[6].Value = model.EmailAccountPOP3Port;
parameters[7].Value = model.EmailAccountIsSSL;
parameters[8].Value = model.EmailAccountMaxEmailCount;
parameters[9].Value = model.EmailAccountRemainEmailCount;
parameters[10].Value = model.EmailAccountSpace;
parameters[11].Value = model.EmailAccountCreateTime;
//parameters[12].Value = model.EmailAccountLastTime;
parameters[12].Value = model.SendMode;
parameters[13].Value = model.EmailAccountID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Panther.Email.Entity.Model.EmailAccount DataRowToModel(DataRow row)
{
Panther.Email.Entity.Model.EmailAccount model = new Panther.Email.Entity.Model.EmailAccount();
if (row != null)
{
if (row["EmailAccountID"] != null)
{
model.EmailAccountID = row["EmailAccountID"].ToString();
}
if (row["EmailAccountAddress"] != null)
{
model.EmailAccountAddress = row["EmailAccountAddress"].ToString();
}
if (row["EmailAccountPassWord"] != null)
{
model.EmailAccountPassWord = row["EmailAccountPassWord"].ToString();
}
if (row["EmailAccountName"] != null)
{
model.EmailAccountName = row["EmailAccountName"].ToString();
}
if (row["EmailAccountSMTP"] != null)
{
model.EmailAccountSMTP = row["EmailAccountSMTP"].ToString();
}
if (row["EmailAccountSMTPPort"] != null)
{
model.EmailAccountSMTPPort = (int)(row["EmailAccountSMTPPort"]);
}
if (row["EmailAccountPOP3"] != null)
{
model.EmailAccountPOP3 = row["EmailAccountPOP3"].ToString();
}
if (row["EmailAccountPOP3Port"] != null)
{
model.EmailAccountPOP3Port = (int)(row["EmailAccountPOP3Port"]);
}
if (row["SendState"] != null)
{
model.SendState = (int)(row["SendState"]);
}
if (row["SendMode"] != null)
{
model.SendMode = (int)(row["SendMode"]);
}
if (row["EmailAccountIsSSL"] != null && row["EmailAccountIsSSL"].ToString() != "")
{
if ((row["EmailAccountIsSSL"].ToString() == "1") || (row["EmailAccountIsSSL"].ToString().ToLower() == "true"))
{
model.EmailAccountIsSSL = true;
}
else
{
model.EmailAccountIsSSL = false;
}
}
model.EmailAccountMaxEmailCount = (int)(row["EmailAccountMaxEmailCount"]);
model.EmailAccountRemainEmailCount = (int)(row["EmailAccountRemainEmailCount"]);
model.EmailAccountSpace = (int)(row["EmailAccountSpace"]);
if (row["EmailAccountCreateTime"] != null && row["EmailAccountCreateTime"].ToString() != "")
{
model.EmailAccountCreateTime = DateTime.Parse(row["EmailAccountCreateTime"].ToString());
}
if (row["EmailAccountLastTime"] != null && row["EmailAccountLastTime"].ToString() != "")
{
model.EmailAccountLastTime = DateTime.Parse(row["EmailAccountLastTime"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Panther.Email.Entity.Model.EmailAccount model, bool isUpdateTime)
{
return(dal.Update(model, true));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Panther.Email.Entity.Model.EmailAccount model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Panther.Email.Entity.Model.EmailAccount model)
{
return(dal.Add(model));
}