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