/// <summary>
/// 获取实体
/// </summary>
public Model.manager_guid GetManagerGuidModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from dt_manager_guid ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = id;
Model.manager_guid model = new Model.manager_guid();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
#region DATA
if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["guid_id"] != null && ds.Tables[0].Rows[0]["guid_id"].ToString() != "")
{
model.guid_id = int.Parse(ds.Tables[0].Rows[0]["guid_id"].ToString());
}
if (ds.Tables[0].Rows[0]["manager_id"] != null && ds.Tables[0].Rows[0]["manager_id"].ToString() != "")
{
model.manager_id = int.Parse(ds.Tables[0].Rows[0]["manager_id"].ToString());
}
if (ds.Tables[0].Rows[0]["status"] != null && ds.Tables[0].Rows[0]["status"].ToString() != "")
{
model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString());
}
if (ds.Tables[0].Rows[0]["apply_time"] != null && ds.Tables[0].Rows[0]["apply_time"].ToString() != "")
{
model.apply_time = DateTime.Parse(ds.Tables[0].Rows[0]["apply_time"].ToString());
}
if (ds.Tables[0].Rows[0]["push_state"] != null && ds.Tables[0].Rows[0]["push_state"].ToString() != "")
{
model.push_state = int.Parse(ds.Tables[0].Rows[0]["push_state"].ToString());
}
if (ds.Tables[0].Rows[0]["is_pushed"] != null && ds.Tables[0].Rows[0]["is_pushed"].ToString() != "")
{
model.is_pushed = int.Parse(ds.Tables[0].Rows[0]["is_pushed"].ToString());
}
if (ds.Tables[0].Rows[0]["remark1"] != null && ds.Tables[0].Rows[0]["remark1"].ToString() != "")
{
model.remark1 = ds.Tables[0].Rows[0]["remark1"].ToString();
}
if (ds.Tables[0].Rows[0]["remark2"] != null && ds.Tables[0].Rows[0]["remark2"].ToString() != "")
{
model.remark2 = int.Parse(ds.Tables[0].Rows[0]["remark2"].ToString());
}
#endregion
return model;
}
else
{
return null;
}
}
public void Attention(int userId, int groupTeamId, int status, string version, string equType, string equName)
{
string json = String.Empty;
BLL.manager_guid bll_managerguid = new BLL.manager_guid();
Model.manager_guid model_managerguid = null;
try
{
bool is_exsit = bll_managerguid.Exists(groupTeamId, userId);
if (is_exsit)
{
bool result = false;
if (status == 0)
{
result = bll_managerguid.Delete(groupTeamId, userId);
}
if (result)
{
json = "{\"status\":\"true\"}";
}
else
{
json = "{\"status\":\"false\",\"data\":\"已关注此旅行社！\"}";
}
}
else
{
model_managerguid = new Model.manager_guid();
model_managerguid.guid_id = userId;
model_managerguid.manager_id = groupTeamId;
model_managerguid.status = 1;//关注
model_managerguid.apply_time = DateTime.Now;
int count = bll_managerguid.Add(model_managerguid);
if (count > 0)
{
json = "{\"status\":\"true\"}";
}
else
{
json = "{\"status\":\"false\",\"data\":\"关注失败，请联系管理员！\"}";
}
}
}
catch (Exception ex)
{
json = "{\"status\":\"false\",\"data\":\"" + ex.Message + "\"}";
}
WriteWebServiceLog(version, equType, equName, "Attention", "");
Context.Response.Write(json);
Context.Response.End();
}
