/// <summary> /// 修改一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateAdvisitInfo(AdvisitInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AdvisitInfo set "); strSql.Append("advertiserID=@advertiserID,"); strSql.Append("LoginID=@LoginID,"); strSql.Append("VDate=@VDate"); strSql.Append(" where visitID=@visitID "); SqlParameter[] parameters = { new SqlParameter("@visitID", SqlDbType.Int, 4), new SqlParameter("@advertiserID", SqlDbType.Int, 4), new SqlParameter("@LoginID", SqlDbType.VarChar, 100), new SqlParameter("@VDate", SqlDbType.DateTime) }; parameters[0].Value = model.visitID; parameters[1].Value = model.advertiserID; parameters[2].Value = model.LoginID; parameters[3].Value = model.VDate; int num = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); return(num); }
/// <summary> /// 根据ID查询 /// </summary> /// <param name="Id"></param> /// <returns></returns> public AdvisitInfo GetAllAdvisitInfoById(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 visitID,advertiserID,LoginID,VDate from AdvisitInfo "); strSql.Append(" where visitID=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; AdvisitInfo model = new AdvisitInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["visitID"].ToString() != "") { model.visitID = int.Parse(ds.Tables[0].Rows[0]["visitID"].ToString()); } if (ds.Tables[0].Rows[0]["advertiserID"].ToString() != "") { model.advertiserID = int.Parse(ds.Tables[0].Rows[0]["advertiserID"].ToString()); } model.LoginID = ds.Tables[0].Rows[0]["LoginID"].ToString(); if (ds.Tables[0].Rows[0]["VDate"].ToString() != "") { model.VDate = DateTime.Parse(ds.Tables[0].Rows[0]["VDate"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 修改一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateAdvisitInfo(AdvisitInfo model) { return(dal.UpdateAdvisitInfo(model)); }