/// <summary>
/// 初始化页面数据
/// </summary>
private void InitPage()
{
string strID = Request.QueryString["id"];
int intID;
TB_Room mTB_Room = null;
RoomBLL mRoomBLL = new RoomBLL();
if (Int32.TryParse(strID, out intID))
{
mTB_Room = mRoomBLL.Get(intID);
this.txtRoom.Text = mTB_Room.Name;
//this.txtKeyCount.Text = mTB_Room.KeyCount.ToString();
this.ddlDormArea.SelectedValue = mTB_Room.DormAreaID.ToString();
this.BindDDLBuilding(mTB_Room.DormAreaID);
this.ddlBuilding.SelectedValue = mTB_Room.BuildingID.ToString();
this.BindDDLUnit(mTB_Room.BuildingID);
this.ddlUnit.SelectedValue = mTB_Room.UnitID.ToString();
this.ddlRoomType.SelectedValue = mTB_Room.RoomType.ToString();
this.ddlRoomSexType.SelectedValue = mTB_Room.RoomSexType.ToString();
this.BindDDLFloor(mTB_Room.UnitID);
this.ddlFloor.SelectedValue = mTB_Room.FloorID.ToString();
this.ddlRoomType2.SelectedValue = mTB_Room.RoomType2.ToString();
}
}
/// <summary>
/// GridView绑定
/// </summary>
/// <param name="intCurrentIndex"></param>
private void Bind(int intCurrentIndex)
{
TB_Room mTB_Room = new TB_Room();
RoomBLL mRoomBLL = new RoomBLL();
Pager pager = new Pager();
pager.CurrentPageIndex = intCurrentIndex;
pager.srcOrder = " ID desc";
mTB_Room.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
mTB_Room.DormAreaID = Convert.ToInt32(this.ddlDormArea.SelectedValue);
mTB_Room.BuildingID = Convert.ToInt32(Request.Form[this.ddlBuildingName.UniqueID.ToString()]);
mTB_Room.UnitID = Convert.ToInt32(Request.Form[this.ddlUnit.UniqueID.ToString()]);
mTB_Room.FloorID = Convert.ToInt32(Request.Form[this.ddlFloor.UniqueID.ToString()]);
mTB_Room.RoomType = Convert.ToInt32(this.ddlRoomType.SelectedValue);
mTB_Room.RoomSexType = this.ddlRoomSexType.SelectedValue;
mTB_Room.RoomType2 = string.IsNullOrEmpty(this.ddlRoomType2.SelectedValue) ? 0 : Convert.ToInt32(this.ddlRoomType2.SelectedValue);
mTB_Room.Name = this.txtRoom.Text.Trim();
GridView1.DataSource = mRoomBLL.GetTable(mTB_Room, ref pager);
GridView1.DataBind();
this.Pager1.ItemCount = pager.TotalRecord;
this.Pager1.PageCount = pager.TotalPage;
this.Pager1.CurrentIndex = pager.CurrentPageIndex;
this.Pager1.PageSize = pager.PageSize;
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="tb_Room"></param>
/// <returns></returns>
public int Edit(TB_Room tb_Room)
{
DataTable dt = null;
//查询房间号是否存在
dt = _mTB_RoomDAL.GetTable(tb_Room);
if (dt != null && dt.Rows.Count > 0)
{
_errMessage = "房间号已存在！";
}
else
{
//更新操作
if (tb_Room.ID > 0)
{
_mTB_RoomDAL.Edit(tb_Room);
}
//添加操作
else
{
tb_Room.ID = _mTB_RoomDAL.Create(tb_Room);
}
}
return(tb_Room.ID);
}
public string EditRoom(TB_Room tb_Room)
{
RoomBLL mRoomBLL = new RoomBLL();
mRoomBLL.ErrMessage = string.Empty;
mRoomBLL.Edit(tb_Room);
return(mRoomBLL.ErrMessage);
}
/// <summary>
/// 事务更新
/// </summary>
/// <param name="info"></param>
/// <param name="tran"></param>
/// <param name="db"></param>
/// <returns></returns>
public int Edit(TB_Room info, DbTransaction tran, Database db)
{
DbCommand dbCommandWrapper = null;
string strUpdateSql = @"UPDATE TB_Room SET DormAreaID=@DormAreaID
,BuildingID=@BuildingID
,UnitID=@UnitID
,FloorID=@FloorID
,RoomSexType=@RoomSexType
,RoomType=@RoomType
,Name=@Name
,UpdateBy=@UpdateBy
,UpdateDate=@UpdateDate
,RoomType2=@RoomType2
WHERE ID=@ID";
try
{
dbCommandWrapper = db.GetSqlStringCommand(strUpdateSql);
#region Add parameters
db.AddInParameter(dbCommandWrapper, "@ID", DbType.Int32, info.ID);
db.AddInParameter(dbCommandWrapper, "@DormAreaID", DbType.Int32, info.DormAreaID);
db.AddInParameter(dbCommandWrapper, "@BuildingID", DbType.Int32, info.BuildingID);
db.AddInParameter(dbCommandWrapper, "@UnitID", DbType.Int32, info.UnitID);
db.AddInParameter(dbCommandWrapper, "@FloorID", DbType.Int32, info.FloorID);
db.AddInParameter(dbCommandWrapper, "@Name", DbType.String, info.Name);
db.AddInParameter(dbCommandWrapper, "@RoomSexType", DbType.String, info.RoomSexType);
db.AddInParameter(dbCommandWrapper, "@RoomType", DbType.Int32, info.RoomType);
db.AddInParameter(dbCommandWrapper, "@RoomType2", DbType.Int32, info.RoomType2);
db.AddInParameter(dbCommandWrapper, "@UpdateBy", DbType.String, SetNullValue(string.IsNullOrEmpty(info.UpdateBy), info.UpdateBy));
db.AddInParameter(dbCommandWrapper, "@UpdateDate", DbType.DateTime, DateTime.Now);
//db.AddInParameter(dbCommandWrapper, "@KeyCount", DbType.String, info.KeyCount);
#endregion
if (tran == null)
{
return(db.ExecuteNonQuery(dbCommandWrapper));
}
else
{
return(db.ExecuteNonQuery(dbCommandWrapper, tran));
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbCommandWrapper != null)
{
dbCommandWrapper = null;
}
}
}
/// <summary>
/// GridView绑定
/// </summary>
/// <param name="intCurrentIndex"></param>
private void Bind(int intCurrentIndex)
{
TB_Room mTB_Room = new TB_Room();
RoomBLL mRoomBLL = new RoomBLL();
Pager pager = new Pager();
pager.CurrentPageIndex = intCurrentIndex;
pager.srcOrder = " ID desc";
mTB_Room.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
mTB_Room.DormAreaID = Convert.ToInt32(this.ddlDormArea.SelectedValue);
mTB_Room.BuildingID = Convert.ToInt32(Request.Form[this.ddlBuildingName.UniqueID.ToString()]);
mTB_Room.UnitID = Convert.ToInt32(Request.Form[this.ddlUnit.UniqueID.ToString()]);
mTB_Room.FloorID = Convert.ToInt32(Request.Form[this.ddlFloor.UniqueID.ToString()]);
DataTable dt = mRoomBLL.GetMonthDormInfoBySiteID(2, txtStartDay.Text);
if (dt != null)
{
GridView1.Columns.Clear();//首先清空要显示的列名称（每次绑定时重新填充）
BoundField bf = new BoundField();
bf.DataField = dt.Columns[0].ColumnName;
bf.HeaderText = "宿舍区";
this.GridView1.Columns.Add(bf);
bf = new BoundField();
bf.DataField = dt.Columns[1].ColumnName;
bf.HeaderText = "入住级别";
this.GridView1.Columns.Add(bf);
bf = new BoundField();
bf.DataField = "project";
bf.HeaderText = "项目";
this.GridView1.Columns.Add(bf);
for (int i = 0; i < dt.Columns.Count; i++)
{
if (dt.Columns[i].ColumnName != "Areaname" && dt.Columns[i].ColumnName != "Roomtypt" && dt.Columns[i].ColumnName != "project")
{
bf = new BoundField();
bf.DataField = dt.Columns[i].ColumnName;
bf.HeaderText = dt.Columns[i].ColumnName;
this.GridView1.Columns.Add(bf);//只能添加BoundField 对象
}
}
DataView dw = dt.DefaultView;
dw.Sort = "Areaname,Roomtypt desc";
GridView1.DataSource = dw;// GetUnLockRoom(mTB_Room, ref pager);
GridView1.DataBind();
MergeRow(GridView1, 0, 3);
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int Edit(TB_Room info)
{
try
{
Database db = DBO.CreateDatabase();
return(this.Edit(info, (DbTransaction)null, db));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public DataTable GetTable(TB_Room info)
{
DataTable dt = null;
DbCommand dbCommandWrapper = null;
try
{
string strSQL = @"select id from TB_Room where 1=1";
StringBuilder strBuilder = new StringBuilder(strSQL);
Database db = DBO.GetInstance();
dbCommandWrapper = db.DbProviderFactory.CreateCommand();
dbCommandWrapper.CommandType = CommandType.Text;
if (info.ID > 0)
{
strBuilder.AppendLine(" AND ID <> @ID");
db.AddInParameter(dbCommandWrapper, "@ID", DbType.Int32, info.ID);
}
strBuilder.AppendLine(" AND SiteID = @SiteID");
db.AddInParameter(dbCommandWrapper, "@SiteID", DbType.Int32, info.SiteID);
strBuilder.AppendLine(" AND NAME = @NAME");
db.AddInParameter(dbCommandWrapper, "@NAME", DbType.String, info.Name);
strBuilder.AppendLine(" AND DormAreaID = @DormAreaID");
db.AddInParameter(dbCommandWrapper, "@DormAreaID", DbType.Int32, info.DormAreaID);
strBuilder.AppendLine(" AND BuildingID = @BuildingID");
db.AddInParameter(dbCommandWrapper, "@BuildingID", DbType.Int32, info.BuildingID);
if (info.UnitID > 0)
{
strBuilder.AppendLine(" AND UnitID = @UnitID");
db.AddInParameter(dbCommandWrapper, "@UnitID", DbType.Int32, info.UnitID);
}
if (info.FloorID > 0)
{
strBuilder.AppendLine(" AND FloorID = @FloorID");
db.AddInParameter(dbCommandWrapper, "@FloorID", DbType.Int32, info.FloorID);
}
dbCommandWrapper.CommandText = strBuilder.ToString();
dt = db.ExecuteDataSet(dbCommandWrapper).Tables[0];
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbCommandWrapper != null)
{
dbCommandWrapper = null;
}
}
}
/// <summary>
/// 事务添加
/// </summary>
/// <param name="info"></param>
/// <param name="tran"></param>
/// <param name="db"></param>
/// <returns></returns>
public int Create(TB_Room info, DbTransaction tran, Database db)
{
DbCommand dbCommandWrapper = null;
int intId;
string strInsertSql = @"INSERT INTO TB_Room (SiteID,DormAreaID,BuildingID,UnitID,FloorID,Name,RoomSexType,RoomType,Creator,RoomType2)
VALUES(@SiteID,@DormAreaID,@BuildingID,@UnitID,@FloorID,@Name,@RoomSexType,@RoomType,@Creator,@RoomType2)";
string strSelectIdSql = ";SELECT SCOPE_IDENTITY()";
try
{
dbCommandWrapper = db.GetSqlStringCommand(strInsertSql + strSelectIdSql);
#region Add parameters
db.AddInParameter(dbCommandWrapper, "@SiteID", DbType.Int32, info.SiteID);
db.AddInParameter(dbCommandWrapper, "@DormAreaID", DbType.Int32, info.DormAreaID);
db.AddInParameter(dbCommandWrapper, "@BuildingID", DbType.Int32, info.BuildingID);
db.AddInParameter(dbCommandWrapper, "@UnitID", DbType.Int32, info.UnitID);
db.AddInParameter(dbCommandWrapper, "@FloorID", DbType.Int32, info.FloorID);
db.AddInParameter(dbCommandWrapper, "@Name", DbType.String, info.Name);
db.AddInParameter(dbCommandWrapper, "@RoomSexType", DbType.String, info.RoomSexType);
db.AddInParameter(dbCommandWrapper, "@RoomType", DbType.Int32, info.RoomType);
db.AddInParameter(dbCommandWrapper, "@RoomType2", DbType.Int32, info.RoomType2);
db.AddInParameter(dbCommandWrapper, "@Creator", DbType.String, SetNullValue(string.IsNullOrEmpty(info.Creator), info.Creator));
#endregion
if (tran == null)
{
intId = Convert.ToInt32(db.ExecuteScalar(dbCommandWrapper));
}
else
{
intId = Convert.ToInt32(db.ExecuteScalar(dbCommandWrapper, tran));
}
return(intId);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbCommandWrapper != null)
{
dbCommandWrapper = null;
}
}
}
/// <summary>
/// 根据ID获取对象
/// </summary>
/// <param name="intID"></param>
/// <returns></returns>
public TB_Room Get(int intID)
{
DataTable dt = null;
DbCommand dbCommandWrapper = null;
TB_Room mTB_Room = null;
try
{
string strSQL = @"select * from TB_Room where 1=1";
StringBuilder strBuilder = new StringBuilder(strSQL);
Database db = DBO.GetInstance();
dbCommandWrapper = db.DbProviderFactory.CreateCommand();
dbCommandWrapper.CommandType = CommandType.Text;
strBuilder.AppendLine(" AND ID = @ID");
db.AddInParameter(dbCommandWrapper, "@ID", DbType.Int32, intID);
dbCommandWrapper.CommandText = strBuilder.ToString();
dt = db.ExecuteDataSet(dbCommandWrapper).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
mTB_Room = new TB_Room()
{
DormAreaID = Convert.ToInt32(dt.Rows[0][TB_Room.col_DormAreaID]),
BuildingID = Convert.ToInt32(dt.Rows[0][TB_Room.col_BuildingID]),
UnitID = Convert.ToInt32(dt.Rows[0][TB_Room.col_UnitID]),
FloorID = Convert.ToInt32(dt.Rows[0][TB_Room.col_FloorID]),
RoomSexType = Convert.ToString(dt.Rows[0][TB_Room.col_RoomSexType]),
RoomType = Convert.ToInt32(dt.Rows[0][TB_Room.col_RoomType]),
RoomType2 = Convert.ToInt32(dt.Rows[0][TB_Room.col_RoomType2]), //默认值应当为0
Name = Convert.ToString(dt.Rows[0][TB_Room.col_Name]),
KeyCount = Convert.ToString(dt.Rows[0][TB_Room.col_KeyCount]),
};
}
return(mTB_Room);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbCommandWrapper != null)
{
dbCommandWrapper = null;
}
}
}
/// <summary>
/// GridView绑定
/// </summary>
/// <param name="intCurrentIndex"></param>
private void Bind(int intCurrentIndex)
{
TB_Room mTB_Room = new TB_Room();
RoomBLL mRoomBLL = new RoomBLL();
Pager pager = new Pager();
pager.CurrentPageIndex = intCurrentIndex;
pager.srcOrder = " ID desc";
mTB_Room.SiteID = (base.UserInfo == null ? base.SystemAdminInfo.SiteID : base.UserInfo.SiteID);
mTB_Room.DormAreaID = Convert.ToInt32(this.ddlDormArea.SelectedValue);
mTB_Room.BuildingID = Convert.ToInt32(Request.Form[this.ddlBuildingName.UniqueID.ToString()]);
mTB_Room.UnitID = Convert.ToInt32(Request.Form[this.ddlUnit.UniqueID.ToString()]);
mTB_Room.FloorID = Convert.ToInt32(Request.Form[this.ddlFloor.UniqueID.ToString()]);
GridView1.DataSource = mRoomBLL.GetDormInfoBySiteID(2);// GetUnLockRoom(mTB_Room, ref pager);
GridView1.DataBind();
MergeRow(GridView1, 0, 3);
}
public ActionResult Create(TB_Room tB_Room
, IEnumerable<HttpPostedFileBase> files)
{
tB_Room.ImgUrl1 = "";
tB_Room.ImgUrl2 = "";
tB_Room.ImgUrl3 = "";
tB_Room.ImgUrl4 = "";
tB_Room.ImgUrl5 = "";
if (ModelState.IsValid)
{
db.TB_Room.Add(tB_Room);
db.SaveChanges();
this.UploadFiles(tB_Room, files);
return RedirectToAction("Index");
}
return View(tB_Room);
}
public ActionResult Edit(TB_Room tB_Room
, IEnumerable<HttpPostedFileBase> files)
{
tB_Room.ImgUrl1 = "";
tB_Room.ImgUrl2 = "";
tB_Room.ImgUrl3 = "";
tB_Room.ImgUrl4 = "";
tB_Room.ImgUrl5 = "";
if (ModelState.IsValid)
{
db.Entry(tB_Room).State = EntityState.Modified;
db.SaveChanges();
this.UploadFiles(tB_Room, files);
return RedirectToAction("Index");
}
return View(tB_Room);
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <param name="pager"></param>
/// <returns></returns>
public DataTable GetUnLockRoom(TB_Room info, ref Pager pager)
{
DataTable dt = null;
DbCommand dbCommandWrapper = null;
try
{
StringBuilder strBuilder = new StringBuilder(@"
select A.[ID]
,A.[FloorID]
,A.[Name]
,A.[RoomSexType]
,case A.[RoomType2]
when 1 then '员工宿舍'
when 2 then '家庭房'
else ''
end
as RoomType2
,A.[Creator]
,A.[CreateDate]
,A.[UpdateBy]
,A.[UpdateDate]
,A.[SiteID]
,A.[DormAreaID]
,A.[BuildingID]
,A.[UnitID]
,B.Name as DormAreaName
,C.name as BuildingName
,D.Name As UnitName
,E.Name As FloorName
,F.Name As RoomTypeName
,count(G.ID) AS FreeBedCount
from [TB_Room] as A
left join TB_dormarea As B
on A.DormAreaID=B.ID
left join TB_building as C
on a.buildingid=c.id
left join TB_RoomType AS F
on a.RoomType=F.ID
left join TB_Unit AS D
on a.UnitID=D.ID
left join TB_Floor as E
on a.FloorID=E.ID
left join [TB_Bed] as G
on a.id=G.roomID and G.[Status]=1 and G.ID not in (select BedID from [TB_AssignRoom]) AND (G.IsEnable<>'已禁用' OR G.IsEnable is NULL)");
Database db = DBO.GetInstance();
dbCommandWrapper = db.DbProviderFactory.CreateCommand();
dbCommandWrapper.CommandType = CommandType.Text;
#region 拼接条件
if (null != SessionHelper.Get(HttpContext.Current, TypeManager.User))
{
strBuilder.AppendLine(@"inner join [TB_UserConnectDormArea] AS H
on B.ID=H.[DormAreaID]
where 1=1 ");
strBuilder.AppendLine(" AND H.[UserID] = @UserID");
db.AddInParameter(dbCommandWrapper, "@UserID", DbType.Int32, ((TB_User)SessionHelper.Get(HttpContext.Current, TypeManager.User)).ID);
}
else
{
strBuilder.AppendLine(" where 1=1 ");
}
if (info.SiteID > 0)
{
strBuilder.AppendLine(" AND A.SiteID = @SiteID");
db.AddInParameter(dbCommandWrapper, "@SiteID", DbType.Int32, info.SiteID);
}
if (!string.IsNullOrEmpty(info.Name))
{
strBuilder.AppendLine(" AND A.NAME LIKE @NAME");
db.AddInParameter(dbCommandWrapper, "@NAME", DbType.String, "%" + info.Name + "%");
}
if (info.DormAreaID > 0)
{
strBuilder.AppendLine(" AND A.DormAreaID = @DormAreaID");
db.AddInParameter(dbCommandWrapper, "@DormAreaID", DbType.Int32, info.DormAreaID);
}
if (info.BuildingID > 0)
{
strBuilder.AppendLine(" AND A.BuildingID = @BuildingID");
db.AddInParameter(dbCommandWrapper, "@BuildingID", DbType.Int32, info.BuildingID);
}
if (info.UnitID > 0)
{
strBuilder.AppendLine(" AND A.UnitID = @UnitID");
db.AddInParameter(dbCommandWrapper, "@UnitID", DbType.Int32, info.UnitID);
}
if (info.FloorID > 0)
{
strBuilder.AppendLine(" AND A.FloorID = @FloorID");
db.AddInParameter(dbCommandWrapper, "@FloorID", DbType.Int32, info.FloorID);
}
if (info.RoomType > 0)
{
strBuilder.AppendLine(" AND A.RoomType = @RoomType");
db.AddInParameter(dbCommandWrapper, "@RoomType", DbType.Int32, info.RoomType);
}
if (info.RoomType2 > 0)
{
strBuilder.AppendLine(" AND A.RoomType2 = @RoomType2");
db.AddInParameter(dbCommandWrapper, "@RoomType2", DbType.Int32, info.RoomType2);
}
if (!String.IsNullOrEmpty(info.RoomSexType))
{
strBuilder.AppendLine(" AND A.RoomSexType = @RoomSexType");
db.AddInParameter(dbCommandWrapper, "@RoomSexType", DbType.String, info.RoomSexType);
}
strBuilder.AppendLine(@"group by A.[ID]
,A.[FloorID]
,A.[Name]
,A.[RoomSexType]
,RoomType2
,A.[Creator]
,A.[CreateDate]
,A.[UpdateBy]
,A.[UpdateDate]
,A.[SiteID]
,A.[DormAreaID]
,A.[BuildingID]
,A.[UnitID]
,B.Name
,C.name
,D.Name
,E.Name
,F.Name
having count(G.ID)>0" );
#endregion
if (pager != null && !pager.IsNull)
{
dbCommandWrapper.CommandText = pager.GetPagerSql4Count(strBuilder.ToString());
dt = db.ExecuteDataSet(dbCommandWrapper).Tables[0];
pager.TotalRecord = Convert.ToInt32(dt.Rows[0][0]);
dbCommandWrapper.CommandText = pager.GetPagerSql4Data(strBuilder.ToString(), DataBaseTypeEnum.sqlserver);
}
else
{
dbCommandWrapper.CommandText = strBuilder.ToString();
}
dt = db.ExecuteDataSet(dbCommandWrapper).Tables[0];
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbCommandWrapper != null)
{
dbCommandWrapper = null;
}
}
}
/// <summary>
/// 获取到未锁定的房间数
/// </summary>
/// <param name="tb_Room"></param>
/// <param name="pager"></param>
/// <returns></returns>
public DataTable GetUnLockRoom(TB_Room tb_Room, ref Pager pager)
{
return(_mTB_RoomDAL.GetUnLockRoom(tb_Room, ref pager));
}
private void UploadFiles(TB_Room tB_Room, IEnumerable<HttpPostedFileBase> files)
{
try
{
if (files != null && files.Any())
{
foreach (var uploadfile in files)
{
if (uploadfile != null && uploadfile.ContentLength > 0)
{
var fileName = Path.GetFileName(uploadfile.FileName);
var path = Path.Combine(this.Server.MapPath("~/UploadFiles/TB_Room/" + tB_Room.ID), fileName);
var ext = Path.GetExtension(uploadfile.FileName);
//if (!ext.Equals(".jpg") || !ext.Equals(".png") || !ext.Equals(".gif") || !ext.Equals(".jpeg"))
//{
// continue;
//}
if (!new String[] { ".jpg", ".png", ".gif", ".jpeg" }.Contains(ext))
{
continue;
}
// 檔案目錄不存在時，建立目錄
if (!Directory.Exists(this.Server.MapPath("~/Upload/TB_Room/" + tB_Room.ID)))
{
Directory.CreateDirectory(this.Server.MapPath("~/UploadFiles/TB_Room/" + tB_Room.ID));
}
// 檔案存在時，做覆蓋檔案
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
uploadfile.SaveAs(path);
}
}
}
}
catch
{
this.ViewBag.Message = "Upload failed";
}
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="tb_Room"></param>
/// <param name="pager"></param>
/// <returns></returns>
public DataTable GetTable(TB_Room tb_Room, ref Pager pager)
{
return(_mTB_RoomDAL.GetTable(tb_Room, ref pager));
}
