public int Add(t_ES_ElecPrice model)
{
string sql = string.Format(@"INSERT INTO [dbo].[t_ES_ElecPrice]
([IndID]
,[BigIndTypeID]
,[VID]
,[FDRID]
,[PVFID]
,[ElecPrice]
,[WaterConstr]
,[FarmNet]
,[renewable]
,[reservoir]
,[Demand]
,[capacity]
,[UID])
VALUES
({0}
,{1}
,{2}
,{3}
,{4}
,{5}
,{6}
,{7}
,{8}
,{9}
,{10}
,{11}
,{12})", model.indID, model.BigIndTypeID == null ? 0 : model.BigIndTypeID, model.VID, model.FDRID, model.PVFID, model.ElecPrice, model.WaterConstr == null ? 0 : model.WaterConstr, model.FarmNet == null ? 0 : model.FarmNet, model.renewable == null ? 0 : model.renewable, model.reservoir == null ? 0 : model.reservoir, model.Demand == null ? 0 : model.Demand, model.capacity == null ? 0 : model.capacity, model.UID == null ? 0 : model.UID);
return(ExecuteSqlCommand(sql));
}
public int Update(t_ES_ElecPrice model)
{
int n = 0;
try
{
n = _dbFactory.elecPrice.Update(model);
}
catch (Exception ex)
{
throw ex;
}
return(n);
}
public int Update(t_ES_ElecPrice model)
{
string sql = $@"UPDATE [dbo].[t_ES_ElecPrice]
SET [IndID] = {model.indID}
,[BigIndTypeID] = {(model.BigIndTypeID == null ? 0 : model.BigIndTypeID)}
,[VID] = {model.VID}
,[FDRID] = {model.FDRID}
,[PVFID] = {model.PVFID}
,[ElecPrice] = {model.ElecPrice}
,[WaterConstr] = {(model.WaterConstr == null ? 0 : model.WaterConstr)}
,[FarmNet] = {(model.FarmNet == null ? 0 : model.FarmNet)}
,[renewable] = {(model.renewable == null ? 0 : model.renewable)}
,[reservoir] = {(model.reservoir == null ? 0 : model.reservoir)}
,[Demand] = {(model.Demand == null ? 0 : model.Demand)}
,[capacity] = {(model.capacity == null ? 0 : model.capacity)}
,[UID]={(model.UID == null ? 0 : model.UID)}
WHERE id={model.id}";
return(ExecuteSqlCommand(sql));
}
