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