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>
/// 根据会员ＩＤ＼姓名判断新会员是否存在
/// </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)));
}
