/// <summary> /// 保存考试类型 /// </summary> /// <returns></returns> public int SaveType(string ID, string TypeName) { string sql = ""; if (string.IsNullOrEmpty(ID)) { sql = "insert into scoretype(TypeName,Isdele) values('" + TypeName + "',0)"; } else { sql = "update scoretype set TypeName='" + TypeName + "' where ID=" + ID + ""; } return(DBHelp.ExecutSql(sql)); }
/// <summary> /// 保存用户 /// </summary> /// <returns></returns> public int SaveUsers(string ID, string Name, string Pass) { string sql = ""; Pass = GetMd5Str(Pass); if (string.IsNullOrEmpty(ID)) { sql = "insert into Users(Name,Pass,Isdele) values('" + Name + "','" + Pass + "',0)"; } else { sql = "update Users set Name='" + Name + "',Pass='******' where ID=" + ID + ""; } return(DBHelp.ExecutSql(sql)); }
/// <summary> /// / 批量修改有效日期 /// </summary> /// <param name="ID"></param> /// <param name="ValidTime"></param> /// <returns></returns> public int SaveValidTime(string ID, string ValidTime) { string sql = string.Format("update score set ValidTime='{0}' where ID in ({1})", ValidTime, ID); return(DBHelp.ExecutSql(sql)); }
/// <summary> /// 考试类型 /// </summary> /// <returns></returns> public int DeleType(string ID) { string sql = "update scoretype set Isdele=1 where ID=" + ID + ""; return(DBHelp.ExecutSql(sql)); }
/// <summary> /// del用户 /// </summary> /// <returns></returns> public int DeleUsers(string ID) { string sql = "update Users set Isdele=1 where ID=" + ID + ""; return(DBHelp.ExecutSql(sql)); }