/// <summary> /// 更新Guide类信息 /// </summary> /// <param name="guide">一级指标管理类参数</param> /// <returns>更新成功返回true 否则返回false</returns> public bool UpdateGuide(Guide guide) { string strSQL = ""; SqlDataAdapter sa = null; SqlCommandBuilder builder = null; DataRow row = null; DataTable dt = null; bool returnValue = false; if (guide != null) { if (guide.GuideID == 0) { strSQL = "SELECT Top 0 * FROM Sys_Guide"; } else { strSQL = "SELECT Top 1 * FROM Sys_Guide WHERE GuideID = " + guide.GuideID.ToString(); } dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { row = dt.Rows[0]; } else { row = dt.NewRow(); } row["GuideCode"] = guide.GuideCode; row["GuideName"] = guide.GuideName; row["Scale"] = guide.Scale; row["Scale1"] = guide.Scale1; row["Scale2"] = guide.Scale2; row["Scale3"] = guide.Scale3; if (dt.Rows.Count == 0) { dt.Rows.Add(row); } SqlConnection conn = CMMgr.GetConnection(); using (sa = new SqlDataAdapter("SELECT Top 0 * FROM Sys_Guide", conn)) { try { builder = new SqlCommandBuilder(sa); sa.Update(dt); returnValue = true; } finally { conn.Close(); conn.Dispose(); } } } return(returnValue); }
/// <summary> /// 获取一条Asses类信息 /// </summary> /// <param name="AssesID">登录编号</param> /// <returns>一条Asses类记录</returns> public Asses GetAsses(string AssesID) { Asses asses = new Asses(); GuideMgr gMgr = new GuideMgr(); Guide2Mgr g2Mgr = new Guide2Mgr(); PersonMgr pMgr = new PersonMgr(); string strSQL = "SELECT Top 1 * FROM Sys_Asses WHERE AssesID = " + AssesID; DataTable dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; asses.AssesID = int.Parse(row["AssesID"].ToString()); asses.Person = pMgr.GetPerson(row["PersonID"].ToString()); asses.Guide = gMgr.GetGuide(row["GuideID"].ToString()); asses.Guide2 = g2Mgr.GetGuide2(row["Guide2ID"].ToString()); asses.Scale1 = int.Parse(row["Scale1"].ToString()); asses.Scale2 = int.Parse(row["Scale2"].ToString()); asses.Scale3 = int.Parse(row["Scale3"].ToString()); asses.Scale1Name = row["Scale1Name"].ToString(); asses.Scale2Name = row["Scale2Name"].ToString(); asses.Scale3Name = row["Scale3Name"].ToString(); asses.CountNumber = int.Parse(row["CountNumber"].ToString()); asses.Memo = row["Memo"].ToString(); return(asses); } else { return(asses); } }
/// <summary> /// 获取一条Rewrite类信息 /// </summary> /// <param name="RewriteID">登录编号</param> /// <returns>一条Rewrite类记录</returns> public Rewrite GetRewrite(string RewriteID) { Rewrite rewrite = new Rewrite(); ClientMgr g2Mgr = new ClientMgr(); PersonMgr pMgr = new PersonMgr(); string strSQL = "SELECT Top 1 * FROM Sys_Rewrite WHERE RewriteID = " + RewriteID; DataTable dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; rewrite.RewriteID = int.Parse(row["RewriteID"].ToString()); rewrite.Title = row["Title"].ToString(); rewrite.Content = row["Content"].ToString(); rewrite.InputDate = DateTime.Parse(row["InputDate"].ToString()); rewrite.Person = pMgr.GetPerson(row["PersonID"].ToString()); rewrite.Client = g2Mgr.GetClient(row["ClientID"].ToString()); rewrite.ReContent = row["ReContent"].ToString(); return(rewrite); } else { return(rewrite); } }
/// <summary> /// 获取一条Client类信息 /// </summary> /// <param name="ClientID">登录编号</param> /// <returns>一条Client类记录</returns> public Client GetClient(string ClientID) { Client client = new Client(); string strSQL = "SELECT Top 1 * FROM Sys_Client WHERE ClientID = '" + ClientID + "'"; ClassInfoMgr cMgr = new ClassInfoMgr(); SpecMgr sMgr = new SpecMgr(); DataTable dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; client.ClientID = row["ClientID"].ToString(); client.ClientName = row["ClientName"].ToString(); client.Password = row["Password"].ToString(); client.Sex = row["Sex"].ToString(); client.ClassInfo = cMgr.GetClassInfo(row["ClassInfoID"].ToString()); client.Spec = sMgr.GetSpec(row["SpecID"].ToString()); client.Tel = row["Tel"].ToString(); client.Mail = row["Mail"].ToString(); client.QQ = row["QQ"].ToString(); return(client); } else { return(client); } }
/// <summary> /// 函数 GetAddNumberList | 获取留言信息列表 /// </summary> /// <returns>留言列表</returns> public DataTable GetAddNumberList(string PersonID, string ClientID, string GuideID, string Guide2ID) { string strSQL = @"SELECT * ,(SELECT PersonName FROM Sys_Person WHERE PersonID = Sys_AddNumber.PersonID) AS PersonName ,(SELECT ClientName FROM Sys_Client WHERE ClientID = Sys_AddNumber.ClientID) AS ClientName ,(SELECT Guide2Name FROM Sys_Guide2 WHERE Guide2ID = Sys_AddNumber.Guide2ID) AS Guide2Name ,(SELECT GuideName FROM Sys_Guide WHERE GuideID = Sys_AddNumber.GuideID) AS GuideName FROM Sys_AddNumber WHERE 1=1 "; if (PersonID != "") { strSQL += "AND PersonID = '" + PersonID + "' "; } if (ClientID != "") { strSQL += "AND ClientID = '" + ClientID + "' "; } if (GuideID != "") { strSQL += "AND GuideID = '" + GuideID + "' "; } if (Guide2ID != "") { strSQL += "AND Guide2ID = '" + Guide2ID + "' "; } strSQL += "Order By AddNumberID Desc"; return(CMMgr.GetDataTable(strSQL)); }
/// <summary> /// 获取一条AddNumber类信息 /// </summary> /// <param name="AddNumberID">登录编号</param> /// <returns>一条AddNumber类记录</returns> public AddNumber GetAddNumber(string AddNumberID) { AddNumber addNumber = new AddNumber(); Guide2Mgr g2Mgr = new Guide2Mgr(); GuideMgr gMgr = new GuideMgr(); PersonMgr pMgr = new PersonMgr(); ClientMgr cMgr = new ClientMgr(); string strSQL = "SELECT Top 1 * FROM Sys_AddNumber WHERE AddNumberID = " + AddNumberID; DataTable dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; addNumber.AddNumberID = int.Parse(row["AddNumberID"].ToString()); addNumber.Title = row["Title"].ToString(); addNumber.Content = row["Content"].ToString(); addNumber.IsAudi = row["IsAudi"].ToString(); addNumber.Person = pMgr.GetPerson(row["PersonID"].ToString()); addNumber.Client = cMgr.GetClient(row["ClientID"].ToString()); addNumber.Guide2 = g2Mgr.GetGuide2(row["Guide2ID"].ToString()); addNumber.Guide = gMgr.GetGuide(row["GuideID"].ToString()); addNumber.AddInt = int.Parse(row["AddInt"].ToString()); return(addNumber); } else { return(addNumber); } }
/// <summary> /// 返回某一数据库中的编号 /// </summary> /// <param name="sysid">主键编号</param> /// <returns></returns> static public int GetNextIDValue(string sysid) { int intPrimary = (int)CMMgr.GetDataTable("SELECT " + sysid + " FROM Sys_FieldID").Rows[0][sysid]; ExecuteNonQuery("UPDATE Sys_FieldID SET " + sysid + "=" + sysid + "+1"); return(intPrimary); }
/// <summary> /// 获取一条Person类信息 /// </summary> /// <param name="PersonID">登录编号</param> /// <returns>一条Person类记录</returns> public Person GetPerson(string PersonID) { Person person = new Person(); string strSQL = "SELECT Top 1 * FROM Sys_Person WHERE PersonID = '" + PersonID + "'"; DataTable dt = CMMgr.GetDataTable(strSQL); ClassInfoMgr cMgr = new ClassInfoMgr(); SpecMgr sMgr = new SpecMgr(); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; person.PersonID = row["PersonID"].ToString(); person.PersonName = row["PersonName"].ToString(); person.Password = row["Password"].ToString(); person.Sex = row["Sex"].ToString(); person.Birthday = row["Birthday"].ToString(); person.ClassInfo = cMgr.GetClassInfo(row["ClassInfoID"].ToString()); person.Spec = sMgr.GetSpec(row["SpecID"].ToString()); return(person); } else { return(person); } }
/// <summary> /// 函数 GetPersonList | 获取学生信息列表 /// </summary> /// <param name="PersonID">登录名称</param> /// <param name="PersonName">真实名称</param> /// <returns>学生列表</returns> public DataTable GetPersonList(string PersonID, string PersonName) { string strSQL = "SELECT *,(SELECT SpecName FROM Sys_Spec WHERE SpecID = Sys_Person.SpecID) AS SpecName,(SELECT ClassInfoName FROM Sys_ClassInfo WHERE ClassInfoID = Sys_Person.ClassInfoID) AS ClassInfoName FROM Sys_Person WHERE " + "PersonName Like '%" + PersonName + "%' " + "AND PersonID Like '%" + PersonID + "%' "; return(CMMgr.GetDataTable(strSQL)); }
protected void dgList_ItemCommand(object source, DataGridCommandEventArgs e) { switch (e.CommandName) { case "btnDel": CMMgr.ExecuteNonQuery("DELETE FROM Sys_Asses WHERE AssesID = " + e.CommandArgument.ToString()); this.initForm(); break; } }
/// <summary> /// 更新Spec类信息 /// </summary> /// <param name="spec">专业管理类参数</param> /// <returns>更新成功返回true 否则返回false</returns> public bool UpdateSpec(Spec spec) { string strSQL = ""; SqlDataAdapter sa = null; SqlCommandBuilder builder = null; DataRow row = null; DataTable dt = null; bool returnValue = false; if (spec != null) { if (spec.SpecID == 0) { strSQL = "SELECT Top 0 * FROM Sys_Spec"; } else { strSQL = "SELECT Top 1 * FROM Sys_Spec WHERE SpecID = " + spec.SpecID.ToString(); } dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { row = dt.Rows[0]; } else { row = dt.NewRow(); } row["SpecName"] = spec.SpecName; if (dt.Rows.Count == 0) { dt.Rows.Add(row); } SqlConnection conn = CMMgr.GetConnection(); using (sa = new SqlDataAdapter("SELECT Top 0 * FROM Sys_Spec", conn)) { try { builder = new SqlCommandBuilder(sa); sa.Update(dt); returnValue = true; } finally { conn.Close(); conn.Dispose(); } } } return(returnValue); }
/// <summary> /// 函数 GetClientList | 获取教师信息列表 /// </summary> /// <param name="ClientID">登录名称</param> /// <param name="ClientName">真实名称</param> /// <returns>登录名称列表</returns> public DataTable GetClientList(string ClientID, string ClientName) { string strSQL = "SELECT *,(SELECT SpecName FROM Sys_Spec WHERE SpecID = Sys_Client.SpecID) AS SpecName,(SELECT ClassInfoName FROM Sys_ClassInfo WHERE ClassInfoID = Sys_Client.ClassInfoID) AS ClassInfoName FROM Sys_Client WHERE " + "ClientID Like '%' + @ClientID + '%' " + "AND ClientName Like '%' + @ClientName + '%' "; SqlParameter[] Parms = new SqlParameter[2]; Parms[0] = new SqlParameter("ClientID", SqlDbType.NVarChar); Parms[0].Value = ClientID; Parms[1] = new SqlParameter("ClientName", SqlDbType.NVarChar); Parms[1].Value = ClientName; return(CMMgr.GetDataTable(strSQL, Parms)); }
/// <summary> /// 函数 GetAdminList | 获取管理员信息列表 /// </summary> /// <param name="AdminID">登录名称</param> /// <param name="AdminName">真实名称</param> /// <returns>登录名称列表</returns> public DataTable GetAdminList(string AdminID, string AdminName) { string strSQL = "SELECT * FROM Sys_Admin WHERE " + "AdminID Like '%' + @AdminID + '%' " + "AND AdminName Like '%' + @AdminName + '%' "; SqlParameter[] Parms = new SqlParameter[2]; Parms[0] = new SqlParameter("AdminID", SqlDbType.NVarChar); Parms[0].Value = AdminID; Parms[1] = new SqlParameter("AdminName", SqlDbType.NVarChar); Parms[1].Value = AdminName; return(CMMgr.GetDataTable(strSQL, Parms)); }
/// <summary> /// 函数 GetPersonList | 获取学生信息列表 /// </summary> /// <param name="PersonID">登录名称</param> /// <param name="PersonName">真实名称</param> /// <returns>学生列表</returns> public DataTable GetPersonList(string PersonID, string PersonName, int SpecID, int ClassInfoID) { string strSQL = "SELECT *,(SELECT SpecName FROM Sys_Spec WHERE SpecID = Sys_Person.SpecID) AS SpecName,(SELECT ClassInfoName FROM Sys_ClassInfo WHERE ClassInfoID = Sys_Person.ClassInfoID) AS ClassInfoName FROM Sys_Person WHERE " + "PersonName Like '%" + PersonName + "%' " + "AND PersonID Like '%" + PersonID + "%' "; if (SpecID != -1) { strSQL += "AND SpecID = " + SpecID.ToString() + " "; } if (ClassInfoID != -1) { strSQL += "AND ClassInfoID = " + ClassInfoID.ToString() + " "; } return(CMMgr.GetDataTable(strSQL)); }
/// <summary> /// 初始化连接数据库变量 /// </summary> public CMMgr(string CommandText, string LinkString) { try { if (LinkString == "") { m_Conn = new SqlConnection(CMMgr.GetConnectionString()); } else { m_Conn = new SqlConnection(LinkString); } m_Conn.Open(); m_Cmd = m_Conn.CreateCommand(); m_Cmd.CommandText = CommandText; m_daTer = new SqlDataAdapter(m_Cmd); } catch { } }
/// <summary> /// 获取一条Spec类信息 /// </summary> /// <param name="SpecID">登录编号</param> /// <returns>一条Spec类记录</returns> public Spec GetSpec(string SpecID) { Spec spec = new Spec(); string strSQL = "SELECT Top 1 * FROM Sys_Spec WHERE SpecID = " + SpecID; DataTable dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; spec.SpecID = int.Parse(row["SpecID"].ToString()); spec.SpecName = row["SpecName"].ToString(); return(spec); } else { return(spec); } }
/// <summary> /// 获取一条ClassInfo类信息 /// </summary> /// <param name="ClassInfoID">登录编号</param> /// <returns>一条ClassInfo类记录</returns> public ClassInfo GetClassInfo(string ClassInfoID) { ClassInfo classInfo = new ClassInfo(); string strSQL = "SELECT Top 1 * FROM Sys_ClassInfo WHERE ClassInfoID = " + ClassInfoID; DataTable dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; classInfo.ClassInfoID = int.Parse(row["ClassInfoID"].ToString()); classInfo.ClassInfoName = row["ClassInfoName"].ToString(); return(classInfo); } else { return(classInfo); } }
/// <summary> /// 函数ExistsPerson | 判断一个学生登录帐号是否存在 /// </summary> /// <param name="PersonID">学生帐号</param> /// <returns>存在返回true不存在返回false</returns> public bool ExistsPerson(string PersonID) { ArrayList arList = new ArrayList(); SqlParameter Param = null; string strSQL = "SELECT Top 1 PersonID FROM Sys_Person WHERE PersonID = @PersonID"; Param = new SqlParameter("PersonID", SqlDbType.NVarChar); Param.Value = PersonID; arList.Add(Param); if (CMMgr.GetDataTable(strSQL, arList).Rows.Count == 0) { return(false); } else { return(true); } }
/// <summary> /// 获取一条Guide2类信息 /// </summary> /// <param name="Guide2ID">登录编号</param> /// <returns>一条Guide2类记录</returns> public Guide2 GetGuide2(string Guide2ID) { Guide2 guide2 = new Guide2(); GuideMgr gMgr = new GuideMgr(); string strSQL = "SELECT Top 1 * FROM Sys_Guide2 WHERE Guide2ID = " + Guide2ID; DataTable dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; guide2.Guide2ID = int.Parse(row["Guide2ID"].ToString()); guide2.Guide2Name = row["Guide2Name"].ToString(); guide2.Guide = gMgr.GetGuide(row["GuideID"].ToString()); return(guide2); } else { return(guide2); } }
/// <summary> /// 函数 GetAssesList | 获取评定指标信息列表 /// </summary> /// <returns>评定指标列表</returns> public DataTable GetAssesNumberList(string PersonID, int GuideID) { string strSQL = @"SELECT * ,(SELECT GuideName FROM Sys_Guide WHERE GuideID = Sys_Asses.GuideID) AS GuideName ,(SELECT Guide2Name FROM Sys_Guide2 WHERE Guide2ID = Sys_Asses.Guide2ID) AS Guide2Name ,(SELECT PersonName FROM Sys_Person WHERE PersonID = Sys_Asses.PersonID) AS PersonName ,(SELECT Sex FROM Sys_Person WHERE PersonID = Sys_Asses.PersonID) AS Sex ,(SELECT Top 1 ClassInfoName FROM Sys_ClassInfo WHERE ClassInfoID IN (SELECT ClassInfoID FROM Sys_Asses WHERE PersonID = Sys_Asses.PersonID)) AS ClassInfoName ,(SELECT Top 1 SpecName FROM Sys_Spec WHERE SpecID IN (SELECT SpecID FROM Sys_Asses WHERE PersonID = Sys_Asses.PersonID)) AS SpecName FROM Sys_Asses WHERE PersonID = '" + PersonID + "' "; if (GuideID != -1) { strSQL += "AND GuideID = " + GuideID.ToString() + " "; } return(CMMgr.GetDataTable(strSQL)); }
/// <summary> /// 获取一条Admin类信息 /// </summary> /// <param name="AdminID">登录编号</param> /// <returns>一条Admin类记录</returns> public Admin GetAdmin(string AdminID) { Admin admin = new Admin(); string strSQL = "SELECT Top 1 * FROM Sys_Admin WHERE AdminID = '" + AdminID + "'"; DataTable dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; admin.AdminID = row["AdminID"].ToString(); admin.AdminName = row["AdminName"].ToString(); admin.Tel = row["Tel"].ToString(); admin.Mail = row["Mail"].ToString(); admin.QQ = row["QQ"].ToString(); admin.Password = row["Password"].ToString(); return(admin); } else { return(admin); } }
/// <summary> /// 函数 GetRewriteList | 获取留言信息列表 /// </summary> /// <returns>留言列表</returns> public DataTable GetRewriteList(string PersonID, string ClientID) { string strSQL = @"SELECT * ,(SELECT PersonName FROM Sys_Person WHERE PersonID = Sys_Rewrite.PersonID) AS PersonName ,(SELECT ClientName FROM Sys_Client WHERE ClientID = Sys_Rewrite.ClientID) AS ClientName FROM Sys_Rewrite WHERE 1=1 "; if (PersonID != "") { strSQL += "AND PersonID = '" + PersonID + @"' "; } if (ClientID != "") { strSQL += "AND ClientID = '" + ClientID + @"' "; } strSQL += "Order By RewriteID Desc"; return(CMMgr.GetDataTable(strSQL)); }
/// <summary> /// 获取一条Guide类信息 /// </summary> /// <param name="GuideID">登录编号</param> /// <returns>一条Guide类记录</returns> public Guide GetGuide(string GuideID) { Guide guide = new Guide(); string strSQL = "SELECT Top 1 * FROM Sys_Guide WHERE GuideID = " + GuideID; DataTable dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; guide.GuideID = int.Parse(row["GuideID"].ToString()); guide.GuideCode = row["GuideCode"].ToString(); guide.GuideName = row["GuideName"].ToString(); guide.Scale = int.Parse(row["Scale"].ToString()); guide.Scale1 = int.Parse(row["Scale1"].ToString()); guide.Scale2 = int.Parse(row["Scale2"].ToString()); guide.Scale3 = int.Parse(row["Scale3"].ToString()); return(guide); } else { return(guide); } }
/// <summary> /// 函数 GetAssesList | 获取评定指标信息列表 /// </summary> /// <returns>评定指标列表</returns> public DataTable GetAssesList(string PersonID, string PersonName, int SpecID) { string strSQL = @"SELECT * ,(SELECT GuideName FROM Sys_Guide WHERE GuideID = Sys_Asses.GuideID) AS GuideName ,(SELECT Guide2Name FROM Sys_Guide2 WHERE Guide2ID = Sys_Asses.Guide2ID) AS Guide2Name ,(SELECT PersonName FROM Sys_Person WHERE PersonID = Sys_Asses.PersonID) AS PersonName ,(SELECT Sex FROM Sys_Person WHERE PersonID = Sys_Asses.PersonID) AS Sex ,(SELECT Top 1 ClassInfoName FROM Sys_ClassInfo WHERE ClassInfoID IN (SELECT ClassInfoID FROM Sys_Asses WHERE PersonID = Sys_Asses.PersonID)) AS ClassInfoName ,(SELECT Top 1 SpecName FROM Sys_Spec WHERE SpecID IN (SELECT SpecID FROM Sys_Asses WHERE PersonID = Sys_Asses.PersonID)) AS SpecName FROM Sys_Asses WHERE PersonID IN (SELECT PersonID FROM Sys_Person WHERE PersonID Like '%" + PersonID + "%' AND PersonName Like '%" + PersonName + "%') "; if (SpecID != -1) { strSQL += "AND PersonID IN (SELECT PersonID FROM Sys_Person WHERE SpecID = " + SpecID.ToString() + ") "; } strSQL += "Order By CountNumber Desc"; return(CMMgr.GetDataTable(strSQL)); }
/// <summary> /// 删除AddNumber类信息 /// </summary> /// <param name="AddNumberID">登录编号参数</param> public void DelAddNumber(string AddNumberID) { string strSQL = "DELETE FROM Sys_AddNumber WHERE AddNumberID = " + AddNumberID; CMMgr.ExecuteNonQuery(strSQL); }
/// <summary> /// 更新Person类信息 /// </summary> /// <param name="person">学生管理类参数</param> /// <returns>更新成功返回true 否则返回false</returns> public bool UpdatePerson(Person person) { string strSQL = ""; SqlDataAdapter sa = null; SqlCommandBuilder builder = null; DataRow row = null; DataTable dt = null; bool returnValue = false; if (person != null) { if (person.PersonID == "") { strSQL = "SELECT Top 0 * FROM Sys_Person"; } else { strSQL = "SELECT Top 1 * FROM Sys_Person WHERE PersonID = '" + person.PersonID + "'"; } dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { row = dt.Rows[0]; } else { row = dt.NewRow(); } row["PersonID"] = person.PersonID; row["PersonName"] = person.PersonName; row["Password"] = person.Password; row["Sex"] = person.Sex; row["Birthday"] = person.Birthday; row["ClassInfoID"] = person.ClassInfo.ClassInfoID; row["SpecID"] = person.Spec.SpecID; if (dt.Rows.Count == 0) { dt.Rows.Add(row); } SqlConnection conn = CMMgr.GetConnection(); using (sa = new SqlDataAdapter("SELECT Top 0 * FROM Sys_Person", conn)) { try { builder = new SqlCommandBuilder(sa); sa.Update(dt); returnValue = true; } finally { conn.Close(); conn.Dispose(); } } } return(returnValue); }
/// <summary> /// 删除Person类信息 /// </summary> /// <param name="PersonID">登录编号参数</param> public void DelPerson(string PersonID) { string strSQL = "DELETE FROM Sys_Person WHERE PersonID = '" + PersonID + "'"; CMMgr.ExecuteNonQuery(strSQL); }
/// <summary> /// 更新AddNumber类信息 /// </summary> /// <param name="addNumber">留言管理类参数</param> /// <returns>更新成功返回true 否则返回false</returns> public bool UpdateAddNumber(AddNumber addNumber) { string strSQL = ""; SqlDataAdapter sa = null; SqlCommandBuilder builder = null; DataRow row = null; DataTable dt = null; bool returnValue = false; if (addNumber != null) { if (addNumber.AddNumberID == 0) { strSQL = "SELECT Top 0 * FROM Sys_AddNumber"; } else { strSQL = "SELECT Top 1 * FROM Sys_AddNumber WHERE AddNumberID = " + addNumber.AddNumberID.ToString(); } dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { row = dt.Rows[0]; } else { row = dt.NewRow(); } row["Title"] = addNumber.Title; row["Content"] = addNumber.Content; row["IsAudi"] = addNumber.IsAudi; row["PersonID"] = addNumber.Person.PersonID; row["ClientID"] = addNumber.Client.ClientID; row["Guide2ID"] = addNumber.Guide2.Guide2ID; row["GuideID"] = addNumber.Guide.GuideID; row["AddInt"] = addNumber.AddInt; if (dt.Rows.Count == 0) { dt.Rows.Add(row); } SqlConnection conn = CMMgr.GetConnection(); using (sa = new SqlDataAdapter("SELECT Top 0 * FROM Sys_AddNumber", conn)) { try { builder = new SqlCommandBuilder(sa); sa.Update(dt); returnValue = true; } finally { conn.Close(); conn.Dispose(); } } } return(returnValue); }
/// <summary> /// 更新Rewrite类信息 /// </summary> /// <param name="rewrite">留言管理类参数</param> /// <returns>更新成功返回true 否则返回false</returns> public bool UpdateRewrite(Rewrite rewrite) { string strSQL = ""; SqlDataAdapter sa = null; SqlCommandBuilder builder = null; DataRow row = null; DataTable dt = null; bool returnValue = false; if (rewrite != null) { if (rewrite.RewriteID == 0) { strSQL = "SELECT Top 0 * FROM Sys_Rewrite"; } else { strSQL = "SELECT Top 1 * FROM Sys_Rewrite WHERE RewriteID = " + rewrite.RewriteID.ToString(); } dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { row = dt.Rows[0]; } else { row = dt.NewRow(); } row["Title"] = rewrite.Title; row["Content"] = rewrite.Content; row["InputDate"] = rewrite.InputDate; row["PersonID"] = rewrite.Person.PersonID; row["ClientID"] = rewrite.Client.ClientID; row["ReContent"] = rewrite.ReContent; if (dt.Rows.Count == 0) { dt.Rows.Add(row); } SqlConnection conn = CMMgr.GetConnection(); using (sa = new SqlDataAdapter("SELECT Top 0 * FROM Sys_Rewrite", conn)) { try { builder = new SqlCommandBuilder(sa); sa.Update(dt); returnValue = true; } finally { conn.Close(); conn.Dispose(); } } } return(returnValue); }
/// <summary> /// 删除Rewrite类信息 /// </summary> /// <param name="RewriteID">登录编号参数</param> public void DelRewrite(string RewriteID) { string strSQL = "DELETE FROM Sys_Rewrite WHERE RewriteID = " + RewriteID; CMMgr.ExecuteNonQuery(strSQL); }