public RoomModel GetRoomByID(string code)
{
SqlParameter param = new SqlParameter("@Code", SqlDbType.VarChar, 9);
param.Value = code;
SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetRoomByID", CommandType.StoredProcedure, param);
dr.Read();
RoomModel room = new RoomModel();
if (dr.HasRows)
{
room.Code = dr[0].ToString();
room.RoomID = dr[1].ToString();
room.State = Convert.ToInt32(dr[2]);
room.PaName = dr[3].ToString();
room.SunnyID = Convert.ToInt32(dr[4]);
room.SunnyName = dr[5].ToString();
room.RoomUseID = Convert.ToInt32(dr[6]);
room.RoomUseName = dr[7].ToString();
room.IndoorID = Convert.ToInt32(dr[8]);
room.IndoorName = dr[9].ToString();
room.RoomFormatID = Convert.ToInt32(dr[10]);
room.RoomFormatName = dr[11].ToString();
room.BuildArea = Convert.ToDouble(dr[12]);
room.UseArea = Convert.ToDouble(dr[13]);
}
dr.Close();
return room;
}
public List<RoomModel> GetAllRoomNotUsed(string code)
{
SqlParameter param = new SqlParameter("@Code", SqlDbType.VarChar, 5);
param.Value = code;
SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetAllRoomNotUsed", CommandType.StoredProcedure, param);
List<RoomModel> list = new List<RoomModel>();
while (dr.Read())
{
RoomModel room = new RoomModel();
room.RoomID = dr[0].ToString();
room.Code = dr[1].ToString();
list.Add(room);
}
dr.Close();
return list;
}
protected void Edit_Click(object sender, EventArgs e)
{
RoomModel room = new RoomModel();
room.Code = Request.QueryString["ID"].ToString();
room.RoomFormatID = Convert.ToInt32(DDLRoomFormat.SelectedValue);
room.SunnyID = Convert.ToInt32(DDLSunny.SelectedValue);
room.RoomUseID = Convert.ToInt32(DDLRoomUse.SelectedValue);
room.IndoorID = Convert.ToInt32(DDLIndoor.SelectedValue);
room.BuildArea = Convert.ToDouble(txtBuildArea.Text.Trim());
room.UseArea = Convert.ToDouble(txtUseArea.Text.Trim());
bool flag = roombll.UpdateRoom(room);
if (flag)
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('修改成功');location.href='RoomInfo.aspx';</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('修改失败');</script>");
}
}
public List<RoomModel> GetAllRoom()
{
SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetAllRoom", CommandType.StoredProcedure);
List<RoomModel> list = new List<RoomModel>();
while (dr.Read())
{
RoomModel room = new RoomModel();
room.Code = dr[0].ToString();
room.RoomID = dr[1].ToString();
room.State = Convert.ToInt32(dr[2]);
room.PaName = dr[3].ToString();
room.SunnyName = dr[4].ToString();
room.RoomUseName = dr[5].ToString();
room.IndoorName = dr[6].ToString();
room.RoomFormatName = dr[7].ToString();
room.BuildArea = Convert.ToDouble(dr[8]);
room.UseArea = Convert.ToDouble(dr[9]);
list.Add(room);
}
dr.Close();
return list;
}
protected void Save_Click(object sender, EventArgs e)
{
string code=DDLPa.SelectedValue;
int cellID = Convert.ToInt32(DDLCell.SelectedValue);
if(cellID<10)
code+="0"+cellID.ToString();
else
code+=cellID.ToString();
if (roombll.CheckRooms(code))
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('单元重复，插入失败');</script>");
}
else
{
int end = Convert.ToInt32(DDLLayerEnd.SelectedValue);
int begin = Convert.ToInt32(DDLLayerBegin.SelectedValue);
RoomModel[] room = new RoomModel[dttable.Rows.Count];
for (int i = begin; i <= end; i++)
{
int count = 0;
for (int j = 1; j <= Convert.ToInt32(txtCount.Text.Trim()); j++)
{
RoomModel roomitems = new RoomModel();
room[count] = roomitems;
room[count].PaID = DDLPa.SelectedValue;
room[count].CellID = cellID;
room[count].SunnyID = Convert.ToInt32(dttable.Rows[count]["SunnyID"]);
room[count].IndoorID = Convert.ToInt32(dttable.Rows[count]["IndoorID"]);
room[count].RoomUseID = Convert.ToInt32(dttable.Rows[count]["RoomUseID"]);
room[count].RoomFormatID = Convert.ToInt32(dttable.Rows[count]["RoomFormatID"]);
room[count].BuildArea = Convert.ToDouble(dttable.Rows[count]["BuildArea"]);
room[count].UseArea = Convert.ToDouble(dttable.Rows[count]["UseArea"]);
string str = DDLPa.SelectedValue;
string strRoomID = txtPrefix.Text.Trim();
if (cellID < 10)
str += "0" + cellID.ToString();
else
str += cellID.ToString();
if (i < 10)
{
str += "0" + i.ToString();
strRoomID += "0" + i.ToString();
}
else
{
str += i.ToString();
strRoomID += i.ToString();
}
if (j < 10)
{
str += "0" + j.ToString();
strRoomID += "0" + j.ToString();
}
else
{
str += j.ToString();
strRoomID += j.ToString();
}
room[count].RoomID = strRoomID;///房间号＝前缀+层号+房间序号
room[count].Code = str;//房间编号＝楼宇号+单元号+层号+房间序号
count++;
}
}
bool flag = roombll.InsertRoom(room);
if (flag)
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加成功');location.href='RoomInfo.aspx';</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加失败');</script>");
}
}
}
//public bool UpdateRoomForSale(string code,int state)
//{
// int result = dal.UpdateRoomForSale(code,state);
// return result == 0 ? false : true;
//}
public bool InsertRoom(RoomModel[] room)
{
int result = dal.InsertRoom(room);
return result == 0 ? false : true;
}
public bool UpdateRoom(RoomModel room)
{
int result = dal.UpdateRoom(room);
return result == 0 ? false : true;
}
//public int UpdateRoomForSale(string code,int state)
//{
// SqlParameter[] param = { new SqlParameter("@Code", SqlDbType.VarChar, 9),new SqlParameter("@State",SqlDbType.SmallInt) };
// param[0].Value = code;
// param[1].Value = state;
// int result = SqlHelp.ExecuteNonQuery("prc_UpdateRoomForSale", CommandType.StoredProcedure, param);
// return result;
//}
public int InsertRoom(RoomModel[] room)
{
string[] commandText = new string[room.Length];
SqlParameter[][] paramArray=new SqlParameter[room.Length][];
for (int i = 0; i < room.Length; i++)
{
RoomModel items = room[i];
SqlParameter[] param = { new SqlParameter("@Code", SqlDbType.VarChar, 9), new SqlParameter("@RoomID", SqlDbType.VarChar, 6),
new SqlParameter("@PaID",SqlDbType.VarChar,3), new SqlParameter("@CellID",SqlDbType.Int),
new SqlParameter("@SunnyID",SqlDbType.Int), new SqlParameter("@IndoorID",SqlDbType.Int),
new SqlParameter("@RoomUseID",SqlDbType.Int), new SqlParameter("@RoomFormatID",SqlDbType.Int),
new SqlParameter("@BuildArea",SqlDbType.Float), new SqlParameter("@UseArea",SqlDbType.Float)
};
param[0].Value = items.Code;
param[1].Value = items.RoomID;
param[2].Value = items.PaID;
param[3].Value = items.CellID;
param[4].Value = items.SunnyID;
param[5].Value = items.IndoorID;
param[6].Value = items.RoomUseID;
param[7].Value = items.RoomFormatID;
param[8].Value = items.BuildArea;
param[9].Value = items.UseArea;
paramArray[i] = param;
commandText[i] = "prc_InsertRoom";
}
int result = SqlHelp.ExecuteNonQueryTransaction(commandText, CommandType.StoredProcedure, paramArray);
return result;
}
public int UpdateRoom(RoomModel room)
{
SqlParameter[] param = { new SqlParameter("@Code", SqlDbType.VarChar, 9), new SqlParameter("@SunnyID",SqlDbType.Int),
new SqlParameter("@IndoorID",SqlDbType.Int), new SqlParameter("@RoomUseID",SqlDbType.Int),
new SqlParameter("@RoomFormatID",SqlDbType.Int), new SqlParameter("@BuildArea",SqlDbType.Float),
new SqlParameter("@UseArea",SqlDbType.Float)
};
param[0].Value = room.Code;
param[1].Value = room.SunnyID;
param[2].Value = room.IndoorID;
param[3].Value = room.RoomUseID;
param[4].Value = room.RoomFormatID;
param[5].Value = room.BuildArea;
param[6].Value = room.UseArea;
int result = SqlHelp.ExecuteNonQuery("prc_UpdateRoom", CommandType.StoredProcedure, param);
return result;
}
public List<RoomModel> GetRoomByCondition(string condition)
{
SqlParameter param = new SqlParameter("@Condition", SqlDbType.VarChar, 255);
param.Value = condition;
SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetRoomByCondition", CommandType.StoredProcedure, param);
List<RoomModel> list = new List<RoomModel>();
while (dr.Read())
{
RoomModel room = new RoomModel();
room.Code = dr[0].ToString();
room.RoomID = dr[1].ToString();
room.State = Convert.ToInt32(dr[2]);
room.PaName = dr[3].ToString();
room.SunnyName = dr[4].ToString();
room.RoomUseName = dr[5].ToString();
room.IndoorName = dr[6].ToString();
room.RoomFormatName = dr[7].ToString();
room.BuildArea = Convert.ToDouble(dr[8]);
room.UseArea = Convert.ToDouble(dr[9]);
list.Add(room);
}
dr.Close();
return list;
}
