/// <summary>
/// 更新发布数据
/// </summary>
/// <param name="AC_Id"></param>
/// <returns></returns>
public Message UpadteAdUserStatusGroup(View_AdUser model, string userIDArray)
{
Message jsonMessage;
bool resultB = false;
string reStr = "";
StringBuilder strSql = new StringBuilder();
strSql.Append("update ADUser set ");
strSql.Append(" AP_ID=" + model.AP_ID);
strSql.Append(" ,PublishDate='" + model.PublishDate);
strSql.Append(" ',AC_ID=" + model.AC_ID);
strSql.Append(" where UserID in(" + userIDArray + ")");
resultB = SQLHelper.ExecuteNonQuery(conString, CommandType.Text, strSql.ToString()) > 0;
if (!resultB)
{
reStr = "用户发布失败！";
}
else
{
reStr = "用户发布成功！";
}
jsonMessage = new Message()
{
Result = resultB,
TxtMessage = reStr
};
return(jsonMessage);
}
/// <summary>
/// 更新发布数据
/// </summary>
/// <param name="AC_Id"></param>
/// <returns></returns>
public Message UpadteAdUserStatus(View_AdUser model)
{
Message jsonMessage;
bool resultB = false;
string reStr = "";
StringBuilder strSql = new StringBuilder();
strSql.Append("update ADUser set ");
strSql.Append(" AP_ID=@AP_ID,");
strSql.Append(" PublishDate=@PublishDate,");
strSql.Append(" AC_ID=@AC_ID ");
strSql.Append(" where UserID=@UserID and CompanyID=@CompanyID ");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Char, 10),
new SqlParameter("@CompanyID", SqlDbType.Char, 4),
new SqlParameter("@AP_ID", SqlDbType.BigInt, 8),
new SqlParameter("@PublishDate", SqlDbType.DateTime),
new SqlParameter("@AC_ID", SqlDbType.BigInt, 8),
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.CompanyID;
parameters[2].Value = model.AP_ID;
parameters[3].Value = model.PublishDate;
parameters[4].Value = model.AC_ID;
resultB = SQLHelper.ExecuteNonQuery(conString, CommandType.Text, strSql.ToString(), parameters) > 0;
if (!resultB)
{
reStr = "用户发布失败！";
}
else
{
reStr = "用户发布成功！";
}
jsonMessage = new Message()
{
Result = resultB,
TxtMessage = reStr
};
return(jsonMessage);
}