/// <summary>
/// 收藏
/// </summary>
public void CollectionClick()
{
var obj = new object();
string DBCode = context.Request["DBCode"];
string DBId = context.Request["DBId"];
string IdName = context.Request["IdName"];
string DBUrl = context.Request["DBUrl"];
string DBTitle = context.Request["DBTitle"];
string UserName = context.Request["UserName"];
string UserType = context.Request["UserType"];
if (UserName == "")
{
//没检测到用户
obj = new
{
CollectCount = "",
statu = -1
};
}
else
{
MsSqlDataSource mysqlD = new MsSqlDataSource();
string SelectStr = string.Format("select id from Z_Collection where UserName='******' and UserType='{1}' and DBCode='{2}' and DBId='{3}' and IsDelete=0", UserName, UserType, DBCode, DBId);
DataTable IsTable = mysqlD.ExecuteDataTable(SelectStr);
if (IsTable.Rows.Count > 0)
{
obj = new
{
CollectCount = "",
statu = 0
};
}
else
{
string insertStr = string.Format("insert into Z_Collection(UserName,UserType,DBCode,DBId,DBUrl,DBTitle,AddTime) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", UserName, UserType, DBCode, DBId, DBUrl, DBTitle, DateTime.Now.ToString("yyyy-MM-dd"));
int statu = mysqlD.ExecuteNonQuery(insertStr);
//获取收藏数量
string select = string.Format("select CollectCount from {0} where {1}='{2}'", DBCode, IdName, DBId);
DataTable CollectTable = mysqlD.ExecuteDataTable(select);
int CollectCount = 0;
if (CollectTable.Rows.Count > 0)
{
CollectCount = Convert.ToInt32(CollectTable.Rows[0]["CollectCount"]) + 1;
}
string updateStr = string.Format("update {0} set CollectCount={3} where {1}='{2}'", DBCode, IdName, DBId, CollectCount);
mysqlD.ExecuteNonQuery(updateStr);
obj = new
{
CollectCount = CollectCount,
statu = statu
};
}
}
string msg = JsonConvert.SerializeObject(obj);
context.Response.Write(msg);
}
private void btnAbstractExample_Click(object sender, RoutedEventArgs e)
{
MsSqlDataSource msDataSource = new MsSqlDataSource("ms sql environment");
OracleDataSource oracleDataSource = new OracleDataSource("oracle sql environment");
msDataSource.OpenAndReturnConnection();
oracleDataSource.OpenAndReturnConnection();
}
public int getCaseGroupByCompanyID(int companyID, int typeID, string typeString)
{
int ret = 0;
MsSqlDataSource sql = new MsSqlDataSource();
string sqlselect = string.Format("select count(*) as cou from WebCase where CompanyID='{0}' and {1}='{2}'", companyID, typeString, typeID);
DataTable table = sql.ExecuteDataTable(sqlselect);
if (table.Rows.Count > 0)
{
ret = Convert.ToInt32(table.Rows[0]["cou"]);
}
return(ret);
}
/// <summary>
/// 点赞
/// </summary>
public void ZanClick()
{
var obj = new object();
string DBCode = context.Request["DBCode"];
string DBId = context.Request["DBId"];
string IdName = context.Request["IdName"];
Security sec = new Security();
string key = sec.GetRequestKey();
MsSqlDataSource mysqlD = new MsSqlDataSource();
string selectStr = string.Format("select id from Zan where RequestKey='{0}' and AddTime='{1}' and DBCode='{2}' and DBId='{3}'", key, DateTime.Now.ToString("yyyy-MM-dd"), DBCode, DBId);
DataTable table = mysqlD.ExecuteDataTable(selectStr);
if (table.Rows.Count > 0)
{
obj = new
{
ZanCount = "",
statu = 0
};
}
else
{
string insertStr = string.Format("insert into Zan(RequestKey,DBCode,DBId,AddTime) values ('{0}','{1}','{2}','{3}')", key, DBCode, DBId, DateTime.Now.ToString("yyyy-MM-dd"));
int statu = mysqlD.ExecuteNonQuery(insertStr);
//获取点赞数量
string select = string.Format("select ZanCount from {0} where {1}='{2}'", DBCode, IdName, DBId);
DataTable ZanTable = mysqlD.ExecuteDataTable(select);
int ZanCount = 0;
if (ZanTable.Rows.Count > 0)
{
ZanCount = Convert.ToInt32(ZanTable.Rows[0]["ZanCount"]) + 1;
}
string updateStr = string.Format("update {0} set ZanCount={3} where {1}='{2}'", DBCode, IdName, DBId, ZanCount);
mysqlD.ExecuteNonQuery(updateStr);
obj = new
{
ZanCount = ZanCount,
statu = statu
};
}
string msg = JsonConvert.SerializeObject(obj);
context.Response.Write(msg);
}
/// <summary>
/// SQL分页查询
/// </summary>
public static List <T> GetPageListBySQL <T>(Pagination paginfo, out int recordcount, out int pageCount) where T : class, new()
{
int recordCount = 0;
StringBuilder sql = new StringBuilder("");
sql.AppendFormat(@"SELECT {0} FROM {1} WHERE {2}", string.IsNullOrEmpty(paginfo.SelectParameters)?"*": paginfo.SelectParameters, paginfo.EntityName, paginfo.SortParameters);
MsSqlDataSource mssql = new MsSqlDataSource();
DataTable dataTable = mssql.ListPager(sql.ToString(), paginfo.PageSize, paginfo.PageIndex, paginfo.SortOrder, out recordCount);
List <T> list = null;
if (dataTable.Rows.Count > 0)
{
list = EntityHelper.MapEntity <T>(dataTable);
}
recordcount = recordCount;
pageCount = Convert.ToInt32(Math.Ceiling((double)recordCount / paginfo.PageSize));
return(list);
}
public ActionResult _CommentCase()
{
string from_uname = Request["from_uname"];
string from_account = Request["from_account"];
string from_uid_type = Request["from_uid_type"];
string topic_id = Request["topic_id"];
string topic_type = Request["topic_type"];
string commentcontent = Request["commentcontent"];
int result = 0;
MsSqlDataSource mysqlD = new MsSqlDataSource();
string thum = "";//获取缩略图
if (!String.IsNullOrEmpty(from_account))
{
thum = otherService.getPhotoUrlthum(from_account, from_uid_type);
}
if (thum == "2")
{
return(Json(new { RetCode = result }, JsonRequestBehavior.AllowGet));
}
//插入评论
string comment_guid = Guid.NewGuid().ToString();
string insertStr = string.Format("insert into Z_Comment(topic_id,topic_type,content,from_uname,from_account,from_uid_type,addtime,comment_guid,thum) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')", topic_id, topic_type, commentcontent, from_uname, from_account, from_uid_type, DateTime.Now.ToString("yyyy-MM-dd"), comment_guid, thum);
result = mysqlD.ExecuteNonQuery(insertStr);
Z_Comment comment = new Z_Comment();
if (result > 0)
{
comment = new Z_Comment
{
from_uname = from_uname,
from_account = from_account,
from_uid_type = from_uid_type,
content = commentcontent,
addtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
thum = thum,
comment_guid = comment_guid
};
}
return(PartialView(comment));
}
