int ID_CommonModel.GetListCount(int NodeID, string flag) { string strSql = "select Count(GeneralID) from ZL_CommonModel"; string filter = ""; if (!string.IsNullOrEmpty(flag)) { if (flag == "Audit") { filter = "Status=99"; } else { if (flag == "Elite") { filter = "EliteLevel>0"; } else { filter = "Status<>99 and Status<>-2"; } } } else { filter = "Status<>-2"; } if (NodeID > 0) { filter = filter + " and NodeID=" + NodeID; } strSql += " Where " + filter; return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, null))); }
int ID_Node.AddNode(M_Node NodeInfo) { string strSql = "PR_Nodes_Add"; SqlParameter[] cmdParams = GetParameters(NodeInfo); return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.StoredProcedure, strSql, cmdParams))); }
/// <summary> /// 根据会员ID\姓名判断新会员是否存在 /// </summary> /// <param name="userID"></param> /// <returns></returns> public bool IsExit(int userID) { string strSql = "SELECT count(UserID) FROM ZL_User WHERE UserID=@UserID"; SqlParameter[] cmdParams = new SqlParameter[] { new SqlParameter("@UserID", SqlDbType.Int) }; cmdParams[0].Value = userID; return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, cmdParams)) > 0); }
/// <summary> /// 依据信息ID\信息标题判断当前信息是否存在 /// </summary> /// <returns>返回TRUE/FALUSE</returns> public bool IsExit(int msgID) { string sqlStr = "SELECT count(*) FROM ZL_Message WHERE MsgID=@MsgID"; SqlParameter[] cmdParams = new SqlParameter[] { new SqlParameter("@MsgID", SqlDbType.Int, 4) }; cmdParams[0].Value = msgID; return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sqlStr, cmdParams)) > 0); }
public bool IsExit(string title) { string sqlStr = "SELECT count(*) FROM ZL_Message WHERE Title=@Title"; SqlParameter[] cmdParams = new SqlParameter[] { new SqlParameter("@Title", SqlDbType.Int) }; cmdParams[0].Value = title; return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sqlStr, cmdParams)) > 0); }
public int UserMessCount(string UserName) { string sqlStr = "select Count(MsgID) from ZL_Message Where Incept=@Incept and status=0"; SqlParameter[] cmdParams = new SqlParameter[] { new SqlParameter("@Incept", SqlDbType.NVarChar) }; cmdParams[0].Value = UserName; return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sqlStr, cmdParams))); }
public bool IsExit(string userName) { string strSql = "SELECT COUNT(UserID) FROM ZL_User WHERE UserName=@UserName"; SqlParameter[] cmdParams = new SqlParameter[] { new SqlParameter("@UserName", SqlDbType.NVarChar, 20) }; cmdParams[0].Value = userName; return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, cmdParams)) > 0); }
public int CountProjectNumByRid(int rid) { string sqlStr = "select Count(*) from ZL_Project where RequireID=@RequireID"; SqlParameter[] parameter = new SqlParameter[1]; parameter[0] = new SqlParameter("@RequireID", SqlDbType.Int, 4); parameter[0].Value = rid; return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sqlStr, parameter))); }
/// <summary> /// 添加内容到数据库 /// </summary> /// <param name="FieldList"></param> /// <param name="FieldValue"></param> /// <param name="CommonData"></param> int ID_CommonModel.AddContent(string FieldList, string FieldValue, M_CommonData CommonData) { string strSql = "Insert Into " + CommonData.TableName + " (" + FieldList + ") values(" + FieldValue + ");select @@IDENTITY AS newID"; //SqlHelper.ExecuteSql(strSql); int ItemID = SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, null)); string strSql2 = "Insert Into ZL_CommonModel (NodeID,ModelID,ItemID,TableName,Title,Inputer,EliteLevel,InfoID,SpecialID,Template,Status) Values (" + CommonData.NodeID + "," + CommonData.ModelID + "," + ItemID + ",'" + CommonData.TableName + "','" + CommonData.Title + "','" + CommonData.Inputer + "'," + CommonData.EliteLevel + ",'" + CommonData.InfoID + "','" + CommonData.SpecialID + "','" + CommonData.Template + "'," + CommonData.Status + ")"; SqlHelper.ExecuteSql(strSql2); return(ItemID); }
public static int IsExistInt(string strTableName, string strWhere) { string strSql = "select count(*) from " + strTableName; if (!string.IsNullOrEmpty(strWhere)) { strSql += " WHERE " + strWhere; } return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, null))); }
public static bool IsExist(string strTableName, string strWhere, SqlParameter[] sp) { string strSql = "select count(*) from " + strTableName; if (!string.IsNullOrEmpty(strWhere)) { strSql += " WHERE " + strWhere; } return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, sp)) > 0); }
public int GetMaxWorkID(int projectid) { string strSql = "select top 1 WorkID from ZL_ProjectWork where ProjectID=@PID order by WorkID desc"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@PID", SqlDbType.Int) }; sp[0].Value = projectid; return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, sp))); }
bool ID_Label.IsExist(string LabelName) { string strSql = "select count(LabelID) from ZL_Label where LabelName=@LabelName"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@LabelName", SqlDbType.NVarChar) }; sp[0].Value = LabelName; return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, sp)) > 0); }
/// <summary> /// 按条件更新 /// </summary> /// <param name="strTableName">表名</param> /// <param name="strSet">赋值</param> /// <param name="strWhere">查询条件</param> public static int UpLabel(string strTableName, string strSet, string strWhere, SqlParameter[] sp) { string strSql = "UPDATE " + strTableName + " SET " + strSet; if (!string.IsNullOrEmpty(strWhere)) { strSql += " WHERE " + strWhere; } return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, sp))); }
public int CountFinishWork(int projectid) { string strSql = "select count(*) from ZL_ProjectWork where ProjectID=@PID and status=1"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@PID", SqlDbType.Int) }; sp[0].Value = projectid; return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, sp))); }
public int CountDisByWid(int Wid, int Pid) { string strsql = "select Count(*) from ZL_ProjectDiscuss where WorkID=@wid and ProjectID=@pid"; SqlParameter[] cmdParams = new SqlParameter[2]; cmdParams[0] = new SqlParameter("@wid", SqlDbType.Int, 4); cmdParams[0].Value = Wid; cmdParams[1] = new SqlParameter("@pid", SqlDbType.Int, 4); cmdParams[1].Value = Pid; return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strsql, cmdParams))); }
int ID_CommonModel.GetNextID(int InfoID, int NodeID) { string strSql = "select top 1 GeneralID from ZL_CommonModel where NodeID=@NodeID and GeneralID>@InfoID order by GeneralID Asc"; SqlParameter[] cmdParam = new SqlParameter[] { new SqlParameter("@NodeID", SqlDbType.Int, 4), new SqlParameter("@InfoID", SqlDbType.Int, 4) }; cmdParam[0].Value = NodeID; cmdParam[1].Value = InfoID; return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, cmdParam))); }
bool ID_Node.IsExistTemplate(int NodeID, int ModelID) { string strSql = "select count(*) from ZL_Node_ModelTemplate where NodeID=@NodeID and ModelID=@ModelID"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@NodeID", SqlDbType.Int), new SqlParameter("@ModelID", SqlDbType.Int) }; sp[0].Value = NodeID; sp[1].Value = ModelID; return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, sp)) > 0); }
bool ID_Group.IsExistModel(int GroupID, int ModelID) { string strSql = "select count(*) from ZL_GroupModel where GroupID=@GroupID and UserModel=@ModelID"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@GroupID", SqlDbType.Int), new SqlParameter("@ModelID", SqlDbType.Int) }; sp[0].Value = GroupID; sp[1].Value = ModelID; return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, sp)) > 0); }
/// <summary> /// 获取某内容指定标题的评论的支持方或反对方总数 /// </summary> /// <param name="generalID"></param> /// <param name="Title"></param> /// <returns></returns> int ID_Comment.GetComment_CountIDTitlePK(int generalID, string Title, bool PK) { string sqlStr = "select count(*) from ZL_Comment where GeneralID = " + generalID.ToString() + " and Title='" + Title + "'"; if (PK) { sqlStr = sqlStr + " and PK=1";//支持方 } else { sqlStr = sqlStr + " and PK=0";//反对方 } return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sqlStr, null))); }
int ID_Label.GetLabelListCount(string LabelCate) { string strSql = ""; if (string.IsNullOrEmpty(LabelCate)) { strSql = "select Count(LabelID) from ZL_Label"; } else { strSql = "select Count(LabelID) from ZL_Label Where LabelCate='" + LabelCate + "'"; } return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, null))); }
/// <summary> /// 自定义删除操作 /// </summary> public static int DelLabel(string strTableName, string strWhere, SqlParameter[] sp) { string strSql = "DELETE FROM " + strTableName + " WHERE " + strWhere; return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, sp))); }
/// <summary> /// 搜索符合条件数据总数 /// </summary> /// <param name="filter"></param> /// <returns></returns> int ID_CommonModel.CountSearch(string filter) { string strSql = "select count(GeneralID) from ZL_CommonModel where " + filter; return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, null))); }
public int Max() { string strsql = "SELECT TOP 1 ServerID FROM [ZL_DownServer] ORDER BY ServerID DESC"; return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strsql, null))); }
/// <summary> /// 统计某个版位的广告数 /// </summary> /// <param name="strZoneId"></param> /// <returns></returns> int ID_Adzone.ADZone_Count(int ZoneId) { string str = "select count(*) from ZL_Zone_Advertisement where ZoneID=" + ZoneId.ToString(); return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, str, null))); }