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