/// <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> /// 更新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> /// 更新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> /// 更新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> /// 更新Client类信息 /// </summary> /// <param name="client">教师管理类参数</param> /// <returns>更新成功返回true 否则返回false</returns> public bool UpdateClient(Client client) { string strSQL = ""; SqlDataAdapter sa = null; SqlCommandBuilder builder = null; DataRow row = null; DataTable dt = null; bool returnValue = false; if (client != null) { if (client.ClientID == "") { strSQL = "SELECT Top 0 * FROM Sys_Client"; } else { strSQL = "SELECT Top 1 * FROM Sys_Client WHERE ClientID = '" + client.ClientID + "'"; } dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { row = dt.Rows[0]; } else { row = dt.NewRow(); } row["ClientID"] = client.ClientID; row["ClientName"] = client.ClientName; row["Password"] = client.Password; row["Sex"] = client.Sex; row["ClassInfoID"] = client.ClassInfo.ClassInfoID; row["SpecID"] = client.Spec.SpecID; row["Tel"] = client.Tel; row["Mail"] = client.Mail; row["QQ"] = client.QQ; if (dt.Rows.Count == 0) { dt.Rows.Add(row); } SqlConnection conn = CMMgr.GetConnection(); using (sa = new SqlDataAdapter("SELECT Top 0 * FROM Sys_Client", conn)) { try { builder = new SqlCommandBuilder(sa); sa.Update(dt); returnValue = true; } finally { conn.Close(); conn.Dispose(); } } } return(returnValue); }
/// <summary> /// 更新Asses类信息 /// </summary> /// <param name="asses">评定指标管理类参数</param> /// <returns>更新成功返回true 否则返回false</returns> public bool UpdateAsses(Asses asses) { string strSQL = ""; SqlDataAdapter sa = null; SqlCommandBuilder builder = null; DataRow row = null; DataTable dt = null; bool returnValue = false; if (asses != null) { if (asses.AssesID == 0) { strSQL = "SELECT Top 0 * FROM Sys_Asses"; } else { strSQL = "SELECT Top 1 * FROM Sys_Asses WHERE AssesID = " + asses.AssesID.ToString(); } dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { row = dt.Rows[0]; } else { row = dt.NewRow(); } row["PersonID"] = asses.Person.PersonID; row["GuideID"] = asses.Guide.GuideID; row["Guide2ID"] = asses.Guide2.Guide2ID; row["Scale1"] = asses.Scale1; row["Scale2"] = asses.Scale2; row["Scale3"] = asses.Scale3; row["Scale1Name"] = asses.Scale1Name; row["Scale2Name"] = asses.Scale2Name; row["Scale3Name"] = asses.Scale3Name; row["CountNumber"] = asses.CountNumber; row["Memo"] = asses.Memo; if (dt.Rows.Count == 0) { dt.Rows.Add(row); } SqlConnection conn = CMMgr.GetConnection(); using (sa = new SqlDataAdapter("SELECT Top 0 * FROM Sys_Asses", conn)) { try { builder = new SqlCommandBuilder(sa); sa.Update(dt); returnValue = true; } finally { conn.Close(); conn.Dispose(); } } } return(returnValue); }
/// <summary> /// 更新Admin类信息 /// </summary> /// <param name="admin">管理员管理类参数</param> /// <returns>更新成功返回true 否则返回false</returns> public bool UpdateAdmin(Admin admin) { string strSQL = ""; SqlDataAdapter sa = null; SqlCommandBuilder builder = null; DataRow row = null; DataTable dt = null; bool returnValue = false; if (admin != null) { if (admin.AdminID == "") { strSQL = "SELECT Top 0 * FROM Sys_Admin"; } else { strSQL = "SELECT Top 1 * FROM Sys_Admin WHERE AdminID = '" + admin.AdminID + "'"; } dt = CMMgr.GetDataTable(strSQL); if (dt.Rows.Count > 0) { row = dt.Rows[0]; } else { row = dt.NewRow(); } row["AdminID"] = admin.AdminID; row["AdminName"] = admin.AdminName; row["Tel"] = admin.Tel; row["Mail"] = admin.Mail; row["QQ"] = admin.QQ; row["Password"] = admin.Password; if (dt.Rows.Count == 0) { dt.Rows.Add(row); } SqlConnection conn = CMMgr.GetConnection(); using (sa = new SqlDataAdapter("SELECT Top 0 * FROM Sys_Admin", conn)) { try { builder = new SqlCommandBuilder(sa); sa.Update(dt); returnValue = true; } finally { conn.Close(); conn.Dispose(); } } } return(returnValue); }