public int Update_ExamType(Entity.ExamType 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(ExamType_key_a, ExamType_item_prop_a, Include, Exclude, info, ref set_str, ref l_parms); commandText.AppendLine(" UPDATE [ExamType]"); commandText.AppendLine(" SET " + set_str); commandText.AppendLine(" " + SqlHelper.Get_Where_Str(ExamType_key_a)); return(DbHelper.PE.ExecuteNonQuery(CommandType.Text, commandText.ToString(), l_parms.ToArray())); }
public int Insert_ExamType(Entity.ExamType info, string[] Include, string[] Exclude) { try { 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(ExamType_item_prop_a, Include, Exclude, info, ref item_name, ref item_value, ref l_parms); commandText.AppendLine("INSERT INTO [ExamType] (" + item_name + ") VALUES (" + item_value + ")"); return(DbHelper.PE.ExecuteNonQuery(CommandType.Text, commandText.ToString(), l_parms.ToArray())); } catch (Exception ex) { throw; } }