// 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; } }