public int Insert_ExamUserInfo(Entity.ExamUserInfo info, string[] Include, string[] Exclude)
{
List <DbParameter> l_parms = new List <DbParameter>();
StringBuilder commandText = new StringBuilder();
string item_name = string.Empty;
string item_value = string.Empty;
SqlHelper.Get_Inserte_Set(ExamUserInfo_item_prop_a, Include, Exclude, info, ref item_name, ref item_value, ref l_parms);
commandText.AppendLine("INSERT INTO [ExamUserInfo] (" + item_name + ") VALUES (" + item_value + ")");
return(DbHelper.PE.ExecuteNonQuery(CommandType.Text, commandText.ToString(), l_parms.ToArray()));
}
public int Update_ExamUserInfo(Entity.ExamUserInfo info, string[] Include, string[] Exclude)
{
List <DbParameter> l_parms = new List <DbParameter>();
StringBuilder commandText = new StringBuilder();
string set_str = string.Empty;
SqlHelper.Get_Update_Set(ExamUserInfo_key_a, ExamUserInfo_item_prop_a, Include, Exclude, info, ref set_str, ref l_parms);
commandText.AppendLine(" UPDATE [ExamUserInfo]");
commandText.AppendLine(" SET " + set_str);
commandText.AppendLine(" " + SqlHelper.Get_Where_Str(ExamUserInfo_key_a));
return(DbHelper.PE.ExecuteNonQuery(CommandType.Text, commandText.ToString(), l_parms.ToArray()));
}
public ExamUserInfoModel() : base()
{
UserInfoList = new UserInfo();
ListUserInfo = new List <UserInfo>();
YListUserInfo = new List <UserInfo>();
ListRankInfo = new List <Entity.RankInfo>();
ListExamUserDetailInfo = new List <Entity.ExamUserDetailInfo>();
ListPracticeInfo = new List <Entity.PracticeInfo>();
VExamUserInfo = new Entity.ExamUserInfo();
ListExamUserInfo = new List <Entity.ExamUserInfo>();
VExamUserDetailInfo = new Entity.ExamUserDetailInfo();
ListRank = new List <Entity.RankInfo>();
ListSkillInfo = new List <Entity.SkillInfo>();
LPracticeInfo = new List <PracticeInfo>();
LExamUserDetailInfo = new List <ExamUserDetailInfo>();
ListDetailInfo = new List <ExamUserDetailInfo>();
LExamType = new List <KeyValuePair <string, string> >();
ListUserInfo11 = new List <UserInfo>();
}
