/// <summary> /// 更新一条数据 /// </summary> public bool Update(DriveMgr.Model.RegistrationModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Students set "); strSql.Append("StudentsName=@StudentsName,"); strSql.Append("Sex=@Sex,"); strSql.Append("Age=@Age,"); strSql.Append("IsLocal=@IsLocal,"); strSql.Append("PhoneNum=@PhoneNum,"); strSql.Append("PeriodsID=@PeriodsID,"); strSql.Append("CardNum=@CardNum,"); strSql.Append("Address=@Address,"); strSql.Append("Remark=@Remark,"); strSql.Append("Operater=@Operater"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@StudentsName", SqlDbType.VarChar, 20), new SqlParameter("@Sex", SqlDbType.Bit, 1), new SqlParameter("@Age", SqlDbType.Int, 4), new SqlParameter("@IsLocal", SqlDbType.Bit, 1), new SqlParameter("@PhoneNum", SqlDbType.VarChar, 50), new SqlParameter("@PeriodsID", SqlDbType.Int, 4), new SqlParameter("@CardNum", SqlDbType.VarChar, 20), new SqlParameter("@Address", SqlDbType.VarChar, 200), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@Operater", SqlDbType.VarChar, 50), new SqlParameter("@ID", SqlDbType.BigInt, 8) }; parameters[0].Value = model.StudentsName; parameters[1].Value = model.Sex; parameters[2].Value = model.Age; parameters[3].Value = model.IsLocal; parameters[4].Value = model.PhoneNum; //手机号码 parameters[5].Value = model.PeriodsID; parameters[6].Value = model.CardNum; parameters[7].Value = model.Address; parameters[8].Value = model.Remark; parameters[9].Value = model.Operater; parameters[10].Value = model.ID; int rows = DriveMgr.Common.SqlHelper.ExecuteNonQuery(DriveMgr.Common.SqlHelper.connStrDriveData, CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DriveMgr.Model.RegistrationModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_Students("); strSql.Append("StudentsName,StudentCode,Sex,Age,IsLocal,PhoneNum,PeriodsID,CardNum,Address,PicPath,Remark,Status,Operater)"); strSql.Append(" values ("); strSql.Append("@StudentsName,@StudentCode,@Sex,@Age,@IsLocal,@PhoneNum,@PeriodsID,@CardNum,@Address,@PicPath,@Remark,@Status,@Operater)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@StudentsName", SqlDbType.VarChar, 20), new SqlParameter("@StudentCode", SqlDbType.VarChar, 20), new SqlParameter("@Sex", SqlDbType.Bit, 1), new SqlParameter("@Age", SqlDbType.Int, 4), new SqlParameter("@IsLocal", SqlDbType.Bit, 1), new SqlParameter("@PhoneNum", SqlDbType.VarChar, 50), new SqlParameter("@PeriodsID", SqlDbType.Int, 4), new SqlParameter("@CardNum", SqlDbType.VarChar, 20), new SqlParameter("@Address", SqlDbType.VarChar, 200), new SqlParameter("@PicPath", SqlDbType.VarChar, 200), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@Operater", SqlDbType.VarChar, 50) }; parameters[0].Value = model.StudentsName; parameters[1].Value = model.StudentCode; parameters[2].Value = model.Sex; parameters[3].Value = model.Age; parameters[4].Value = model.IsLocal; parameters[5].Value = model.PhoneNum; //手机号码 parameters[6].Value = model.PeriodsID; parameters[7].Value = model.CardNum; parameters[8].Value = model.Address; parameters[9].Value = model.PicPath; parameters[10].Value = model.Remark; parameters[11].Value = model.Status; parameters[12].Value = model.Operater; int rows = Convert.ToInt32(DriveMgr.Common.SqlHelper.ExecuteNonQuery(DriveMgr.Common.SqlHelper.connStrDriveData, CommandType.Text, strSql.ToString(), parameters)); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DriveMgr.Model.RegistrationModel GetModel(long stuId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,StudentsName,StudentCode,Sex,Age,PhoneNum,IsLocal,PeriodsID,CardNum,Address,PicPath,Remark,Status,Operater,flag from tb_Students "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.BigInt) }; parameters[0].Value = stuId; DriveMgr.Model.RegistrationModel model = new DriveMgr.Model.RegistrationModel(); DataTable dt = DriveMgr.Common.SqlHelper.GetDataTable(DriveMgr.Common.SqlHelper.connStrDriveData, CommandType.Text, strSql.ToString(), parameters); if (dt.Rows.Count > 0) { if (dt.Rows[0]["ID"] != null && dt.Rows[0]["ID"].ToString() != "") { model.ID = long.Parse(dt.Rows[0]["ID"].ToString()); } if (dt.Rows[0]["StudentsName"] != null && dt.Rows[0]["StudentsName"].ToString() != "") { model.StudentsName = dt.Rows[0]["StudentsName"].ToString(); } if (dt.Rows[0]["StudentCode"] != null && dt.Rows[0]["StudentCode"].ToString() != "") { model.StudentCode = dt.Rows[0]["StudentCode"].ToString(); } if (dt.Rows[0]["Sex"] != null && dt.Rows[0]["Sex"].ToString() != "") { if ((dt.Rows[0]["Sex"].ToString() == "1") || (dt.Rows[0]["Sex"].ToString().ToLower() == "true")) { model.Sex = true; } else { model.Sex = false; } } if (dt.Rows[0]["Age"] != null && dt.Rows[0]["Age"].ToString() != "") { model.Age = int.Parse(dt.Rows[0]["Age"].ToString()); } if (dt.Rows[0]["PhoneNum"] != null && dt.Rows[0]["PhoneNum"].ToString() != "") { model.PhoneNum = dt.Rows[0]["PhoneNum"].ToString(); } if (dt.Rows[0]["IsLocal"] != null && dt.Rows[0]["IsLocal"].ToString() != "") { if ((dt.Rows[0]["IsLocal"].ToString() == "1") || (dt.Rows[0]["IsLocal"].ToString().ToLower() == "true")) { model.IsLocal = true; } else { model.IsLocal = false; } } if (dt.Rows[0]["PeriodsID"] != null && dt.Rows[0]["PeriodsID"].ToString() != "") { model.PeriodsID = int.Parse(dt.Rows[0]["PeriodsID"].ToString()); } if (dt.Rows[0]["CardNum"] != null && dt.Rows[0]["CardNum"].ToString() != "") { model.CardNum = dt.Rows[0]["CardNum"].ToString(); } if (dt.Rows[0]["Address"] != null && dt.Rows[0]["Address"].ToString() != "") { model.Address = dt.Rows[0]["Address"].ToString(); } if (dt.Rows[0]["PicPath"] != null && dt.Rows[0]["PicPath"].ToString() != "") { model.PicPath = dt.Rows[0]["PicPath"].ToString(); } if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"].ToString() != "") { model.Remark = dt.Rows[0]["Remark"].ToString(); } if (dt.Rows[0]["Status"] != null && dt.Rows[0]["Status"].ToString() != "") { model.Status = int.Parse(dt.Rows[0]["Status"].ToString()); } if (dt.Rows[0]["Operater"] != null && dt.Rows[0]["Operater"].ToString() != "") { model.Operater = dt.Rows[0]["Operater"].ToString(); } if (dt.Rows[0]["flag"] != null && dt.Rows[0]["flag"].ToString() != "") { model.flag = int.Parse(dt.Rows[0]["flag"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 获得数据列表 /// </summary> public List <DriveMgr.Model.RegistrationModel> DataTableToList(DataTable dt) { List <DriveMgr.Model.RegistrationModel> modelList = new List <DriveMgr.Model.RegistrationModel>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { DriveMgr.Model.RegistrationModel model; for (int n = 0; n < rowsCount; n++) { model = new DriveMgr.Model.RegistrationModel(); if (dt.Rows[n]["ID"] != null && dt.Rows[n]["ID"].ToString() != "") { model.ID = long.Parse(dt.Rows[n]["ID"].ToString()); } if (dt.Rows[n]["StudentsName"] != null && dt.Rows[n]["StudentsName"].ToString() != "") { model.StudentsName = dt.Rows[n]["StudentsName"].ToString(); } if (dt.Rows[n]["StudentCode"] != null && dt.Rows[n]["StudentCode"].ToString() != "") { model.StudentCode = dt.Rows[n]["StudentCode"].ToString(); } if (dt.Rows[n]["Sex"] != null && dt.Rows[n]["Sex"].ToString() != "") { if ((dt.Rows[n]["Sex"].ToString() == "1") || (dt.Rows[n]["Sex"].ToString().ToLower() == "true")) { model.Sex = true; } else { model.Sex = false; } } if (dt.Rows[n]["Age"] != null && dt.Rows[n]["Age"].ToString() != "") { model.Age = int.Parse(dt.Rows[n]["Age"].ToString()); } if (dt.Rows[n]["IsLocal"] != null && dt.Rows[n]["IsLocal"].ToString() != "") { if ((dt.Rows[n]["IsLocal"].ToString() == "1") || (dt.Rows[n]["IsLocal"].ToString().ToLower() == "true")) { model.IsLocal = true; } else { model.IsLocal = false; } } if (dt.Rows[n]["PeriodsID"] != null && dt.Rows[n]["PeriodsID"].ToString() != "") { model.PeriodsID = int.Parse(dt.Rows[n]["PeriodsID"].ToString()); } if (dt.Rows[n]["CardNum"] != null && dt.Rows[n]["CardNum"].ToString() != "") { model.CardNum = dt.Rows[n]["CardNum"].ToString(); } if (dt.Rows[n]["Address"] != null && dt.Rows[n]["Address"].ToString() != "") { model.Address = dt.Rows[n]["Address"].ToString(); } if (dt.Rows[n]["Remark"] != null && dt.Rows[n]["Remark"].ToString() != "") { model.Remark = dt.Rows[n]["Remark"].ToString(); } if (dt.Rows[n]["Status"] != null && dt.Rows[n]["Status"].ToString() != "") { model.Status = int.Parse(dt.Rows[n]["Status"].ToString()); } if (dt.Rows[n]["Operater"] != null && dt.Rows[n]["Operater"].ToString() != "") { model.Operater = dt.Rows[n]["Operater"].ToString(); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DriveMgr.Model.RegistrationModel model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DriveMgr.Model.RegistrationModel model) { return(dal.Add(model)); }