/// <summary>
/// 增加一条数据
/// </summary>
public int Add(CooperationEntity model)
{
try
{
return(CooperationDb.Instance.Add(model));
}
catch (Exception ex)
{
WriteLog.WriteError(ex);
throw ex;
}
}
public object GetCooEntity(int cid)
{
CooperationEntity cooperationEntity = CooperationBll.Instance.GetModel(cid);
if (cooperationEntity == null)
{
return(new Dictionary <string, string>()
{
{ "status", "204" }, { "massage", "无内容" }
});
}
return(new DataTableModels
{
Dt = cooperationEntity,
Status = StatusEnum.success
});
}
private void BindData()
{
//初始化积分列表
DataTable dt = IntegralChangeBll.Instance.GetList(10, $"UserId='{User_id}'", "AddTime DESC").Tables[0];
repIntCha.DataSource = dt;
repIntCha.DataBind();
// 初始化评论
DataTable replyTable = ReplyBll.Instance.GetList(10, $"User_id='{User_id}'", "ReleaseTime DESC");
DataTable commentTable = new DataTable();
commentTable.Columns.Add("workId");
commentTable.Columns.Add("type");
commentTable.Columns.Add("cover");
commentTable.Columns.Add("WorksTitle");
foreach (DataRow dataRow in replyTable.Rows)
{
DataRow dr = commentTable.NewRow();
dr["workId"] = dataRow["workId"];
dr["type"] = dataRow["type"];
if (dataRow["type"].ToString() == "works") //作品
{
WorksEntity worksEntity = WorksBll.Instance.GetModel(int.Parse(dataRow["workId"].ToString()));
dr["cover"] = worksEntity.cover;
dr["WorksTitle"] = worksEntity.WorksTitle;
}
if (dataRow["type"].ToString() == "reprint") //合作
{
CooperationEntity cooperationEntity = CooperationBll.Instance.GetModel(int.Parse(dataRow["workId"].ToString()));
dr["cover"] = cooperationEntity.cover;
dr["WorksTitle"] = cooperationEntity.title;
}
if (dataRow["type"].ToString() == "activity") //活动
{
ActivityEntity activityEntity = ActivityBll.Instance.GetModel(int.Parse(dataRow["workId"].ToString()));
dr["cover"] = activityEntity.cover;
dr["WorksTitle"] = activityEntity.title;
}
}
repComment.DataSource = commentTable;
repComment.DataBind();
//初始化文章
dt = WorksBll.Instance.GetList(10, $"User_id='{User_id}'", "ReleaseTime DESC");
repArticle.DataSource = dt;
repArticle.DataBind();
}
// POST api/Cooperation/SaveCooperation
public object SaveCooperation([FromBody] CooperationEntity cooperationEntity)
{
cooperationEntity.ReleaseTime = DateTime.Now;
cooperationEntity.Status = 1;
if (CooperationBll.Instance.Add(cooperationEntity) > 0)
{
return(new Dictionary <string, string>()
{
{ "status", "200" }
});
}
else
{
return(new Dictionary <string, string>()
{
{ "status", "400" }, { "message", "保存失败" }
});
}
}
private void BindData()
{
DataTable replyTable = ReplyBll.Instance.GetList($"User_id='{userId}'");
DataTable commentTable = new DataTable();
commentTable.Columns.Add("workId");
commentTable.Columns.Add("type");
commentTable.Columns.Add("cover");
commentTable.Columns.Add("WorksTitle");
commentTable.Columns.Add("ReplyContent");
foreach (DataRow dataRow in replyTable.Rows)
{
DataRow dr = commentTable.NewRow();
dr["workId"] = dataRow["workId"];
dr["type"] = dataRow["type"];
dr["ReplyContent"] = dataRow["ReplyContent"];
if (dataRow["type"].ToString() == "works") //作品
{
WorksEntity worksEntity = WorksBll.Instance.GetModel(int.Parse(dataRow["workId"].ToString()));
dr["cover"] = worksEntity.cover;
dr["WorksTitle"] = worksEntity.WorksTitle;
}
if (dataRow["type"].ToString() == "reprint") //合作
{
CooperationEntity cooperationEntity = CooperationBll.Instance.GetModel(int.Parse(dataRow["workId"].ToString()));
dr["cover"] = cooperationEntity.cover;
dr["WorksTitle"] = cooperationEntity.title;
}
if (dataRow["type"].ToString() == "activity") //活动
{
ActivityEntity activityEntity = ActivityBll.Instance.GetModel(int.Parse(dataRow["workId"].ToString()));
dr["cover"] = activityEntity.cover;
dr["WorksTitle"] = activityEntity.title;
}
}
repComment.DataSource = commentTable;
repComment.DataBind();
}
/// <summary>
/// 保存合作
/// </summary>
/// <returns></returns>
private int SaveReprint(string userId, string worksTitle, string worksExcerpt, string worksContent, string cover)
{
CooperationEntity cooperationEntity = new CooperationEntity();
cooperationEntity.User_id = userId;
cooperationEntity.title = worksTitle;
cooperationEntity.type = "";
cooperationEntity.send = "";
cooperationEntity.enrollEnd = null;
cooperationEntity.timeBudget = "";
cooperationEntity.intention = "";
cooperationEntity.acceptSum = "";
cooperationEntity.cooContent = worksContent;
cooperationEntity.RMBBudget = "";
cooperationEntity.GenderAsk = "";
cooperationEntity.signPerson = "";
cooperationEntity.personSum = "";
cooperationEntity.ReleaseTime = DateTime.Now;
cooperationEntity.Status = 1;
cooperationEntity.contacts = "";
cooperationEntity.phone = "";
cooperationEntity.qq = "";
cooperationEntity.cover = cover;
cooperationEntity.limitPerson = 0;
cooperationEntity.will = "";
cooperationEntity.prov = "";
cooperationEntity.city = "";
cooperationEntity.dist = "";
cooperationEntity.excerpt = worksExcerpt;
if (CooperationBll.Instance.Add(cooperationEntity) > 0)
{
return(1);
}
else
{
return(-1);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CooperationEntity GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,User_id,title,type,send,enrollEnd,timeBudget,intention,acceptSum,cooContent,RMBBudget,GenderAsk,signPerson,personSum,ReleaseTime,Status,contacts,phone,qq,cover,limitPerson,will,prov,city,dist,excerpt from sns_cooperation ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
CooperationEntity model = new CooperationEntity();
DataSet ds = SqlHelper.Instance.ExecSqlDataSet(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(CooperationEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sns_cooperation(");
strSql.Append("User_id,title,type,send,enrollEnd,timeBudget,intention,acceptSum,cooContent,RMBBudget,GenderAsk,signPerson,personSum,ReleaseTime,Status,contacts,phone,qq,cover,limitPerson,will,prov,city,dist,excerpt)");
strSql.Append(" values (");
strSql.Append("@User_id,@title,@type,@send,@enrollEnd,@timeBudget,@intention,@acceptSum,@cooContent,@RMBBudget,@GenderAsk,@signPerson,@personSum,@ReleaseTime,@Status,@contacts,@phone,@qq,@cover,@limitPerson,@will,@prov,@city,@dist,@excerpt)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@User_id", SqlDbType.VarChar, 50),
new SqlParameter("@title", SqlDbType.VarChar, 50),
new SqlParameter("@type", SqlDbType.VarChar, 50),
new SqlParameter("@send", SqlDbType.VarChar, 50),
new SqlParameter("@enrollEnd", SqlDbType.DateTime),
new SqlParameter("@timeBudget", SqlDbType.VarChar, 50),
new SqlParameter("@intention", SqlDbType.VarChar, 50),
new SqlParameter("@acceptSum", SqlDbType.VarChar, 50),
new SqlParameter("@cooContent", SqlDbType.Text),
new SqlParameter("@RMBBudget", SqlDbType.VarChar, 50),
new SqlParameter("@GenderAsk", SqlDbType.VarChar, 50),
new SqlParameter("@signPerson", SqlDbType.VarChar, 50),
new SqlParameter("@personSum", SqlDbType.VarChar, 50),
new SqlParameter("@ReleaseTime", SqlDbType.DateTime),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@contacts", SqlDbType.VarChar, 50),
new SqlParameter("@phone", SqlDbType.VarChar, 50),
new SqlParameter("@qq", SqlDbType.VarChar, 50),
new SqlParameter("@cover", SqlDbType.VarChar, 500),
new SqlParameter("@limitPerson", SqlDbType.Int, 4),
new SqlParameter("@will", SqlDbType.VarChar, 50),
new SqlParameter("@prov", SqlDbType.VarChar, 50),
new SqlParameter("@city", SqlDbType.VarChar, 50),
new SqlParameter("@dist", SqlDbType.VarChar, 50),
new SqlParameter("@excerpt", SqlDbType.Text)
};
parameters[0].Value = model.User_id;
parameters[1].Value = model.title;
parameters[2].Value = model.type;
parameters[3].Value = model.send;
parameters[4].Value = model.enrollEnd;
parameters[5].Value = model.timeBudget;
parameters[6].Value = model.intention;
parameters[7].Value = model.acceptSum;
parameters[8].Value = model.cooContent;
parameters[9].Value = model.RMBBudget;
parameters[10].Value = model.GenderAsk;
parameters[11].Value = model.signPerson;
parameters[12].Value = model.personSum;
parameters[13].Value = model.ReleaseTime;
parameters[14].Value = model.Status;
parameters[15].Value = model.contacts;
parameters[16].Value = model.phone;
parameters[17].Value = model.qq;
parameters[18].Value = model.cover;
parameters[19].Value = model.limitPerson;
parameters[20].Value = model.will;
parameters[21].Value = model.prov;
parameters[22].Value = model.city;
parameters[23].Value = model.dist;
parameters[24].Value = model.excerpt;
object obj = SqlHelper.Instance.ExecSqlScalar(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
private CooperationEntity DataRowToModel(DataRow row)
{
CooperationEntity model = new CooperationEntity();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["User_id"] != null)
{
model.User_id = row["User_id"].ToString();
}
if (row["title"] != null)
{
model.title = row["title"].ToString();
}
if (row["type"] != null)
{
model.type = row["type"].ToString();
}
if (row["send"] != null)
{
model.send = row["send"].ToString();
}
if (row["enrollEnd"] != null && row["enrollEnd"].ToString() != "")
{
model.enrollEnd = DateTime.Parse(row["enrollEnd"].ToString());
}
if (row["timeBudget"] != null)
{
model.timeBudget = row["timeBudget"].ToString();
}
if (row["intention"] != null)
{
model.intention = row["intention"].ToString();
}
if (row["acceptSum"] != null)
{
model.acceptSum = row["acceptSum"].ToString();
}
if (row["cooContent"] != null)
{
model.cooContent = row["cooContent"].ToString();
}
if (row["RMBBudget"] != null)
{
model.RMBBudget = row["RMBBudget"].ToString();
}
if (row["GenderAsk"] != null)
{
model.GenderAsk = row["GenderAsk"].ToString();
}
if (row["signPerson"] != null)
{
model.signPerson = row["signPerson"].ToString();
}
if (row["personSum"] != null)
{
model.personSum = row["personSum"].ToString();
}
if (row["ReleaseTime"] != null && row["ReleaseTime"].ToString() != "")
{
model.ReleaseTime = DateTime.Parse(row["ReleaseTime"].ToString());
}
if (row["Status"] != null && row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["contacts"] != null)
{
model.contacts = row["contacts"].ToString();
}
if (row["phone"] != null)
{
model.phone = row["phone"].ToString();
}
if (row["qq"] != null)
{
model.qq = row["qq"].ToString();
}
if (row["cover"] != null)
{
model.cover = row["cover"].ToString();
}
if (row["limitPerson"] != null && row["limitPerson"].ToString() != "")
{
model.limitPerson = int.Parse(row["limitPerson"].ToString());
}
if (row["will"] != null)
{
model.will = row["will"].ToString();
}
if (row["prov"] != null)
{
model.prov = row["prov"].ToString();
}
if (row["city"] != null)
{
model.city = row["city"].ToString();
}
if (row["dist"] != null)
{
model.dist = row["dist"].ToString();
}
if (row["excerpt"] != null)
{
model.excerpt = row["excerpt"].ToString();
}
}
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
worksId = Request.QueryString["nid"]; //文章id
type = Request.QueryString["type"]; //类型，作品（works）、合作（reprint）、活动（activity）
Dictionary <string, string> iDi = new Dictionary <string, string>();
switch (type)
{
case "works":
WorksEntity worksEntity1 = WorksBll.Instance.GetModel(Convert.ToInt32(worksId) - 1);
WorksEntity worksEntity = WorksBll.Instance.GetModel(Convert.ToInt32(worksId));
WorksEntity worksEntity2 = WorksBll.Instance.GetModel(Convert.ToInt32(worksId) + 1);
MemberEntity = MemberBll.Instance.GetModel(Convert.ToInt32(worksEntity.User_id));
iDi.Add("title", worksEntity.WorksTitle);
iDi.Add("type", SysParaBll.Instance.GetModel(Convert.ToInt32(worksEntity.WorksType)).RefText);
iDi.Add("type2", (worksEntity.Type2 == "" ? "" : SysParaBll.Instance.GetModel(Convert.ToInt32(worksEntity.Type2))?.RefText));
iDi.Add("datetime", worksEntity.ReleaseTime.ToString("yyyy-MM-dd HH:mm:ss"));
iDi.Add("time", worksEntity.ReleaseTime.ToString("yyyy年MM月dd日"));
iDi.Add("releaseTime", GetTime(worksEntity.ReleaseTime.ToString()));
iDi.Add("goodNo", worksEntity.GoodNo.ToString());
iDi.Add("reward", worksEntity.reward.ToString());
iDi.Add("nickname", MemberEntity.nickname);
iDi.Add("excerpt", worksEntity.worksExcerpt);
iDi.Add("content", worksEntity.WorksContent);
iDi.Add("labelDesc", worksEntity.LabelDesc);
iDi.Add("id1", worksEntity1?.WorksId.ToString());
iDi.Add("title1", worksEntity1?.WorksTitle);
iDi.Add("cover1", worksEntity1?.cover);
iDi.Add("id2", worksEntity2?.WorksId.ToString());
iDi.Add("title2", worksEntity2?.WorksTitle);
iDi.Add("cover2", worksEntity2?.cover);
break;
case "reprint":
CooperationEntity cooperationEntity1 = CooperationBll.Instance.GetModel(Convert.ToInt32(worksId) - 1);
CooperationEntity cooperationEntity = CooperationBll.Instance.GetModel(Convert.ToInt32(worksId));
CooperationEntity cooperationEntity2 = CooperationBll.Instance.GetModel(Convert.ToInt32(worksId) + 1);
MemberEntity = MemberBll.Instance.GetModel(Convert.ToInt32(cooperationEntity.User_id));
iDi.Add("title", cooperationEntity.title);
iDi.Add("type", cooperationEntity.will);
iDi.Add("type2", (cooperationEntity.will));
iDi.Add("datetime", cooperationEntity.ReleaseTime.ToString("yyyy-MM-dd HH:mm:ss"));
iDi.Add("time", cooperationEntity.ReleaseTime.ToString("yyyy年MM月dd日"));
iDi.Add("releaseTime", GetTime(cooperationEntity.ReleaseTime.ToString()));
iDi.Add("goodNo", "-");
iDi.Add("nickname", MemberEntity.nickname);
iDi.Add("excerpt", cooperationEntity.excerpt);
iDi.Add("content", cooperationEntity.cooContent);
iDi.Add("labelDesc", "");
iDi.Add("id1", cooperationEntity1?.id.ToString());
iDi.Add("title1", cooperationEntity1?.title);
iDi.Add("cover1", cooperationEntity1?.cover);
iDi.Add("id2", cooperationEntity2?.id.ToString());
iDi.Add("title2", cooperationEntity2?.title);
iDi.Add("cover2", cooperationEntity2?.cover);
break;
case "activity":
ActivityEntity activityEntity1 = ActivityBll.Instance.GetModel(Convert.ToInt32(worksId) - 1);
ActivityEntity activityEntity = ActivityBll.Instance.GetModel(Convert.ToInt32(worksId));
ActivityEntity activityEntity2 = ActivityBll.Instance.GetModel(Convert.ToInt32(worksId) + 1);
MemberEntity = MemberBll.Instance.GetModel(Convert.ToInt32(activityEntity.User_id));
iDi.Add("title", activityEntity.title);
iDi.Add("type", "");
iDi.Add("type2", "");
iDi.Add("datetime", activityEntity.ReleaseTime.ToString("yyyy-MM-dd HH:mm:ss"));
iDi.Add("time", activityEntity.ReleaseTime.ToString("yyyy年MM月dd日"));
iDi.Add("releaseTime", GetTime(activityEntity.ReleaseTime.ToString()));
iDi.Add("goodNo", "-");
iDi.Add("nickname", MemberEntity.nickname);
iDi.Add("excerpt", activityEntity.excerpt);
iDi.Add("content", activityEntity.cont);
iDi.Add("labelDesc", "");
iDi.Add("id1", activityEntity1?.id.ToString());
iDi.Add("title1", activityEntity1?.title);
iDi.Add("cover1", activityEntity1?.cover);
iDi.Add("id2", activityEntity2?.id.ToString());
iDi.Add("title2", activityEntity2?.title);
iDi.Add("cover2", activityEntity2?.cover);
break;
default:
break;
}
BindData(iDi);
}
}
