/// <summary> /// 更新一条数据 /// </summary> public bool Update(Tz888.Model.Recomm.recommResourceM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update recommResource set "); strSql.Append("ResourceId=@ResourceId,"); strSql.Append("ResourceTitle=@ResourceTitle,"); strSql.Append("ResourceTypeId=@ResourceTypeId,"); strSql.Append("ResourceUrl=@ResourceUrl,"); strSql.Append("RecommName=@RecommName,"); strSql.Append("RecommToUser=@RecommToUser"); //strSql.Append("RecommDate=@RecommDate"); strSql.Append(" where RecommID=@RecommID"); SqlParameter[] parameters = { new SqlParameter("@RecommID", SqlDbType.Int, 4), new SqlParameter("@ResourceId", SqlDbType.BigInt, 8), new SqlParameter("@ResourceTitle", SqlDbType.VarChar, 200), new SqlParameter("@ResourceTypeId", SqlDbType.Int, 4), new SqlParameter("@ResourceUrl", SqlDbType.VarChar, 100), new SqlParameter("@RecommName", SqlDbType.VarChar, 50), new SqlParameter("@RecommToUser", SqlDbType.VarChar, 50) //new SqlParameter("@RecommDate", SqlDbType.DateTime) }; parameters[0].Value = model.RecommID; parameters[1].Value = model.ResourceId; parameters[2].Value = model.ResourceTitle; parameters[3].Value = model.ResourceTypeId; parameters[4].Value = model.ResourceUrl; parameters[5].Value = model.RecommName; parameters[6].Value = model.RecommToUser; //parameters[7].Value = model.RecommDate; int rows = crm.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Tz888.Model.Recomm.recommResourceM GetModel(int RecommID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 RecommID,ResourceId,ResourceTitle,ResourceTypeId,ResourceUrl,RecommName,RecommToUser,RecommDate from recommResource "); strSql.Append(" where RecommID=@RecommID"); SqlParameter[] parameters = { new SqlParameter("@RecommID", SqlDbType.Int, 4) }; parameters[0].Value = RecommID; Tz888.Model.Recomm.recommResourceM model = new Tz888.Model.Recomm.recommResourceM(); DataSet ds = crm.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["RecommID"].ToString() != "") { model.RecommID = int.Parse(ds.Tables[0].Rows[0]["RecommID"].ToString()); } if (ds.Tables[0].Rows[0]["ResourceId"].ToString() != "") { model.ResourceId = long.Parse(ds.Tables[0].Rows[0]["ResourceId"].ToString()); } model.ResourceTitle = ds.Tables[0].Rows[0]["ResourceTitle"].ToString(); if (ds.Tables[0].Rows[0]["ResourceTypeId"].ToString() != "") { model.ResourceTypeId = int.Parse(ds.Tables[0].Rows[0]["ResourceTypeId"].ToString()); } model.ResourceUrl = ds.Tables[0].Rows[0]["ResourceUrl"].ToString(); model.RecommName = ds.Tables[0].Rows[0]["RecommName"].ToString(); model.RecommToUser = ds.Tables[0].Rows[0]["RecommToUser"].ToString(); if (ds.Tables[0].Rows[0]["RecommDate"].ToString() != "") { model.RecommDate = DateTime.Parse(ds.Tables[0].Rows[0]["RecommDate"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Tz888.Model.Recomm.recommResourceM model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into recommResource("); strSql.Append("ResourceId,ResourceTitle,ResourceTypeId,ResourceUrl,RecommName,RecommToUser,RecommDate)"); strSql.Append(" values ("); strSql.Append("@ResourceId,@ResourceTitle,@ResourceTypeId,@ResourceUrl,@RecommName,@RecommToUser,getdate())"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ResourceId", SqlDbType.BigInt, 8), new SqlParameter("@ResourceTitle", SqlDbType.VarChar, 200), new SqlParameter("@ResourceTypeId", SqlDbType.Int, 4), new SqlParameter("@ResourceUrl", SqlDbType.VarChar, 100), new SqlParameter("@RecommName", SqlDbType.VarChar, 50), new SqlParameter("@RecommToUser", SqlDbType.VarChar, 50) //new SqlParameter("@RecommDate", SqlDbType.DateTime) }; parameters[0].Value = model.ResourceId; parameters[1].Value = model.ResourceTitle; parameters[2].Value = model.ResourceTypeId; parameters[3].Value = model.ResourceUrl; parameters[4].Value = model.RecommName; parameters[5].Value = model.RecommToUser; //parameters[6].Value = model.RecommDate; object obj = crm.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }