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