We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
BoldSignA modern eSignature application with affordable pricing. Sign up today for unlimited document usage!
Hi.
Every time I update a package, there is a problem and I'm in trouble.
All Syncfusion packages and javascript5.css, ej2.I updated the min.js file to the latest "20.4.0.42".
Since then, the following error has occurred when deleting rows from the tree grid.
//html
@{
var empty = string.Empty;
string sUrl_UC = $"/IDI/TEST_URL?JobNo=SG6472&RevNo=2&sState=S0";
string sCrud_UC = $"/IDI/UC_CRUD?JobNo=SG6472&RevNo=2&sState=U1";
List<object> EQSelToolbarItems = new List<object>();
EQSelToolbarItems.Add("Add");
EQSelToolbarItems.Add("Delete");
EQSelToolbarItems.Add("Update");
EQSelToolbarItems.Add("Cancel");
var DropDownList = new Syncfusion.EJ2.DropDowns.DropDownList() { Change = "ddChange" };
}
<ejs-treegrid id="EqSelTree" height="600" frozenColumns="5" gridLines="Both" rowHeight="30" treeColumnIndex="3" idMapping="EQ_NO" hasChildMapping="IS_PARENT" parentIdMapping='P_EQ_NO' allowTextWrap="true" allowResizing="true" toolbar="EQSelToolbarItems" queryCellInfo="queryCellInfo">
<e-data-manager url="/IDI/TEST_URL" crudUrl="/HvacInform/HD_EQSEL_CRUDURL" adaptor="UrlAdaptor"></e-data-manager>
<e-treegrid-editsettings allowAdding="true" allowEditing="true" allowDeleting="true" mode="Batch" newRowPosition="Child"></e-treegrid-editsettings>
<e-treegrid-textwrapsettings wrapMode="Header"></e-treegrid-textwrapsettings>
<e-treegrid-selectionsettings mode="Row" type="Multiple"></e-treegrid-selectionsettings>
<e-treegrid-columns>
@*<e-treegrid-column type="checkBox" width="40" textAlign="Center"></e-treegrid-column>*@
<e-treegrid-column field="EQ_NO" visible="false" isPrimaryKey="true" defaultValue="@empty"></e-treegrid-column>
<e-treegrid-column field="P_EQ_NO" visible="false" defaultValue="@empty"></e-treegrid-column>
<e-treegrid-column field="IS_PARENT" visible="false" defaultValue="@empty"></e-treegrid-column>
<e-treegrid-column field="EQ_NM" headerText="EQUIP NAME" width="200" defaultValue="@empty" headerTextAlign="Center" textAlign="Left" validationRules="@(new { required = true })" editType="dropdownedit" edit="@(new { create = "create", read = "read", destroy = "destroy", write = "write", @params = DropDownList})"></e-treegrid-column>
<e-treegrid-column field="TAG_NO" id="TAG_NO" headerText="TAG No." width="200" defaultValue="@empty" headerTextAlign="Center" textAlign="Left" validationRules="@(new { required = true })"></e-treegrid-column>
<e-treegrid-column headerText="UNIT Q'TY" headerTextAlign="Center" textAlign="Center"
columns="@(new List<Syncfusion.EJ2.TreeGrid.TreeGridColumn>() {
new Syncfusion.EJ2.TreeGrid.TreeGridColumn { Field ="DTY_QTY" , HeaderText ="DTY", Width ="80", DefaultValue ="", HeaderTextAlign = Syncfusion.EJ2.Grids.TextAlign.Center, TextAlign = Syncfusion.EJ2.Grids.TextAlign.Right},
new Syncfusion.EJ2.TreeGrid.TreeGridColumn { Field ="STB_QTY" , HeaderText ="STB", Width ="80", DefaultValue ="", HeaderTextAlign = Syncfusion.EJ2.Grids.TextAlign.Center, TextAlign = Syncfusion.EJ2.Grids.TextAlign.Right}})">
</e-treegrid-column>
<e-treegrid-column headerText="FAN Q'TY" headerTextAlign="Center" textAlign="Center"
columns="@(new List<Syncfusion.EJ2.TreeGrid.TreeGridColumn>() {
new Syncfusion.EJ2.TreeGrid.TreeGridColumn { Field ="FAN_DTY_QTY" , HeaderText ="DTY", Width ="80", DefaultValue ="", HeaderTextAlign = Syncfusion.EJ2.Grids.TextAlign.Center, TextAlign = Syncfusion.EJ2.Grids.TextAlign.Right},
new Syncfusion.EJ2.TreeGrid.TreeGridColumn { Field ="FAN_STB_QTY" , HeaderText ="STB", Width ="80", DefaultValue ="", HeaderTextAlign = Syncfusion.EJ2.Grids.TextAlign.Center, TextAlign = Syncfusion.EJ2.Grids.TextAlign.Right}})">
</e-treegrid-column>
<e-treegrid-column field="SERVICE" headerText="SERVICE" width="180" headerTextAlign="Center" textAlign="Left" edit="@(new { create = "Serv_Create", read = "Serv_Read", destory = "Serv_Destory", write = "Serv_Write" })"></e-treegrid-column>
<e-treegrid-column field="ESP" headerText="E.S.P (pa) / HEAD (m)" width="80" defaultValue="@empty" headerTextAlign="Center" textAlign="Right"></e-treegrid-column>
<e-treegrid-column field="CHILLED_WATER" headerText="CHILLED WATER ΔT (°C)" width="70" defaultValue="@empty" headerTextAlign="Center" textAlign="Right" format="N1"></e-treegrid-column>
<e-treegrid-column headerText="SYSTEM CAPACITY" headerTextAlign="Center" textAlign="Center"
columns="@(new List<Syncfusion.EJ2.TreeGrid.TreeGridColumn>() {
new Syncfusion.EJ2.TreeGrid.TreeGridColumn { Field ="S_AIR_FLRT" , HeaderText ="AIR FLOW RATE (L/S)", Format="N1" , Width ="80", DefaultValue ="", HeaderTextAlign = Syncfusion.EJ2.Grids.TextAlign.Center, TextAlign = Syncfusion.EJ2.Grids.TextAlign.Right},
new Syncfusion.EJ2.TreeGrid.TreeGridColumn { Field ="S_COOLING_CAPA" , HeaderText ="COOLING CAPA (kW)", Format="N1" , Width ="80", DefaultValue ="", HeaderTextAlign = Syncfusion.EJ2.Grids.TextAlign.Center, TextAlign = Syncfusion.EJ2.Grids.TextAlign.Right},
new Syncfusion.EJ2.TreeGrid.TreeGridColumn { Field ="S_HEATING_CAPA" , HeaderText ="HEATING CAPA (kW)", Format="N1" , Width ="80", DefaultValue ="", HeaderTextAlign = Syncfusion.EJ2.Grids.TextAlign.Center, TextAlign = Syncfusion.EJ2.Grids.TextAlign.Right},
new Syncfusion.EJ2.TreeGrid.TreeGridColumn { Field ="S_HUMIDIFIER_CAPA" , HeaderText ="HUMIDIFIER CAPA (kg/hr)", Format="N1" , Width ="90", DefaultValue ="", HeaderTextAlign = Syncfusion.EJ2.Grids.TextAlign.Center, TextAlign = Syncfusion.EJ2.Grids.TextAlign.Right},
new Syncfusion.EJ2.TreeGrid.TreeGridColumn { Field ="S_CW_FLAT" , HeaderText ="CW FLOW RATE (L/m)", Format="N1" , Width ="80", DefaultValue ="", HeaderTextAlign = Syncfusion.EJ2.Grids.TextAlign.Center, TextAlign = Syncfusion.EJ2.Grids.TextAlign.Right},
new Syncfusion.EJ2.TreeGrid.TreeGridColumn { Field ="S_SS_COIL_LOAD" , HeaderText ="SENSIBLE COOLING LOAD (kW)", Format="N1" , Width ="80", DefaultValue ="", HeaderTextAlign = Syncfusion.EJ2.Grids.TextAlign.Center, TextAlign = Syncfusion.EJ2.Grids.TextAlign.Right}})">
</e-treegrid-column>
<e-treegrid-column headerText="UNIT CAPACITY" headerTextAlign="Center" textAlign="Center"
columns="@(new List<Syncfusion.EJ2.TreeGrid.TreeGridColumn>() {
new Syncfusion.EJ2.TreeGrid.TreeGridColumn { Field ="U_AIR_FLRT" , HeaderText ="AIR FLOW RATE (L/S)", Format="N1" , Width ="80", DefaultValue ="", HeaderTextAlign = Syncfusion.EJ2.Grids.TextAlign.Center, TextAlign = Syncfusion.EJ2.Grids.TextAlign.Right},
new Syncfusion.EJ2.TreeGrid.TreeGridColumn { Field ="U_COOLING_CAPA" , HeaderText ="COOLING CAPA (kW)", Format="N1" , Width ="80", DefaultValue ="", HeaderTextAlign = Syncfusion.EJ2.Grids.TextAlign.Center, TextAlign = Syncfusion.EJ2.Grids.TextAlign.Right},
new Syncfusion.EJ2.TreeGrid.TreeGridColumn { Field ="U_HEATING_CAPA" , HeaderText ="HEATING CAPA (kW)", Format="N1" , Width ="80", DefaultValue ="", HeaderTextAlign = Syncfusion.EJ2.Grids.TextAlign.Center, TextAlign = Syncfusion.EJ2.Grids.TextAlign.Right},
new Syncfusion.EJ2.TreeGrid.TreeGridColumn { Field ="U_HUMIDIFIER_CAPA" , HeaderText ="HUMIDIFIER CAPA (kg/hr)", Format="N1" , Width ="90", DefaultValue ="", HeaderTextAlign = Syncfusion.EJ2.Grids.TextAlign.Center, TextAlign = Syncfusion.EJ2.Grids.TextAlign.Right},
new Syncfusion.EJ2.TreeGrid.TreeGridColumn { Field ="U_CW_FLAT" , HeaderText ="CW FLOW RATE (L/m)", Format="N1" , Width ="80", DefaultValue ="", HeaderTextAlign = Syncfusion.EJ2.Grids.TextAlign.Center, TextAlign = Syncfusion.EJ2.Grids.TextAlign.Right},
new Syncfusion.EJ2.TreeGrid.TreeGridColumn { Field ="U_SS_COIL_LOAD" , HeaderText ="SENSIBLE COOLING LOAD (kW)", Format="N1" , Width ="80", DefaultValue ="", HeaderTextAlign = Syncfusion.EJ2.Grids.TextAlign.Center, TextAlign = Syncfusion.EJ2.Grids.TextAlign.Right}})">
</e-treegrid-column>
<e-treegrid-column field="REMARK" headerText="REMARKS" width="120" defaultValue="@empty" headerTextAlign="Center" textAlign="Center"></e-treegrid-column>
<e-treegrid-column field="ENT_DB" headerText="ENTER DB (°C)" visible="true" width="90" headerTextAlign="Center" defaultValue="@empty" format="N1"></e-treegrid-column>
<e-treegrid-column field="ENT_WB" headerText="ENTER WB (°C)" visible="true" width="90" headerTextAlign="Center" defaultValue="@empty" format="N1"></e-treegrid-column>
<e-treegrid-column field="LEAV_DB" headerText="LEAV.DB (°C)" visible="true" width="90" headerTextAlign="Center" defaultValue="@empty" format="N1"></e-treegrid-column>
<e-treegrid-column field="LEAV_WB" headerText="LEAV.WB (°C)" visible="true" width="90" headerTextAlign="Center" defaultValue="@empty" format="N1"></e-treegrid-column>
<e-treegrid-column field="SA" disableHtmlEncode="false" headerText="S.A(Q<sub>S</sub>,L/S)" visible="true" format="N1" width="80" headerTextAlign="Center" defaultValue="@empty"></e-treegrid-column>
<e-treegrid-column field="RA" disableHtmlEncode="false" headerText="R.A(Q<sub>R</sub>,L/S)" visible="true" format="N1" width="80" headerTextAlign="Center" defaultValue="@empty"></e-treegrid-column>
<e-treegrid-column field="FA" disableHtmlEncode="false" headerText="F.A(Q<sub>F</sub>,L/S)" visible="true" format="N1" width="80" headerTextAlign="Center" defaultValue="@empty"></e-treegrid-column>
<e-treegrid-column field="SENS_HEAT_LOSS" headerText="SENS.HEAT LOSS(W)" width="130" visible="true" format="N1" headerTextAlign="Center" defaultValue="@empty"></e-treegrid-column>
<e-treegrid-column field="RA_TMP" disableHtmlEncode="false" headerText="R.A TMP.(T<sub>R</sub>,℃)" format="N1" visible="true" width="110" headerTextAlign="Center" defaultValue="@empty"></e-treegrid-column>
<e-treegrid-column field="MA_TMP" disableHtmlEncode="false" headerText="M.A TMP.(T<sub>M</sub>,℃)" format="N1" visible="true" width="110" headerTextAlign="Center" defaultValue="@empty"></e-treegrid-column>
<e-treegrid-column field="DISCH_TMP" disableHtmlEncode="false" headerText="DISCH. TMP.(T<sub>D</sub>,℃)" format="N1" visible="true" width="120" headerTextAlign="Center" defaultValue="@empty"></e-treegrid-column>
<e-treegrid-column field="RA_AH" disableHtmlEncode="false" headerText="R.A AH(X<sub>R</sub>,kg/kg)" format="N5" visible="true" width="120" headerTextAlign="Center" defaultValue="@empty"></e-treegrid-column>
<e-treegrid-column field="MA_AH" disableHtmlEncode="false" headerText="M.A AH(X<sub>M</sub>, kg/kg)" format="N5" visible="true" width="130" headerTextAlign="Center" defaultValue="@empty"></e-treegrid-column>
<e-treegrid-column field="MAX_ROOM_AH" disableHtmlEncode="false" headerText="MAX ROOM AH(X<sub>RM</sub>, kg/kg)" format="N5" visible="true" width="180" headerTextAlign="Center" defaultValue="@empty"></e-treegrid-column>
<e-treegrid-column field="MAX_ROOM_TEMP" disableHtmlEncode="false" headerText="MAX ROOM TMP.(T<sub>RM</sub>, ℃)" format="N5" visible="true" width="180" headerTextAlign="Center" defaultValue="@empty"></e-treegrid-column>
</e-treegrid-columns>
</ejs-treegrid>
<script>
function ddChange(args) {
switch (args.value) {
case 'AHU-CW':
customColor = 'aqua';
break
}
changeBackground();
}
function queryCellInfo(args) {
var aa = 0;
var bb = 1;
}
</script>
//controller
public IActionResult TEST_URL([FromBody] DataManagerRequest dm)
{
List<HI_HD_EquipSelectionModel> list = new List<HI_HD_EquipSelectionModel>();
for (int i = 0; i < 5; i++)
{
HI_HD_EquipSelectionModel model = new HI_HD_EquipSelectionModel();
switch(i)
{
case 0:
model.EQ_NO = 169;
model.P_EQ_NO = 0;
model.IS_PARENT = null;
model.EQ_NM = "A";
model.TAG_NO = "11111";
model.DTY_QTY = 1;
model.STB_QTY = 1;
model.FAN_DTY_QTY = 1;
model.FAN_STB_QTY = 1;
model.SERVICE = "SERVICE1";
model.ESP = 10;
model.CHILLED_WATER = 10;
model.S_AIR_FLRT = 10;
model.S_COOLING_CAPA = 10;
model.S_HEATING_CAPA = 10;
model.S_HUMIDIFIER_CAPA = 10;
model.S_CW_FLAT = 10;
model.S_SS_COIL_LOAD = 10;
model.U_AIR_FLRT = 10;
model.U_COOLING_CAPA = 10;
model.U_HEATING_CAPA = 10;
model.U_HUMIDIFIER_CAPA = 10;
model.U_CW_FLAT = 10;
model.U_SS_COIL_LOAD = 10;
break;
case 1:
model.EQ_NO = 170;
model.P_EQ_NO = 0;
model.IS_PARENT = null;
model.EQ_NM = "A";
model.TAG_NO = "11111";
model.DTY_QTY = 1;
model.STB_QTY = 1;
model.FAN_DTY_QTY = 1;
model.FAN_STB_QTY = 1;
model.SERVICE = "SERVICE1";
model.ESP = 10;
model.CHILLED_WATER = 10;
model.S_AIR_FLRT = 10;
model.S_COOLING_CAPA = 10;
model.S_HEATING_CAPA = 10;
model.S_HUMIDIFIER_CAPA = 10;
model.S_CW_FLAT = 10;
model.S_SS_COIL_LOAD = 10;
model.U_AIR_FLRT = 10;
model.U_COOLING_CAPA = 10;
model.U_HEATING_CAPA = 10;
model.U_HUMIDIFIER_CAPA = 10;
model.U_CW_FLAT = 10;
model.U_SS_COIL_LOAD = 10;
break;
case 2:
model.EQ_NO = 171;
model.P_EQ_NO = 0;
model.IS_PARENT = null;
model.EQ_NM = "A";
model.TAG_NO = "11111";
model.DTY_QTY = 1;
model.STB_QTY = 1;
model.FAN_DTY_QTY = 1;
model.FAN_STB_QTY = 1;
model.SERVICE = "SERVICE1";
model.ESP = 10;
model.CHILLED_WATER = 10;
model.S_AIR_FLRT = 10;
model.S_COOLING_CAPA = 10;
model.S_HEATING_CAPA = 10;
model.S_HUMIDIFIER_CAPA = 10;
model.S_CW_FLAT = 10;
model.S_SS_COIL_LOAD = 10;
model.U_AIR_FLRT = 10;
model.U_COOLING_CAPA = 10;
model.U_HEATING_CAPA = 10;
model.U_HUMIDIFIER_CAPA = 10;
model.U_CW_FLAT = 10;
model.U_SS_COIL_LOAD = 10;
break;
case 3:
//model.test1 = "";
//model.test2 = "";
//model.test3 = "";
//model.test4 = "";
//model.test5 = "";
break;
case 4:
//model.BLDG_NO = "A";
//model.BLDG_NM = "B";
//model.VALV_WC = "C";
//model.TANK_WC = "D";
//model.FHPS = "E";
//model.URINAL = "E";
//model.LAVATORY = "E";
//model.SERVICE_SK = "E";
//model.ABLUTION_TAP = "E";
//model.KITCHEN_SK = "E";
//model.DK_FOUNTAIN = "E";
//model.HUMIDIFIER = "E";
//model.E_WASHER = "E";
//model.SHOWER = "E";
//model.TOTAL_FU = "E";
//model.PEAK_FLRT_GPM = "E";
//model.PEAK_FLRT_LPM = "E";
//model.P_SIZE = "E";
//model.NO_OF_OCC = "E";
//model.SUPPLY_WATER = "E";
//model.GALLON = "E";
//model.LITER = "E";
break;
}
list.Add(model);
}
int listCnt = list.Count();
return dm.RequiresCounts ? Json(new { result = list, count = listCnt }) : Json(list);
}
//model
using Newtonsoft.Json.Linq;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
namespace HAP.Models
{
public class HI_HD_EquipSelectionModel
{
#region
public int? EQ_CODE { get; set; }
public string VALUE_STATE { get; set; }
public int SNO { get; set; }
public int? I_IS_PARENT { get; set; }
public bool? IS_PARENT { get; set; }
public int? EQ_NO { get; set; }
public int? P_EQ_NO { get; set; }
public string JOB_NO { get; set; }
public int? REV_NO { get; set; }
public string BLDG_SNO { get; set; }
public string EQ_NM { get; set; }
public string TAG_NO { get; set; }
public string TAG_NO_SPLIT { get; set; }
public int? DTY_QTY { get; set; }
public int? STB_QTY { get; set; }
public int? FAN_DTY_QTY { get; set; }
public int? FAN_STB_QTY { get; set; }
public string SERVICE { get; set; }
public int? ESP { get; set; }
public double? CHILLED_WATER { get; set; }
public double? S_AIR_FLRT { get; set; }
public double? S_COOLING_CAPA { get; set; }
public double? S_HEATING_CAPA { get; set; }
public double? S_HUMIDIFIER_CAPA { get; set; }
public double? S_CW_FLAT { get; set; }
public double? S_SS_COIL_LOAD { get; set; }
public double? U_AIR_FLRT { get; set; }
public double? U_COOLING_CAPA { get; set; }
public double? U_HEATING_CAPA { get; set; }
public double? U_HUMIDIFIER_CAPA { get; set; }
public double? U_CW_FLAT { get; set; }
public double? U_SS_COIL_LOAD { get; set; }
public string REMARK { get; set; }
public double? ENT_DB { get; set; }
public double? ENT_WB { get; set; }
public double? LEAV_DB { get; set; }
public double? LEAV_WB { get; set; }
public double? SA { get; set; }
public double? RA { get; set; }
public double? FA { get; set; }
public double? SENS_HEAT_LOSS { get; set; }
public double? RA_TMP { get; set; }
public double? MA_TMP { get; set; }
public double? DISCH_TMP { get; set; }
public double? RA_WINDB { get; set; }
public double? RA_WINDB_MAX { get; set; }
public double? RA_AH_MAX { get; set; }
public double? SHL_HSLW { get; set; }
public double? RA_AH { get; set; }
public double? MA_AH { get; set; }
public double? MAX_ROOM_AH { get; set; }
public double? MAX_ROOM_TEMP { get; set; }
public string SYS_NO { get; set; }
public string ROOM { get; set; }
#endregion
private static SqlParameter[] SetParameters(HI_HD_EquipSelectionModel model, string sSTATE)
{
SqlParameter[] Params = new SqlParameter[]
{
new SqlParameter("@STATE", sSTATE),
new SqlParameter("@EQ_NO", model.EQ_NO),
new SqlParameter("@EQ_CODE", model.EQ_CODE),
new SqlParameter("@P_EQ_NO", model.P_EQ_NO),
new SqlParameter("@IS_PARENT", model.I_IS_PARENT),
new SqlParameter("@JOB_NO", model.JOB_NO),
new SqlParameter("@REV_NO", model.REV_NO),
new SqlParameter("@BLDG_SNO", model.BLDG_SNO),
new SqlParameter("@EQ_NM", model.EQ_NM),
new SqlParameter("@TAG_NO", model.TAG_NO),
new SqlParameter("@TAG_NO_SPLIT", model.TAG_NO_SPLIT),
new SqlParameter("@DTY_QTY", model.DTY_QTY),
new SqlParameter("@STB_QTY", model.STB_QTY),
new SqlParameter("@FAN_DTY_QTY", model.FAN_DTY_QTY),
new SqlParameter("@FAN_STB_QTY", model.FAN_STB_QTY),
new SqlParameter("@SERVICE", model.SERVICE),
new SqlParameter("@ESP", model.ESP),
new SqlParameter("@CHILLED_WATER", model.CHILLED_WATER),
new SqlParameter("@S_AIR_FLRT", model.S_AIR_FLRT),
new SqlParameter("@S_COOLING_CAPA", model.S_COOLING_CAPA),
new SqlParameter("@S_HEATING_CAPA", model.S_HEATING_CAPA),
new SqlParameter("@S_HUMIDIFIER_CAPA", model.S_HUMIDIFIER_CAPA),
new SqlParameter("@S_CW_FLAT", model.S_CW_FLAT),
new SqlParameter("@S_SS_COIL_LOAD", model.S_SS_COIL_LOAD),
new SqlParameter("@U_AIR_FLRT", model.U_AIR_FLRT),
new SqlParameter("@U_COOLING_CAPA", model.U_COOLING_CAPA),
new SqlParameter("@U_HEATING_CAPA", model.U_HEATING_CAPA),
new SqlParameter("@U_HUMIDIFIER_CAPA", model.U_HUMIDIFIER_CAPA),
new SqlParameter("@U_CW_FLAT", model.U_CW_FLAT),
new SqlParameter("@U_SS_COIL_LOAD", model.U_SS_COIL_LOAD),
new SqlParameter("@REMARK", model.REMARK),
new SqlParameter("@ENT_DB", model.ENT_DB),
new SqlParameter("@ENT_WB", model.ENT_WB),
new SqlParameter("@LEAV_DB", model.LEAV_DB),
new SqlParameter("@LEAV_WB", model.LEAV_WB),
new SqlParameter("@SA", model.SA),
new SqlParameter("@RA", model.RA),
new SqlParameter("@FA", model.FA),
new SqlParameter("@SENS_HEAT_LOSS", model.SENS_HEAT_LOSS),
new SqlParameter("@RA_TMP", model.RA_TMP),
new SqlParameter("@MA_TMP", model.MA_TMP),
new SqlParameter("@DISCH_TMP", model.DISCH_TMP),
new SqlParameter("@RA_AH", model.RA_AH),
new SqlParameter("@MA_AH", model.MA_AH),
new SqlParameter("@MAX_ROOM_AH", model.MAX_ROOM_AH),
new SqlParameter("@MAX_ROOM_TEMP", model.MAX_ROOM_TEMP),
};
return Params;
}
public static List<HI_HD_EquipSelectionModel> GetList(HI_HD_EquipSelectionModel model, string sSTATE)
{
List<HI_HD_EquipSelectionModel> list = new List<HI_HD_EquipSelectionModel>();
SqlParameter[] Params = SetParameters(model, sSTATE);
DataTable dt = DB.ProcCallToDQL("PF_HAP_EQUIP_SELECTION", Params);
if (sSTATE == "S5")
{
int i = 1;
foreach (DataRow row in dt.Rows)
{
list.Add(new HI_HD_EquipSelectionModel
{
SNO = i,
EQ_NO = string.IsNullOrEmpty(row["EQ_NO"].ToString()) ? null : row["EQ_NO"].ToString() == "0" ? null : int.Parse(row["EQ_NO"].ToString()),
EQ_NM = row["EQ_NM"].ToString(),
TAG_NO = row["TAG_NO"].ToString(),
DTY_QTY = string.IsNullOrEmpty(row["DTY_QTY"].ToString()) ? null : row["DTY_QTY"].ToString() == "0" ? null : int.Parse(row["DTY_QTY"].ToString())
});
i++;
}
}
else if (sSTATE == "S6")
{
int i = 1;
foreach (DataRow row in dt.Rows)
{
list.Add(new HI_HD_EquipSelectionModel
{
SNO = i,
EQ_NO = string.IsNullOrEmpty(row["EQ_NO"].ToString()) ? null : row["EQ_NO"].ToString() == "0" ? null : int.Parse(row["EQ_NO"].ToString()),
EQ_NM = row["EQ_NM"].ToString(),
TAG_NO = row["TAG_NO"].ToString(),
DTY_QTY = string.IsNullOrEmpty(row["DTY_QTY"].ToString()) ? null : row["DTY_QTY"].ToString() == "0" ? null : int.Parse(row["DTY_QTY"].ToString()),
U_HEATING_CAPA = string.IsNullOrEmpty(row["U_HEATING_CAPA"].ToString()) ? null : row["U_HEATING_CAPA"].ToString() == "0" ? null : double.Parse(row["U_HEATING_CAPA"].ToString()),
REMARK = row["REMARK"].ToString()
});
i++;
}
}
else if (sSTATE == "S3" || sSTATE == "S4" || sSTATE == "S10")
{
foreach (DataRow row in dt.Rows)
{
list.Add(new HI_HD_EquipSelectionModel
{
RA_WINDB = string.IsNullOrEmpty(row["RA_WINDB"].ToString()) ? 0 : double.Parse(row["RA_WINDB"].ToString()),
RA_WINDB_MAX = string.IsNullOrEmpty(row["RA_WINDB_MAX"].ToString()) ? 0 : double.Parse(row["RA_WINDB_MAX"].ToString()),
RA_AH = string.IsNullOrEmpty(row["RA_AH"].ToString()) ? 0 : double.Parse(row["RA_AH"].ToString()),
RA_AH_MAX = string.IsNullOrEmpty(row["RA_AH_MAX"].ToString()) ? 0 : double.Parse(row["RA_AH_MAX"].ToString()),
SHL_HSLW = string.IsNullOrEmpty(row["SHL_HSLW"].ToString()) ? 0 : double.Parse(row["SHL_HSLW"].ToString())
});
}
}
else
{
foreach (DataRow row in dt.Rows)
{
list.Add(new HI_HD_EquipSelectionModel
{
P_EQ_NO = dt.Columns.Contains("P_EQ_NO") ? (string.IsNullOrEmpty(row["P_EQ_NO"].ToString())) ? null : row["P_EQ_NO"].ToString() == "0" ? null : int.Parse(row["P_EQ_NO"].ToString()) : null,
IS_PARENT = dt.Columns.Contains("IS_PARENT") ? (string.IsNullOrEmpty(row["IS_PARENT"].ToString())) ? null : (row["IS_PARENT"].ToString() == "1") ? true : false : null,
I_IS_PARENT = dt.Columns.Contains("I_IS_PARENT") ? (string.IsNullOrEmpty(row["IS_PARENT"].ToString())) ? null : (row["IS_PARENT"].ToString() == "1") ? 1 : 0 : null,
EQ_CODE = dt.Columns.Contains("EQ_CODE") ? (string.IsNullOrEmpty(row["EQ_CODE"].ToString())) ? null : row["EQ_CODE"].ToString() == "0" ? null : int.Parse(row["EQ_CODE"].ToString()) : null,
JOB_NO = dt.Columns.Contains("JOB_NO") ? row["JOB_NO"].ToString() : null,
BLDG_SNO = dt.Columns.Contains("BLDG_SNO") ? row["BLDG_SNO"].ToString() : null,
EQ_NM = dt.Columns.Contains("EQ_NM") ? row["EQ_NM"].ToString() : null,
TAG_NO = dt.Columns.Contains("TAG_NO") ? row["TAG_NO"].ToString() : null,
SERVICE = dt.Columns.Contains("SERVICE") ? row["SERVICE"].ToString() : null,
REMARK = dt.Columns.Contains("REMARK") ? row["REMARK"].ToString() : null,
FAN_DTY_QTY = dt.Columns.Contains("FAN_DTY_QTY") ? string.IsNullOrEmpty(row["FAN_DTY_QTY"].ToString()) ? null : row["FAN_DTY_QTY"].ToString() == "0" ? null : int.Parse(row["FAN_DTY_QTY"].ToString()) : null,
FAN_STB_QTY = dt.Columns.Contains("FAN_STB_QTY") ? string.IsNullOrEmpty(row["FAN_STB_QTY"].ToString()) ? null : row["FAN_STB_QTY"].ToString() == "0" ? null : int.Parse(row["FAN_STB_QTY"].ToString()) : null,
DTY_QTY = dt.Columns.Contains("DTY_QTY") ? (string.IsNullOrEmpty(row["DTY_QTY"].ToString())) ? null : row["DTY_QTY"].ToString() == "0" ? null : int.Parse(row["DTY_QTY"].ToString()) : null,
EQ_NO = dt.Columns.Contains("EQ_NO") ? (string.IsNullOrEmpty(row["EQ_NO"].ToString())) ? null : row["EQ_NO"].ToString() == "0" ? null : int.Parse(row["EQ_NO"].ToString()) : null,
REV_NO = dt.Columns.Contains("REV_NO") ? (string.IsNullOrEmpty(row["REV_NO"].ToString())) ? null : row["REV_NO"].ToString() == "0" ? null : int.Parse(row["REV_NO"].ToString()) : null,
STB_QTY = dt.Columns.Contains("STB_QTY") ? (string.IsNullOrEmpty(row["STB_QTY"].ToString())) ? null : row["STB_QTY"].ToString() == "0" ? null : int.Parse(row["STB_QTY"].ToString()) : null,
ESP = dt.Columns.Contains("ESP") ? (string.IsNullOrEmpty(row["ESP"].ToString())) ? null : row["ESP"].ToString() == "0" ? null : int.Parse(row["ESP"].ToString()) : null,
CHILLED_WATER = dt.Columns.Contains("CHILLED_WATER") ? (string.IsNullOrEmpty(row["CHILLED_WATER"].ToString())) ? null : row["CHILLED_WATER"].ToString() == "0" ? null : double.Parse(row["CHILLED_WATER"].ToString()) : null,
S_AIR_FLRT = dt.Columns.Contains("S_AIR_FLRT") ? (string.IsNullOrEmpty(row["S_AIR_FLRT"].ToString())) ? null : row["S_AIR_FLRT"].ToString() == "0" ? null : double.Parse(row["S_AIR_FLRT"].ToString()) : null,
S_COOLING_CAPA = dt.Columns.Contains("S_COOLING_CAPA") ? (string.IsNullOrEmpty(row["S_COOLING_CAPA"].ToString())) ? null : row["S_COOLING_CAPA"].ToString() == "0" ? null : double.Parse(row["S_COOLING_CAPA"].ToString()) : null,
S_HEATING_CAPA = dt.Columns.Contains("S_HEATING_CAPA") ? (string.IsNullOrEmpty(row["S_HEATING_CAPA"].ToString())) ? null : row["S_HEATING_CAPA"].ToString() == "0" ? null : double.Parse(row["S_HEATING_CAPA"].ToString()) : null,
S_HUMIDIFIER_CAPA = dt.Columns.Contains("S_HUMIDIFIER_CAPA") ? (string.IsNullOrEmpty(row["S_HUMIDIFIER_CAPA"].ToString())) ? null : row["S_HUMIDIFIER_CAPA"].ToString() == "0" ? null : double.Parse(row["S_HUMIDIFIER_CAPA"].ToString()) : null,
S_CW_FLAT = dt.Columns.Contains("S_CW_FLAT") ? (string.IsNullOrEmpty(row["S_CW_FLAT"].ToString())) ? null : row["S_CW_FLAT"].ToString() == "0" ? null : double.Parse(row["S_CW_FLAT"].ToString()) : null,
S_SS_COIL_LOAD = dt.Columns.Contains("S_SS_COIL_LOAD") ? (string.IsNullOrEmpty(row["S_SS_COIL_LOAD"].ToString())) ? null : row["S_SS_COIL_LOAD"].ToString() == "0" ? null : double.Parse(row["S_SS_COIL_LOAD"].ToString()) : null,
U_AIR_FLRT = dt.Columns.Contains("U_AIR_FLRT") ? (string.IsNullOrEmpty(row["U_AIR_FLRT"].ToString())) ? null : row["U_AIR_FLRT"].ToString() == "0" ? null : double.Parse(row["U_AIR_FLRT"].ToString()) : null,
U_COOLING_CAPA = dt.Columns.Contains("U_COOLING_CAPA") ? (string.IsNullOrEmpty(row["U_COOLING_CAPA"].ToString())) ? null : row["U_COOLING_CAPA"].ToString() == "0" ? null : double.Parse(row["U_COOLING_CAPA"].ToString()) : null,
U_HEATING_CAPA = dt.Columns.Contains("U_HEATING_CAPA") ? (string.IsNullOrEmpty(row["U_HEATING_CAPA"].ToString())) ? null : row["U_HEATING_CAPA"].ToString() == "0" ? null : double.Parse(row["U_HEATING_CAPA"].ToString()) : null,
U_HUMIDIFIER_CAPA = dt.Columns.Contains("U_HUMIDIFIER_CAPA") ? (string.IsNullOrEmpty(row["U_HUMIDIFIER_CAPA"].ToString())) ? null : row["U_HUMIDIFIER_CAPA"].ToString() == "0" ? null : double.Parse(row["U_HUMIDIFIER_CAPA"].ToString()) : null,
U_CW_FLAT = dt.Columns.Contains("U_CW_FLAT") ? (string.IsNullOrEmpty(row["U_CW_FLAT"].ToString())) ? null : row["U_CW_FLAT"].ToString() == "0" ? null : double.Parse(row["U_CW_FLAT"].ToString()) : null,
U_SS_COIL_LOAD = dt.Columns.Contains("U_SS_COIL_LOAD") ? (string.IsNullOrEmpty(row["U_SS_COIL_LOAD"].ToString())) ? null : row["U_SS_COIL_LOAD"].ToString() == "0" ? null : double.Parse(row["U_SS_COIL_LOAD"].ToString()) : null,
ENT_DB = dt.Columns.Contains("ENT_DB") ? (string.IsNullOrEmpty(row["ENT_DB"].ToString())) ? null : row["ENT_DB"].ToString() == "0" ? null : double.Parse(row["ENT_DB"].ToString()) : null,
ENT_WB = dt.Columns.Contains("ENT_WB") ? (string.IsNullOrEmpty(row["ENT_WB"].ToString())) ? null : row["ENT_WB"].ToString() == "0" ? null : double.Parse(row["ENT_WB"].ToString()) : null,
LEAV_DB = dt.Columns.Contains("LEAV_DB") ? (string.IsNullOrEmpty(row["LEAV_DB"].ToString())) ? null : row["LEAV_DB"].ToString() == "0" ? null : double.Parse(row["LEAV_DB"].ToString()) : null,
LEAV_WB = dt.Columns.Contains("LEAV_WB") ? (string.IsNullOrEmpty(row["LEAV_WB"].ToString())) ? null : row["LEAV_WB"].ToString() == "0" ? null : double.Parse(row["LEAV_WB"].ToString()) : null,
SA = dt.Columns.Contains("SA") ? (string.IsNullOrEmpty(row["SA"].ToString())) ? null : row["SA"].ToString() == "0" ? null : double.Parse(row["SA"].ToString()) : null,
RA = dt.Columns.Contains("RA") ? (string.IsNullOrEmpty(row["RA"].ToString())) ? null : row["RA"].ToString() == "0" ? null : double.Parse(row["RA"].ToString()) : null,
FA = dt.Columns.Contains("FA") ? (string.IsNullOrEmpty(row["FA"].ToString())) ? null : row["FA"].ToString() == "0" ? null : double.Parse(row["FA"].ToString()) : null,
SENS_HEAT_LOSS = dt.Columns.Contains("SENS_HEAT_LOSS") ? (string.IsNullOrEmpty(row["SENS_HEAT_LOSS"].ToString())) ? null : row["SENS_HEAT_LOSS"].ToString() == "0" ? null : double.Parse(row["SENS_HEAT_LOSS"].ToString()) : null,
RA_TMP = dt.Columns.Contains("RA_TMP") ? (string.IsNullOrEmpty(row["RA_TMP"].ToString())) ? null : row["RA_TMP"].ToString() == "0" ? null : double.Parse(row["RA_TMP"].ToString()) : null,
MA_TMP = dt.Columns.Contains("MA_TMP") ? (string.IsNullOrEmpty(row["MA_TMP"].ToString())) ? null : row["MA_TMP"].ToString() == "0" ? null : double.Parse(row["MA_TMP"].ToString()) : null,
DISCH_TMP = dt.Columns.Contains("DISCH_TMP") ? (string.IsNullOrEmpty(row["DISCH_TMP"].ToString())) ? null : row["DISCH_TMP"].ToString() == "0" ? null : double.Parse(row["DISCH_TMP"].ToString()) : null,
RA_WINDB = dt.Columns.Contains("RA_WINDB") ? (string.IsNullOrEmpty(row["RA_WINDB"].ToString())) ? null : row["RA_WINDB"].ToString() == "0" ? null : double.Parse(row["RA_WINDB"].ToString()) : null,
RA_WINDB_MAX = dt.Columns.Contains("RA_WINDB_MAX") ? (string.IsNullOrEmpty(row["RA_WINDB_MAX"].ToString())) ? null : row["RA_WINDB_MAX"].ToString() == "0" ? null : double.Parse(row["RA_WINDB_MAX"].ToString()) : null,
RA_AH_MAX = dt.Columns.Contains("RA_AH_MAX") ? (string.IsNullOrEmpty(row["RA_AH_MAX"].ToString())) ? null : row["RA_AH_MAX"].ToString() == "0" ? null : double.Parse(row["RA_AH_MAX"].ToString()) : null,
SHL_HSLW = dt.Columns.Contains("SHL_HSLW") ? (string.IsNullOrEmpty(row["SHL_HSLW"].ToString())) ? null : row["SHL_HSLW"].ToString() == "0" ? null : double.Parse(row["SHL_HSLW"].ToString()) : null,
RA_AH = dt.Columns.Contains("RA_AH") ? (string.IsNullOrEmpty(row["RA_AH"].ToString())) ? null : row["RA_AH"].ToString() == "0" ? null : double.Parse(row["RA_AH"].ToString()) : null,
MA_AH = dt.Columns.Contains("MA_AH") ? (string.IsNullOrEmpty(row["MA_AH"].ToString())) ? null : row["MA_AH"].ToString() == "0" ? null : double.Parse(row["MA_AH"].ToString()) : null,
MAX_ROOM_AH = dt.Columns.Contains("MAX_ROOM_AH") ? (string.IsNullOrEmpty(row["MAX_ROOM_AH"].ToString())) ? null : row["MAX_ROOM_AH"].ToString() == "0" ? null : double.Parse(row["MAX_ROOM_AH"].ToString()) : null,
MAX_ROOM_TEMP = dt.Columns.Contains("MAX_ROOM_TEMP") ? (string.IsNullOrEmpty(row["MAX_ROOM_TEMP"].ToString())) ? null : row["MAX_ROOM_TEMP"].ToString() == "0" ? null : double.Parse(row["MAX_ROOM_TEMP"].ToString()) : null,
});
}
}
return list;
}
//"HVAC DATA" page - SERVICE column Dropdownlist Item Setting
public static List<HI_HD_EquipSelectionModel> GetDropdownItemList(HI_HD_EquipSelectionModel model, string sSTATE)
{
List<HI_HD_EquipSelectionModel> list = new List<HI_HD_EquipSelectionModel>();
SqlParameter[] Params = SetParameters(model, sSTATE);
DataTable dt = DB.ProcCallToDQL("PF_HAP_EQUIP_SELECTION", Params);
if (sSTATE == "S1")
{
foreach (DataRow row in dt.Rows)
{
list.Add(new HI_HD_EquipSelectionModel
{
SYS_NO = string.IsNullOrEmpty(row["SYS_NO"].ToString()) ? null : row["SYS_NO"].ToString()
});
}
}
else
{
foreach (DataRow row in dt.Rows)
{
list.Add(new HI_HD_EquipSelectionModel
{
ROOM = string.IsNullOrEmpty(row["ROOM"].ToString()) ? null : row["ROOM"].ToString()
});
}
}
return list;
}
public static bool SetList(HI_HD_EquipSelectionModel model, string sSTATE)
{
if (model.IS_PARENT == true) model.I_IS_PARENT = 1;
SqlParameter[] Params = SetParameters(model, sSTATE);
bool isSuccess = DB.ProcCallToDML("PF_HAP_EQUIP_SELECTION", Params);
return isSuccess;
}
public static HI_HD_EquipSelectionModel JObjectToModelList(JToken item, string VALUE_STATE)
{
//List<HI_HD_EquipSelectionModel> list = JsonConvert.DeserializeObject<List<HI_HD_EquipSelectionModel>>(item.ToString());
HI_HD_EquipSelectionModel model = new HI_HD_EquipSelectionModel
{
VALUE_STATE = VALUE_STATE,
I_IS_PARENT = string.IsNullOrEmpty(item["IS_PARENT"].ToString()) ? null : item["IS_PARENT"].ToString().ToUpper() == "TRUE" ? 1 : 0,
//IS_PARENT = item["IS_PARENT"] == null ? null : string.IsNullOrEmpty(item["IS_PARENT"].ToString()) ? null : item["IS_PARENT"].ToString() == "True" ? true : false,
JOB_NO = item["JOB_NO"] == null ? null : string.IsNullOrEmpty(item["JOB_NO"].ToString()) ? null : item["JOB_NO"].ToString(),
EQ_NO = item["EQ_NO"] == null ? null : string.IsNullOrEmpty(item["EQ_NO"].ToString()) ? null : int.Parse(item["EQ_NO"].ToString()),
P_EQ_NO = item["P_EQ_NO"] == null ? 0 : string.IsNullOrEmpty(item["P_EQ_NO"].ToString()) ? 0 : int.Parse(item["P_EQ_NO"].ToString()),
REV_NO = item["REV_NO"] == null ? null : string.IsNullOrEmpty(item["REV_NO"].ToString()) ? null : int.Parse(item["REV_NO"].ToString()),
BLDG_SNO = item["BLDG_SNO"] == null ? null : string.IsNullOrEmpty(item["BLDG_SNO"].ToString()) ? null : item["BLDG_SNO"].ToString(),
EQ_NM = item["EQ_NM"] == null ? null : string.IsNullOrEmpty(item["EQ_NM"].ToString()) ? null : item["EQ_NM"].ToString(),
TAG_NO = item["TAG_NO"] == null ? null : string.IsNullOrEmpty(item["TAG_NO"].ToString()) ? null : item["TAG_NO"].ToString(),
EQ_CODE = item["EQ_CODE"] == null ? null : string.IsNullOrEmpty(item["EQ_CODE"].ToString()) ? null : int.Parse(item["EQ_CODE"].ToString()),
DTY_QTY = item["DTY_QTY"] == null ? null : string.IsNullOrEmpty(item["DTY_QTY"].ToString()) ? null : int.Parse(item["DTY_QTY"].ToString()),
STB_QTY = item["STB_QTY"] == null ? null : string.IsNullOrEmpty(item["STB_QTY"].ToString()) ? null : int.Parse(item["STB_QTY"].ToString()),
FAN_DTY_QTY = item["FAN_DTY_QTY"] == null ? null : string.IsNullOrEmpty(item["FAN_DTY_QTY"].ToString()) ? null : int.Parse(item["FAN_DTY_QTY"].ToString()),
FAN_STB_QTY = item["FAN_STB_QTY"] == null ? null : string.IsNullOrEmpty(item["FAN_STB_QTY"].ToString()) ? null : int.Parse(item["FAN_STB_QTY"].ToString()),
SERVICE = item["SERVICE"] == null ? null : string.IsNullOrEmpty(item["SERVICE"].ToString()) ? null : item["SERVICE"].ToString(),
ESP = item["ESP"] == null ? null : string.IsNullOrEmpty(item["ESP"].ToString()) ? null : int.Parse(item["ESP"].ToString()),
CHILLED_WATER = item["CHILLED_WATER"] == null ? null : string.IsNullOrEmpty(item["CHILLED_WATER"].ToString()) ? null : double.Parse(item["CHILLED_WATER"].ToString()),
S_AIR_FLRT = item["S_AIR_FLRT"] == null ? null : string.IsNullOrEmpty(item["S_AIR_FLRT"].ToString()) ? null : double.Parse(item["S_AIR_FLRT"].ToString()),
S_COOLING_CAPA = item["S_COOLING_CAPA"] == null ? null : string.IsNullOrEmpty(item["S_COOLING_CAPA"].ToString()) ? null : double.Parse(item["S_COOLING_CAPA"].ToString()),
S_HEATING_CAPA = item["S_HEATING_CAPA"] == null ? null : string.IsNullOrEmpty(item["S_HEATING_CAPA"].ToString()) ? null : double.Parse(item["S_HEATING_CAPA"].ToString()),
S_HUMIDIFIER_CAPA = item["S_HUMIDIFIER_CAPA"] == null ? null : string.IsNullOrEmpty(item["S_HUMIDIFIER_CAPA"].ToString()) ? null : double.Parse(item["S_HUMIDIFIER_CAPA"].ToString()),
S_CW_FLAT = item["S_CW_FLAT"] == null ? null : string.IsNullOrEmpty(item["S_CW_FLAT"].ToString()) ? null : double.Parse(item["S_CW_FLAT"].ToString()),
S_SS_COIL_LOAD = item["S_SS_COIL_LOAD"] == null ? null : string.IsNullOrEmpty(item["S_SS_COIL_LOAD"].ToString()) ? null : double.Parse(item["S_SS_COIL_LOAD"].ToString()),
U_AIR_FLRT = item["U_AIR_FLRT"] == null ? null : string.IsNullOrEmpty(item["U_AIR_FLRT"].ToString()) ? null : double.Parse(item["U_AIR_FLRT"].ToString()),
U_COOLING_CAPA = item["U_COOLING_CAPA"] == null ? null : string.IsNullOrEmpty(item["U_COOLING_CAPA"].ToString()) ? null : double.Parse(item["U_COOLING_CAPA"].ToString()),
U_HEATING_CAPA = item["U_HEATING_CAPA"] == null ? null : string.IsNullOrEmpty(item["U_HEATING_CAPA"].ToString()) ? null : double.Parse(item["U_HEATING_CAPA"].ToString()),
U_HUMIDIFIER_CAPA = item["U_HUMIDIFIER_CAPA"] == null ? null : string.IsNullOrEmpty(item["U_HUMIDIFIER_CAPA"].ToString()) ? null : double.Parse(item["U_HUMIDIFIER_CAPA"].ToString()),
U_CW_FLAT = item["U_CW_FLAT"] == null ? null : string.IsNullOrEmpty(item["U_CW_FLAT"].ToString()) ? null : double.Parse(item["U_CW_FLAT"].ToString()),
U_SS_COIL_LOAD = item["U_SS_COIL_LOAD"] == null ? null : string.IsNullOrEmpty(item["U_SS_COIL_LOAD"].ToString()) ? null : double.Parse(item["U_SS_COIL_LOAD"].ToString()),
REMARK = item["REMARK"] == null ? null : string.IsNullOrEmpty(item["REMARK"].ToString()) ? null : item["REMARK"].ToString(),
ENT_DB = item["ENT_DB"] == null ? null : string.IsNullOrEmpty(item["ENT_DB"].ToString()) ? null : double.Parse(item["ENT_DB"].ToString()),
ENT_WB = item["ENT_WB"] == null ? null : string.IsNullOrEmpty(item["ENT_WB"].ToString()) ? null : double.Parse(item["ENT_WB"].ToString()),
LEAV_DB = item["LEAV_DB"] == null ? null : string.IsNullOrEmpty(item["LEAV_DB"].ToString()) ? null : double.Parse(item["LEAV_DB"].ToString()),
LEAV_WB = item["LEAV_WB"] == null ? null : string.IsNullOrEmpty(item["LEAV_WB"].ToString()) ? null : double.Parse(item["LEAV_WB"].ToString()),
SA = item["SA"] == null ? null : string.IsNullOrEmpty(item["SA"].ToString()) ? null : double.Parse(item["SA"].ToString()),
RA = item["RA"] == null ? null : string.IsNullOrEmpty(item["RA"].ToString()) ? null : double.Parse(item["RA"].ToString()),
FA = item["FA"] == null ? null : string.IsNullOrEmpty(item["FA"].ToString()) ? null : double.Parse(item["FA"].ToString()),
SENS_HEAT_LOSS = item["SENS_HEAT_LOSS"] == null ? null : string.IsNullOrEmpty(item["SENS_HEAT_LOSS"].ToString()) ? null : double.Parse(item["SENS_HEAT_LOSS"].ToString()),
RA_TMP = item["RA_TMP"] == null ? null : string.IsNullOrEmpty(item["RA_TMP"].ToString()) ? null : double.Parse(item["RA_TMP"].ToString()),
MA_TMP = item["MA_TMP"] == null ? null : string.IsNullOrEmpty(item["MA_TMP"].ToString()) ? null : double.Parse(item["MA_TMP"].ToString()),
DISCH_TMP = item["DISCH_TMP"] == null ? null : string.IsNullOrEmpty(item["DISCH_TMP"].ToString()) ? null : double.Parse(item["DISCH_TMP"].ToString()),
RA_AH = item["RA_AH"] == null ? null : string.IsNullOrEmpty(item["RA_AH"].ToString()) ? null : double.Parse(item["RA_AH"].ToString()),
MA_AH = item["MA_AH"] == null ? null : string.IsNullOrEmpty(item["MA_AH"].ToString()) ? null : double.Parse(item["MA_AH"].ToString()),
MAX_ROOM_AH = item["MAX_ROOM_AH"] == null ? null : string.IsNullOrEmpty(item["MAX_ROOM_AH"].ToString()) ? null : double.Parse(item["MAX_ROOM_AH"].ToString()),
MAX_ROOM_TEMP = item["MAX_ROOM_TEMP"] == null ? null : string.IsNullOrEmpty(item["MAX_ROOM_TEMP"].ToString()) ? null : double.Parse(item["MAX_ROOM_TEMP"].ToString()),
SYS_NO = item["SYS_NO"] == null ? null : string.IsNullOrEmpty(item["SYS_NO"].ToString()) ? null : item["SYS_NO"].ToString(),
ROOM = item["ROOM"] == null ? null : string.IsNullOrEmpty(item["ROOM"].ToString()) ? null : item["ROOM"].ToString()
};
return model;
}
}
}
This problem is a serious one. Please give me a quick answer.
regards.
Hi TaeWook Kang,
Query: following error has occurred when deleting rows from the tree grid.
We checked your issue by preparing a sample with latest version(20.4.42), but we were unable to replicate the issue at our end.
Please refer to the below sample,
https://www.syncfusion.com/downloads/support/directtrac/general/ze/coresample20842518
Please refer to the below video demo,
https://www.syncfusion.com/downloads/support/directtrac/general/ze/DEMO(3~1-1297890599
If you still facing issue after trying the above method, please provide the following information
The requested information will be helpful to proceed further
Regards,
Pon selva
Outgoing mail address
wrsec.73@partner.samsung.com
I sent the error video and sample source attached. Please take care of it quickly as it is urgent.
Regards.
Hi TaeWook Kang,
Query: I sent the error video and sample source attached.
We did not receive any video or samples. Could you please confirm which email address you sent to?. Can you please resend the error video and sample source to the correct email address? Also, can you mention the forum ID in the subject of the email for better tracking?
Hi
I have filled in the form ID.
The mail was sent to "support@syncfusion.com".
Please check quickly.
Hi TaeWook Kang,
We have not received the error video and sample source that you mentioned in your update. Please resend the error video and sample source to Support@syncfusion.com, using the same email address that was used to create the forum, and in the subject line, please include the forum ID for better tracking.
Outgoing mail address
wrsec.73@partner.samsung.com
I am attaching the error occurred video and sample source.
Please check quickly
Regards.
Hi Taewook,
We suspect there is some firewall issue at your end. So, requesting you to create a ticket and attach the video and sample source.
Regards,
Suganya Gopinath.
