private static List <string> insertToGroupInfo(MySqlTransaction tran, ref UserConfigClass uc) { List <string> errs = new List <string>(); int groupId = getGroupIdByName(uc.modelName); if (string.IsNullOrEmpty(uc.modelName) || groupId < 0) { errs.Add(uc.name + "未配置分组"); return(errs); //throw new Exception("获取分组ID出现错误!"); } int maxId = getMaxId("tb_groupinfo"); if (maxId > 0) { string sql = string.Format("INSERT INTO `tb_groupinfo` VALUES ({0},'{1}','{2}','');", maxId + 1, groupId, uc.sid); int count = MySqlHelper.ExecuteNonQuery(tran, CommandType.Text, sql, null); errs.Add("student表插入语句后,影响行数:" + count); } else { throw new Exception("插入groupinfo出现错误!"); } return(errs); }
public void AddUserConfig(UserConfigClass uc) { DataRow dr = dtUserConfig.NewRow(); dr[0] = uc.loginId; dr[1] = uc.name; dtUserConfig.Rows.Add(dr); }
public static List <string> InsertToSql(UserConfigClass uc) { List <string> errs = new List <string>(); try { using (MySqlConnection conn = new MySqlConnection(Conn)) { conn.Open(); MySqlTransaction transaction = conn.BeginTransaction(); try { errs.AddRange(insertToUser(transaction, ref uc)); errs.AddRange(insertToStudent(transaction, ref uc)); errs.AddRange(insertToGroupInfo(transaction, ref uc)); transaction.Commit(); //MySqlCommand cmd = conn.CreateCommand(); //cmd.Transaction = transaction; //cmd.CommandText = "INSERT INTO tbl_phonenumber VALUES('1','1','2','3')"; //int x = cmd.ExecuteNonQuery(); //cmd.CommandText = "INSERT INTO tbl_phonenumber VALUES('1','1','2','4','5')"; //int y = cmd.ExecuteNonQuery(); //transaction.Commit(); } catch (Exception ex) { try { transaction.Rollback(); } catch { throw; } throw ex; } } } catch (Exception ex) { throw ex; } return(errs); }
private static List <string> insertToUser(MySqlTransaction tran, ref UserConfigClass uc) { List <string> errs = new List <string>(); int maxUserId = getMaxId("tb_user"); if (maxUserId > 0) { string sql = string.Format("INSERT INTO `tb_user` VALUES ({0},'{1}','','STUDENT',NULL,1,NULL,NULL,NULL,'OFF');", maxUserId + 1, uc.loginId); int count = MySqlHelper.ExecuteNonQuery(tran, CommandType.Text, sql, null); errs.Add("User表插入语句后,影响行数:" + count); } else { throw new Exception("User表查询最大ID出现错误!"); } return(errs); }
private static List <string> insertToStudent(MySqlTransaction tran, ref UserConfigClass uc) { List <string> errs = new List <string>(); int maxId = getMaxId("tb_student"); uc.sid = maxId + 1; if (maxId > 0) { string sql = string.Format("INSERT INTO `tb_student` VALUES ({0},'{1}','{2}',20,'MALE','-','',1,'-',0);", uc.sid, uc.loginId, uc.name); int count = MySqlHelper.ExecuteNonQuery(tran, CommandType.Text, sql, null); errs.Add("student表插入语句后,影响行数:" + count); } else { throw new Exception("student表查询最大ID出现错误!"); } return(errs); }