/// <summary>
/// 增加一条数据
/// </summary>
public int AddDataToMailInfo(DataToMailInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbDataToMailInfo(");
strSql.Append("dDataType,dDateType,dState,dEmail,dAppendTime)");
strSql.Append(" values (");
strSql.Append("@dDataType,@dDateType,@dState,@dEmail,@dAppendTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@dDataType", SqlDbType.Int, 4),
new SqlParameter("@dDateType", SqlDbType.Int, 4),
new SqlParameter("@dState", SqlDbType.Int, 4),
new SqlParameter("@dEmail", SqlDbType.VarChar, 512),
new SqlParameter("@dAppendTime", SqlDbType.DateTime)
};
parameters[0].Value = model.dDataType;
parameters[1].Value = model.dDateType;
parameters[2].Value = model.dState;
parameters[3].Value = model.dEmail;
parameters[4].Value = model.dAppendTime;
object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters);
if (obj == null)
{
return(-1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DataToMailInfo GetDataToMailInfoModel(int DataToMaillID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 DataToMaillID,dDataType,dDateType,dState,dEmail,dAppendTime from tbDataToMailInfo ");
strSql.Append(" where DataToMaillID=@DataToMaillID");
SqlParameter[] parameters =
{
new SqlParameter("@DataToMaillID", SqlDbType.Int, 4)
};
parameters[0].Value = DataToMaillID;
DataToMailInfo model = new DataToMailInfo();
DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["DataToMaillID"].ToString() != "")
{
model.DataToMaillID = int.Parse(ds.Tables[0].Rows[0]["DataToMaillID"].ToString());
}
if (ds.Tables[0].Rows[0]["dDataType"].ToString() != "")
{
model.dDataType = int.Parse(ds.Tables[0].Rows[0]["dDataType"].ToString());
}
if (ds.Tables[0].Rows[0]["dDateType"].ToString() != "")
{
model.dDateType = int.Parse(ds.Tables[0].Rows[0]["dDateType"].ToString());
}
if (ds.Tables[0].Rows[0]["dState"].ToString() != "")
{
model.dState = int.Parse(ds.Tables[0].Rows[0]["dState"].ToString());
}
model.dEmail = ds.Tables[0].Rows[0]["dEmail"].ToString();
if (ds.Tables[0].Rows[0]["dAppendTime"].ToString() != "")
{
model.dAppendTime = DateTime.Parse(ds.Tables[0].Rows[0]["dAppendTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateDataToMailInfo(DataToMailInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbDataToMailInfo set ");
strSql.Append("dDataType=@dDataType,");
strSql.Append("dDateType=@dDateType,");
strSql.Append("dState=@dState,");
strSql.Append("dEmail=@dEmail,");
strSql.Append("dAppendTime=@dAppendTime");
strSql.Append(" where DataToMaillID=@DataToMaillID");
SqlParameter[] parameters =
{
new SqlParameter("@dDataType", SqlDbType.Int, 4),
new SqlParameter("@dDateType", SqlDbType.Int, 4),
new SqlParameter("@dState", SqlDbType.Int, 4),
new SqlParameter("@dEmail", SqlDbType.VarChar, 512),
new SqlParameter("@dAppendTime", SqlDbType.DateTime),
new SqlParameter("@DataToMaillID", SqlDbType.Int, 4)
};
parameters[0].Value = model.dDataType;
parameters[1].Value = model.dDateType;
parameters[2].Value = model.dState;
parameters[3].Value = model.dEmail;
parameters[4].Value = model.dAppendTime;
parameters[5].Value = model.DataToMaillID;
int rows = DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool UpdateDataToMailInfo(DataToMailInfo model)
{
return(DatabaseProvider.GetInstance().UpdateDataToMailInfo(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int AddDataToMailInfo(DataToMailInfo model)
{
return(DatabaseProvider.GetInstance().AddDataToMailInfo(model));
}
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X"))
{
int DataToMaillID = HTTPRequest.GetInt("did", 0);
Act = HTTPRequest.GetString("Act");
if (Act == "Edit")
{
dtm = tbDataToMailInfo.GetDataToMailInfoModel(DataToMaillID);
}
if (ispost)
{
dtm.dDataType = HTTPRequest.GetInt("dDataType", 0);
dtm.dDateType = HTTPRequest.GetInt("dDateType", 0);
dtm.dState = HTTPRequest.GetInt("dState", 0);
dtm.dEmail = Utils.ChkSQL(HTTPRequest.GetString("dEmail"));
if (Act == "Add")
{
dtm.dAppendTime = DateTime.Now;
if (tbDataToMailInfo.AddDataToMailInfo(dtm) > 0)
{
AddMsgLine("创建成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
else
{
AddErrLine("创建失败!");
AddScript("window.setTimeout('history.back(1);',1000);");
}
}
if (Act == "Edit")
{
try
{
tbDataToMailInfo.UpdateDataToMailInfo(dtm);
AddMsgLine("修改成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
catch (Exception ex)
{
AddErrLine("修改失败!<br/>" + ex);
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
}
}
else
{
DataTypes = tbDataToMailInfo.GetDataToMailDataTypes();
if (Act == "Del")
{
try
{
tbDataToMailInfo.DeleteDataToMailInfoList(HTTPRequest.GetString("did"));
AddMsgLine("删除成功!");
AddScript("window.setTimeout('window.parent.HidBox();',1000);");
}
catch (Exception ex)
{
AddErrLine("删除失败!<br/>" + ex);
}
}
}
}
else
{
AddErrLine("权限不足!");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
