/// <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)); }