//
private SqlParameter[] GetSqlParameter(WebIntention model)
{
SqlParameter[] parameters =
{
new SqlParameter("@FK_WebUserVeriId", SqlDbType.Int, 4),
new SqlParameter("@IntentionType", SqlDbType.Int, 4),
new SqlParameter("@Title", SqlDbType.NVarChar, 150),
new SqlParameter("@Content", SqlDbType.NVarChar, 500),
new SqlParameter("@RegDate", SqlDbType.DateTime),
new SqlParameter("@EndDte", SqlDbType.DateTime),
new SqlParameter("@CheckStatus", SqlDbType.Int, 4),
new SqlParameter("@ClickNum", SqlDbType.Int, 4),
new SqlParameter("@CheckName", SqlDbType.NVarChar, 50),
new SqlParameter("@CheckDate", SqlDbType.DateTime),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.FK_WebUserVeriId;
parameters[1].Value = model.IntentionType;
parameters[2].Value = model.Title;
parameters[3].Value = model.Content;
parameters[4].Value = model.RegDate;
parameters[5].Value = model.EndDte;
parameters[6].Value = model.CheckStatus;
parameters[7].Value = model.ClickNum;
parameters[8].Value = model.CheckName;
parameters[9].Value = model.CheckDate;
parameters[10].Value = model.Id;
return(parameters);
}
public dynamic GetModel(string sqlWhere)
{
try
{
dynamic model = null;
string strSql = " select top 1 Id,FK_WebUserVeriId,IntentionType,Title,Content,RegDate,EndDte,CheckStatus,ClickNum,CheckName,CheckDate from T_WebIntention ";
strSql += string.Format(" where {0}", sqlWhere);
using (dynamic read = DbHelperSQL.ExecuteReader(strSql))
{
if (read.Read())
{
model = new WebIntention();
model.Id = int.Parse(read["Id"].ToString());
model.FK_WebUserVeriId = int.Parse(read["FK_WebUserVeriId"].ToString());
model.IntentionType = int.Parse(read["IntentionType"].ToString());
model.Title = read["Title"].ToString();
model.Content = read["Content"].ToString();
model.RegDate = DateTime.Parse(read["RegDate"].ToString());
model.EndDte = DateTime.Parse(read["EndDte"].ToString());
model.CheckStatus = int.Parse(read["CheckStatus"].ToString());
model.ClickNum = int.Parse(read["ClickNum"].ToString());
model.CheckName = read["CheckName"].ToString();
model.CheckDate = DateTime.Parse(read["CheckDate"].ToString());
}
read.Dispose();
}
return(model);
}
catch { throw; }
}
//
public bool Update(WebIntention model)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_WebIntention set ");
strSql.Append("FK_WebUserVeriId=@FK_WebUserVeriId,");
strSql.Append("IntentionType=@IntentionType,");
strSql.Append("Title=@Title,");
strSql.Append("Content=@Content,");
strSql.Append("RegDate=@RegDate,");
strSql.Append("EndDte=@EndDte,");
strSql.Append("CheckStatus=@CheckStatus,");
strSql.Append("ClickNum=@ClickNum,");
strSql.Append("CheckName=@CheckName,");
strSql.Append("CheckDate=@CheckDate");
strSql.Append(" where Id=@Id");
if (DbHelperSQL.ExecuteSql(strSql.ToString(), GetSqlParameter(model)) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch { throw; }
}
private dynamic GetModel(HttpContext context)
{
WebIntention model = new WebIntention();
model.FK_WebUserVeriId = int.Parse(context.Request.Form["FK_WebUserVeriId"].ToString());
model.IntentionType = int.Parse(context.Request.Form["IntentionType"].ToString());
model.Title = context.Request.Form["Title"].ToString();
model.Content = context.Request.Form["Content"].ToString();
model.RegDate = DateTime.Parse(context.Request.Form["RegDate"].ToString());
model.EndDte = DateTime.Parse(context.Request.Form["EndDte"].ToString());
model.CheckStatus = int.Parse(context.Request.Form["CheckStatus"].ToString());
model.ClickNum = int.Parse(context.Request.Form["ClickNum"].ToString());
model.CheckName = adminUser.AdminName;
model.CheckDate = DateTime.Now;
try { model.Id = int.Parse(context.Request.Form["Id"]); }
catch { }
return(model);
}
//
public bool Create(WebIntention model)
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_WebIntention(");
strSql.Append("FK_WebUserVeriId,IntentionType,Title,Content,RegDate,EndDte,CheckStatus,ClickNum,CheckName,CheckDate)");
strSql.Append(" values (");
strSql.Append("@FK_WebUserVeriId,@IntentionType,@Title,@Content,@RegDate,@EndDte,@CheckStatus,@ClickNum,@CheckName,@CheckDate)");
if (DbHelperSQL.ExecuteSql(strSql.ToString(), GetSqlParameter(model)) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch { throw; }
}
//
public dynamic GetModel(int Id)
{
try
{
dynamic model = null;
StringBuilder strSql = new StringBuilder();
strSql.Append(" select top 1 Id,FK_WebUserVeriId,IntentionType,Title,Content,RegDate,EndDte,CheckStatus,ClickNum,CheckName,CheckDate from T_WebIntention ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
using (dynamic read = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters))
{
if (read.Read())
{
model = new WebIntention();
model.Id = int.Parse(read["Id"].ToString());
model.FK_WebUserVeriId = int.Parse(read["FK_WebUserVeriId"].ToString());
model.IntentionType = int.Parse(read["IntentionType"].ToString());
model.Title = read["Title"].ToString();
model.Content = read["Content"].ToString();
model.RegDate = DateTime.Parse(read["RegDate"].ToString());
model.EndDte = DateTime.Parse(read["EndDte"].ToString());
model.CheckStatus = int.Parse(read["CheckStatus"].ToString());
model.ClickNum = int.Parse(read["ClickNum"].ToString());
model.CheckName = read["CheckName"].ToString();
model.CheckDate = DateTime.Parse(read["CheckDate"].ToString());
}
read.Dispose();
}
return(model);
}
catch { throw; }
}
