public void MenuManager()
{
Model.StudentModel model = new Model.StudentModel();
Controller.StudentController controller = new Controller.StudentController();
Console.WriteLine("<==============================>");
Console.WriteLine("<==== STUDENT MAMAGER MENU ====>");
Console.WriteLine("<==============================>");
Console.WriteLine("<= 1 : List Student =>");
Console.WriteLine("<= 2 : Find Student =>");
Console.WriteLine("<= 3 : Add Student =>");
Console.WriteLine("<= 4 : Update Student =>");
Console.WriteLine("<= 5 : Delete Student =>");
Console.WriteLine("<= 6 : EXIT =>");
Console.WriteLine("<==============================>\n");
Console.Write("Enter your choice: ");
int choice = int.Parse(Console.ReadLine());
switch (choice)
{
case 1:
model.SelectData();
break;
case 2:
controller.FindStudent();
//model.FindData();
break;
case 3:
controller.AddStudent();
break;
case 4:
controller.UpdateStudent();
break;
case 5:
controller.DeleteStudent();
break;
case 6:
Console.WriteLine("Good bye!");
Environment.Exit(0);
break;
default:
Console.WriteLine("Please choice from 1 to 6! Thank you!");
break;
}
}
/// <summary>
/// 将行数据转换成对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public Model.StudentModel DataRowToModel(DataRow dr)
{
Model.StudentModel model = new Model.StudentModel();
if (dr != null)
{
model.Id = Convert.ToInt32(dr["Id"].ToString());
model.Adress = dr["Adress"].ToString();
model.Age = dr["Age"].ToString();
model.ClassNumber = dr["classNumber"].ToString();
model.Id_Card = dr["Id_Card"].ToString();
model.Name = dr["Name"].ToString();
model.PhoneNumber = dr["PhoneNumber"].ToString();
model.RoleId = dr["RoleId"].ToString();
model.UserType = dr["UserType"].ToString();
model.PassWord = dr["PassWord"].ToString();
}
return(model);
}
public StudentViewModel()
{
if (IsInDesignMode)
{
//设计时数据
StudentModel = new Model.StudentModel()
{
Id = 1, Name = "zhansgan"
};
}
else
{
//从数据库获取
StudentModel = new Model.StudentModel()
{
Id = 4, Name = "lisi"
};
}
}
/// <summary>
/// 新增方法
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(Model.StudentModel model)
{
StringBuilder strSQL = new StringBuilder();
strSQL.Append("insert into student (name,classNumber,age,sex,phoneNumber,id_Card,adress,roleId,userType,password)");
strSQL.Append("values (@name,@classNumber,@age,@sex,@phoneNumber,@id_Card,@adress,@roleId,@userType,@password)");
SqlParameter[] parameters =
{
new SqlParameter("@name", SqlDbType.VarChar, 20),
new SqlParameter("@classNumber", SqlDbType.VarChar, 20),
new SqlParameter("@age", SqlDbType.VarChar, 5),
new SqlParameter("@sex", SqlDbType.VarChar, 5),
new SqlParameter("@phoneNumber", SqlDbType.VarChar, 18),
new SqlParameter("@id_Card", SqlDbType.VarChar, 18),
new SqlParameter("@adress", SqlDbType.VarChar, 200),
new SqlParameter("@roleId", SqlDbType.VarChar, 5),
new SqlParameter("@userType", SqlDbType.VarChar, 5),
new SqlParameter("@password", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.ClassNumber;
parameters[2].Value = model.Adress;
parameters[3].Value = model.Sex;
parameters[4].Value = model.PhoneNumber;
parameters[5].Value = model.Id_Card;
parameters[6].Value = model.Adress;
parameters[7].Value = model.RoleId;
parameters[8].Value = model.UserType;
parameters[9].Value = model.PassWord;
int row = Maticsoft.DBUtility.DbHelperSQL.ExecuteSql(strSQL.ToString(), parameters);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Update(Model.StudentModel model)
{
StringBuilder strSQL = new StringBuilder();
strSQL.Append("update student set name=@name,classNumber=@classNumber,age=@age,sex=@sex,@phoneNumber=@phoneNumber,id_Card=@id_Card,adress=@adress,roleId=@roleid,userType=@userType,password=@PassWord where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@name", SqlDbType.VarChar, 20),
new SqlParameter("@classNumber", SqlDbType.VarChar, 20),
new SqlParameter("@age", SqlDbType.VarChar, 5),
new SqlParameter("@sex", SqlDbType.VarChar, 5),
new SqlParameter("@phoneNumber", SqlDbType.VarChar, 18),
new SqlParameter("@id_Card", SqlDbType.VarChar, 18),
new SqlParameter("@adress", SqlDbType.VarChar, 200),
new SqlParameter("@roleId", SqlDbType.VarChar, 5),
new SqlParameter("@userType", SqlDbType.VarChar, 5),
new SqlParameter("@password", SqlDbType.VarChar, 50),
new SqlParameter("@id", SqlDbType.Int)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.ClassNumber;
parameters[2].Value = model.Adress;
parameters[3].Value = model.Sex;
parameters[4].Value = model.PhoneNumber;
parameters[5].Value = model.Id_Card;
parameters[6].Value = model.Adress;
parameters[7].Value = model.RoleId;
parameters[8].Value = model.UserType;
parameters[9].Value = model.PassWord;
parameters[10].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSQL.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 根据ID获取对象;
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public Model.StudentModel GetModel(int Id)
{
StringBuilder strSQL = new StringBuilder();
strSQL.Append("select id,name,classNumber,age,sex,ID_card,phoneNumber,adress,roleId,Usertype,PassWord from student");
strSQL.Append(" where id=@id");
SqlParameter[] parameter =
{
new SqlParameter("@id", SqlDbType.Int)
};
parameter[0].Value = Id;
DataSet ds = DbHelperSQL.Query(strSQL.ToString(), parameter);
Model.StudentModel tempModel = new Model.StudentModel();
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow item in ds.Tables[0].Rows)
{
tempModel = DataRowToModel(item);
}
}
return(tempModel);
}
