/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Jqgrid1_DataRequesting(object sender, Trirand.Web.UI.WebControls.JQGridDataRequestEventArgs e)
{
string ssd = (string)Session["sd_EnvExceptionDailyRpt"];
string sed = (string)Session["ed_EnvExceptionDailyRpt"];
if ((ssd == null) || (sed == null))
{
ssd = sd.Text;
sed = ed.Text;
}
if ((ssd != null) && (sed != null)&&(ssd != "") && (sed != ""))
{
DataSet ds = new DataSet();
try
{
AppSettingsReader asr = new AppSettingsReader();
string dbconn = (string)asr.GetValue("dbconn", typeof(string));
using (SqlConnection conn = new SqlConnection(dbconn))
{
conn.Open();
SqlCommand sqlcomm = new SqlCommand("select * from V_EnvException_DayReport where timestamps<='" + sed + "' and timestamps>='" + ssd + "' order by timestamps desc", conn);
SqlDataAdapter sqladapter = new SqlDataAdapter(sqlcomm);
sqladapter.Fill(ds);
conn.Close();
}
}
catch (Exception)
{
}
Jqgrid1.DataSource = ds.Tables[0];
Jqgrid1.DataBind();
}
}
protected void JqgridCurrency_RowDeleting(object sender, Trirand.Web.UI.WebControls.JQGridRowDeleteEventArgs e)
{
var currencyId = e.RowKey;
if(!string.IsNullOrEmpty(currencyId))
{
CurrencyHelper.DeleteCurrency(Convert.ToInt32(currencyId));
}
}
protected void JqgridNews_RowDeleting(object sender, Trirand.Web.UI.WebControls.JQGridRowDeleteEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var news = dc.News.Single(item => item.newsId == Convert.ToInt32(e.RowKey));
dc.News.DeleteOnSubmit(news);
dc.SubmitChanges();
}
}
protected void JqgridSeason_RowDeleting(object sender, Trirand.Web.UI.WebControls.JQGridRowDeleteEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var season = dc.Seasons.Single(item => item.SeasonId == Convert.ToInt32(e.RowKey));
var seasonGroup = dc.Seasons.Where(item => item.ChampionLeagueSeasonId == Convert.ToInt32(e.RowKey));
dc.Seasons.DeleteOnSubmit(season);
dc.Seasons.DeleteAllOnSubmit(seasonGroup);
dc.SubmitChanges();
}
}
protected void JqgridNews_RowEditing(object sender, Trirand.Web.UI.WebControls.JQGridRowEditEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var news = dc.News.Single(item => item.newsId == Convert.ToInt32(e.RowKey));
news.newsTopic = e.RowData["newsTopic"];
news.newsContent = e.RowData["newsContent"];
news.newsType = Convert.ToInt32(e.RowData["NewsTypeName"]);
dc.SubmitChanges();
}
}
protected void JqgridLeague1_RowEditing(object sender, Trirand.Web.UI.WebControls.JQGridRowEditEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var league = dc.Leagues.Single(item => item.LeagueId == Convert.ToInt32(e.RowKey));
league.LeagueName = e.RowData["LeagueName"];
league.LeagueType = Convert.ToInt32(e.RowData["LeagueTypeName"]);
league.LeagueDesc = e.RowData["LeagueDesc"];
league.Active = Convert.ToInt32(e.RowData["ActiveName"]);
dc.SubmitChanges();
}
}
protected void JqgridNews_RowAdding(object sender, Trirand.Web.UI.WebControls.JQGridRowAddEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var news = new New
{
newsContent = e.RowData["newsContent"],
newsTopic = e.RowData["newsTopic"],
newsType = Convert.ToInt32(e.RowData["NewsTypeName"])
};
dc.News.InsertOnSubmit(news);
dc.SubmitChanges();
}
}
protected void JqgridLeague1_RowAdding(object sender, Trirand.Web.UI.WebControls.JQGridRowAddEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var league = new thaitae.lib.League
{
LeagueName = e.RowData["LeagueName"],
LeagueType = Convert.ToInt32(e.RowData["LeagueTypeName"]),
LeagueDesc = e.RowData["LeagueDesc"],
Active = Convert.ToByte(e.RowData["ActiveName"])
};
dc.Leagues.InsertOnSubmit(league);
dc.SubmitChanges();
}
}
protected void CustomSortingGrid_Sorting(object sender, Trirand.Web.UI.WebControls.JQGridSortEventArgs e)
{
// Cancel the default sorting, which essentially sorts the clicked column
e.Cancel = true;
// Get data from the datasource
DataTable dt = GetData();
// Set sorting to always sort using the ID column
// You can change that using the event arguments e.SortExpression (column name) and
// e.SortDirection (asc / desc)
dt.DefaultView.Sort = "id";
// Rebind the grid using the sorted DataTable
CustomSortingGrid.DataSource = dt;
CustomSortingGrid.DataBind();
}
protected void JqgridSeason_RowEditing(object sender, Trirand.Web.UI.WebControls.JQGridRowEditEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var season = dc.Seasons.Single(item => item.SeasonId == Convert.ToInt32(e.RowKey));
var seasonGroupList = dc.Seasons.Where(item => item.ChampionLeagueSeasonId == Convert.ToInt32(e.RowKey));
season.SeasonName = e.RowData["SeasonName"];
season.SeasonDesc = e.RowData["SeasonDesc"];
foreach (var seasonGroup in seasonGroupList)
{
seasonGroup.SeasonName = e.RowData["SeasonName"];
seasonGroup.SeasonDesc = e.RowData["SeasonDesc"];
}
dc.SubmitChanges();
}
}
protected void JqgridCurrency_RowAdding(object sender, Trirand.Web.UI.WebControls.JQGridRowAddEventArgs e)
{
var status = e.RowData["StatusLabel"];
var isBase = e.RowData["IsBaseLabel"];
var rate = e.RowData["ConversionRate"];
if(!(string.IsNullOrEmpty(status)||string.IsNullOrEmpty(isBase)||string.IsNullOrEmpty(rate)))
{
var currency = new HotelDataEntryLib.Currency()
{
CurrencyName = e.RowData["CurrencyName"],
CurrencyCode = e.RowData["CurrencyCode"],
Status = Convert.ToInt32(status),
ConversionRate = Convert.ToDouble(rate),
IsBase = Convert.ToInt32(isBase)
};
CurrencyHelper.AddCurrency(currency);
}
}
protected void JqgridService_RowAdding(object sender, Trirand.Web.UI.WebControls.JQGridRowAddEventArgs e)
{
var serviceName = e.RowData["ServiceName"];
var url = e.RowData["ServiceUrl"];
var desc = e.RowData["Description"];
var admin = Session["UserSession"].ToString();
if (!(string.IsNullOrEmpty(url) || string.IsNullOrEmpty(serviceName)||string.IsNullOrEmpty(desc)))
{
var service = new DataModelLib.Service()
{
ServiceName = serviceName,
ServiceURL = url,
UpdateUser = admin,
Description = desc
};
ServiceHelper.AddService(service);
}
}
protected void JqgridCompany_RowAdding(object sender, Trirand.Web.UI.WebControls.JQGridRowAddEventArgs e)
{
var status = e.RowData["StatusLabel"];
var currency = e.RowData["CurrencyCode"];
if(!(string.IsNullOrEmpty(status)||string.IsNullOrEmpty(currency)))
{
var property = new HotelDataEntryLib.Property()
{
PropertyCode = e.RowData["PropertyCode"],
PropertyName = e.RowData["PropertyName"],
Status = Convert.ToInt32(status),
UpdateDateTime = DateTime.Now,
CurrencyId = Convert.ToInt32(currency)
};
PropertyHelper.AddProperty(property);
}
}
protected void JqgridSeason_RowAdding(object sender, Trirand.Web.UI.WebControls.JQGridRowAddEventArgs e)
{
if (Session["leagueid"] == null) return;
if (Convert.ToInt32(Session["leagueid"]) == 0) return;
var league = LeagueHelper.GetLeague(Convert.ToInt32(Session["leagueid"]));
using (var dc = ThaitaeDataDataContext.Create())
{
if (league.LeagueType == 1)
{
var season = new thaitae.lib.Season
{
LeagueId = Convert.ToInt32(Session["leagueid"]),
SeasonName = e.RowData["SeasonName"],
SeasonDesc = e.RowData["SeasonDesc"]
};
dc.Seasons.InsertOnSubmit(season);
dc.SubmitChanges();
var leagueList = LeagueHelper.GetChampionsLeagueGroupList();
foreach (var championGroup in leagueList)
{
var seasonGroup = new thaitae.lib.Season
{
LeagueId = championGroup.LeagueId,
SeasonName = e.RowData["SeasonName"],
SeasonDesc = e.RowData["SeasonDesc"],
ChampionLeagueSeasonId = championGroup.LeagueType == 2 ? (int?)null : season.SeasonId
};
dc.Seasons.InsertOnSubmit(seasonGroup);
}
dc.SubmitChanges();
}
else
{
dc.Seasons.InsertOnSubmit(new thaitae.lib.Season
{
LeagueId = Convert.ToInt32(Session["leagueid"]),
SeasonName = e.RowData["SeasonName"],
SeasonDesc = e.RowData["SeasonDesc"]
});
dc.SubmitChanges();
}
}
}
//添加列
protected void Jqgrid1_RowAdding(object sender, Trirand.Web.UI.WebControls.JQGridRowAddEventArgs e)
{
ColumnInfo column = new ColumnInfo();
column .Name = e.RowData["Name"];
column .Typestring = e.RowData["Typestring"];
if (column .Isnullable == "on")
{
column.Isnullable = "null";
}
else
{
column.Isnullable = "not null";
}
manage.CreateObject(getConnInfo(), dbName, tableName, column);
}
protected void JqgridUser_RowEditing(object sender, Trirand.Web.UI.WebControls.JQGridRowEditEventArgs e)
{
var password = e.RowData["Password"];
var username = e.RowData["Username"];
var description = e.RowData["Description"];
var id = e.RowKey;
var admin = Session["UserSession"].ToString();
if (!(string.IsNullOrEmpty(password) || string.IsNullOrEmpty(username)))
{
var user = new DataModelLib.User()
{
UserId = Convert.ToInt32(id),
Username = username,
Password = password,
Description = description,
UpdateUser = admin
};
UserHelper.UpdateUser(user);
}
}
protected void JqgridUser_RowAdding(object sender, Trirand.Web.UI.WebControls.JQGridRowAddEventArgs e)
{
var password = e.RowData["Password"];
var username = e.RowData["Username"];
var description = e.RowData["Description"];
var admin = Session["UserSession"].ToString();
if (!(string.IsNullOrEmpty(password) || string.IsNullOrEmpty(username)))
{
var user = new DataModelLib.User()
{
Username = username,
Password = password,
Description = description,
UpdateUser = admin
};
if (UserHelper.IsUserExist(user.Username)) return;
UserHelper.AddUser(user);
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Jqgrid1_DataRequesting(object sender, Trirand.Web.UI.WebControls.JQGridDataRequestEventArgs e)
{
string ssd = (string)Session["sd_ExceptionDailyInfo"];
string sed = (string)Session["ed_ExceptionDailyInfo"];
if ((ssd == null) || (sed == null))
{
ssd = sd.Text;
sed = ed.Text;
}
if ((ssd != null) && (sed != null) && (ssd != "") && (sed != ""))
{
DataSet ds;
try
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from V_abnormal_valid_load t where ");
sb.Append("t.timestamps < '" + sed + "' and ");
sb.Append("t.timestamps >= '" + ssd + "' order by t.timestamps,t.pointid");
Database db = DatabaseFactory.CreateDatabase("dbconn");
System.Data.Common.DbCommand dbc = db.GetSqlStringCommand(sb.ToString());
ds = db.ExecuteDataSet(dbc);
}
catch (Exception ex)
{
ds = null;
}
#region
//if (!CheckBox_validvalue.Checked)
//{
// Jqgrid1.Columns[5].Width = 0;
//}
//if (!CheckBox_load.Checked)
//{
// Jqgrid1.Columns[6].Visible = false;
//}
#endregion
Jqgrid1.DataSource = ds.Tables[0];
Jqgrid1.DataBind();
Session["gridFilterPageState_exceptioninfo"] = Jqgrid1.GetState();
}
}
protected void JqgridUserService_RowAdding(object sender, Trirand.Web.UI.WebControls.JQGridRowAddEventArgs e)
{
var user = e.RowData["Username"];
var service = e.RowData["Description"];
var ips = e.RowData["Ips"];
var status = e.RowData["StatusLabel"];
var admin = Session["UserSession"].ToString();
if (!(string.IsNullOrEmpty(user) || string.IsNullOrEmpty(status) || string.IsNullOrEmpty(service)))
{
var userService = new DataModelLib.UserService()
{
UserId = Convert.ToInt32(user),
ServiceId = Convert.ToInt32(service),
Ips = ips,
Status = Convert.ToInt32(status),
UpdateUser = admin
};
UserServiceHelper.AddUserService(userService);
}
}
//编辑列
protected void Jqgrid1_RowEditing(object sender, Trirand.Web.UI.WebControls.JQGridRowEditEventArgs e)
{
ColumnInfo column = new ColumnInfo();
column.Name = e.RowData["Name"];
column.Typestring = e.RowData["Typestring"];
if (e.RowData["Isnullable"] == "on")
{
column.Isnullable = "null";
}
else {
column.Isnullable = "not null";
}
//若修改了列名
if (e.RowKey != e.RowData["Name"].ToString ()) {
manage.RenameObject(getConnInfo(), e.RowKey, e.RowData["Name"], dbName, tableName);
}
manage.UpdateColumn(getConnInfo(), dbName, tableName, column);
}
protected void JqgridLeague1_RowDeleting(object sender, Trirand.Web.UI.WebControls.JQGridRowDeleteEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
Session.Remove("leagueid");
var league = dc.Leagues.Single(item => item.LeagueId == Convert.ToInt32(e.RowKey));
dc.Leagues.DeleteOnSubmit(league);
var seasonList = dc.Seasons.Where(item => item.LeagueId == league.LeagueId).ToList();
dc.Seasons.DeleteAllOnSubmit(seasonList);
foreach (var season in seasonList)
{
var teamSeasonList = dc.TeamSeasons.Where(item => item.SeasonId == season.SeasonId).ToList();
dc.TeamSeasons.DeleteAllOnSubmit(teamSeasonList);
var matchList = dc.Matches.Where(item => item.SeasonId == season.SeasonId).ToList();
dc.Matches.DeleteAllOnSubmit(matchList);
foreach (var match in matchList)
{
var teamMatchList = dc.TeamMatches.Where(item => item.MatchId == match.MatchId).ToList();
dc.TeamMatches.DeleteAllOnSubmit(teamMatchList);
var playerMatchList = dc.PlayerMatches.Where(item => item.MatchId == match.MatchId).ToList();
dc.PlayerMatches.DeleteAllOnSubmit(playerMatchList);
foreach (var playerMatch in playerMatchList)
{
var playerList = dc.Players.Where(item => item.PlayerId == playerMatch.PlayerId).ToList();
dc.Players.DeleteAllOnSubmit(playerList);
}
}
foreach (var teamSeason in teamSeasonList)
{
var teamList = dc.Teams.Where(item => item.TeamId == teamSeason.TeamId).ToList();
dc.Teams.DeleteAllOnSubmit(teamList);
}
}
dc.SubmitChanges();
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Jqgrid3_DataRequesting(object sender, Trirand.Web.UI.WebControls.JQGridDataRequestEventArgs e)
{
DataSet ds = null;
try
{
long envirid = long.Parse(e.ParentRowKey.Split('_')[0]);
int typeid = int.Parse(e.ParentRowKey.Split('_')[1]);
StringBuilder sb = new StringBuilder();
sb.Append("select * from V_Exception_Rulelog_Type t where ");
sb.Append("t.envir_id = " + envirid + " and ");
sb.Append("t.typeid = " + typeid + " and t.isshowed = 1");
Database db = DatabaseFactory.CreateDatabase("dbconn");
System.Data.Common.DbCommand dbc = db.GetSqlStringCommand(sb.ToString());
ds = db.ExecuteDataSet(dbc);
}
catch(Exception ex)
{
ds = null;
}
finally
{
if (ds != null)
{
Jqgrid3.DataSource = ds.Tables[0];
Jqgrid3.DataBind();
}
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Jqgrid2_DataRequesting(object sender, Trirand.Web.UI.WebControls.JQGridDataRequestEventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.Add("id");
dt.Columns.Add("groupname");
dt.Columns.Add("rcount");
try
{
Database db = DatabaseFactory.CreateDatabase("dbconn");
StringBuilder sb = new StringBuilder();
for (int i = 1; i <= 16; i++)
{
string groupname = GetTypeNameById(i);
sb.Clear();
sb.Append("select count(*) from envirexception_rulelog_match t where t.isshowed = 1 and t.envir_id = ");
sb.Append(e.ParentRowKey + " and t.typeid = ");
sb.Append(i.ToString());
System.Data.Common.DbCommand dbc = db.GetSqlStringCommand(sb.ToString());
int count = (int)db.ExecuteScalar(dbc);
if (count > 0)
{
DataRow dr = dt.NewRow();
dr["id"] = e.ParentRowKey + "_" + i.ToString();
dr["groupname"] = groupname;
dr["rcount"] = count;
dt.Rows.Add(dr);
}
}
}
catch(Exception ex)
{
dt = null;
}
finally
{
Jqgrid2.DataSource = dt;
Jqgrid2.DataBind();
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Jqgrid1_RowEditing(object sender, Trirand.Web.UI.WebControls.JQGridRowEditEventArgs e)
{
try
{
//modified 2015/04/23
string lockedstatus = e.RowData["lockedstatustext"];
string typeid = e.RowData["groupname"];
StringBuilder sb = new StringBuilder();
sb.Append("select count(*) from exceptiondata_group t where t.envir_id = " + e.RowKey);
Database db = DatabaseFactory.CreateDatabase("dbconn");
System.Data.Common.DbCommand dbc = db.GetSqlStringCommand(sb.ToString());
int rcount = (int)db.ExecuteScalar(dbc);
//modified 20150917
string typecontent = e.RowData["typecontent"];
if (typecontent == null)
{
typecontent = "";
}
if (rcount > 0)
{
StringBuilder sb2 = new StringBuilder();
sb2.Append("update exceptiondata_group set typeid = " + typeid + ", typecontent='" + typecontent + "', locked=" + lockedstatus + ", mconfirm = 0 where envir_id = " + e.RowKey);
System.Data.Common.DbCommand dbc2 = db.GetSqlStringCommand(sb2.ToString());
db.ExecuteNonQuery(dbc2);
}
else
{
StringBuilder sb2 = new StringBuilder();
sb2.Append("insert into exceptiondata_group(envir_id,typeid,typecontent,mconfirm,locked) values(");
sb2.Append(e.RowKey);
sb2.Append(",");
sb2.Append(typeid);
sb2.Append(",'");
sb2.Append(typecontent);
sb2.Append("',0," + lockedstatus + ")");
System.Data.Common.DbCommand dbc2 = db.GetSqlStringCommand(sb2.ToString());
db.ExecuteNonQuery(dbc2);
}
}
catch (Exception ex)
{
}
finally
{
//
}
}
/// <summary>
/// edit
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Jqgrid1_RowEditing(object sender, Trirand.Web.UI.WebControls.JQGridRowEditEventArgs e)
{
try
{
//get confirmed group text and validated group text
string cg = e.RowData["confirmedgroup"];
//string vg = e.RowData["validatedgroup"];
string cgt = GroupType_ddl.Items.FindByValue(cg).Text;
//string vgt = GroupType_ddl.Items.FindByValue(vg).Text;
string dis = e.RowData["alarmdis"];
//get group status
string gs = e.RowData["groupstatus"];
//get row key
string id = e.RowKey;
StringBuilder sb = new StringBuilder();
sb.Append("update t_rulelogs set confirmedgroup = '" + cgt + "', validatedgroup='" + cgt + "', groupstatus=" + gs + ", alarmdis='" + dis + "', confirmeduser='******', validateduser='******', confirmedtime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "', validatedtime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where id = " + id);
Database db = DatabaseFactory.CreateDatabase("dbconn");
System.Data.Common.DbCommand dbc = db.GetSqlStringCommand(sb.ToString());
db.ExecuteNonQuery(dbc);
}
catch (Exception ex)
{
}
finally
{
//string a = "s";
}
}
/// <summary>
/// delete
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Jqgrid1_RowDeleting(object sender, Trirand.Web.UI.WebControls.JQGridRowDeleteEventArgs e)
{
try
{
string id = e.RowKey;
StringBuilder sb = new StringBuilder();
sb.Append("delete from t_rulelogs where id = " + id);
Database db = DatabaseFactory.CreateDatabase("dbconn");
System.Data.Common.DbCommand dbc = db.GetSqlStringCommand(sb.ToString());
db.ExecuteNonQuery(dbc);
}
catch (Exception ex)
{
}
}
/// <summary>
/// add
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Jqgrid1_RowAdding(object sender, Trirand.Web.UI.WebControls.JQGridRowAddEventArgs e)
{
try
{
string rn = e.RowData["rulename"];
string tl = e.RowData["timelog"];
string ad = e.RowData["alarmdis"];
string ct = e.RowData["cemstype"];
string cg = e.RowData["confirmedgroup"];
//string vg = e.RowData["validatedgroup"];
string gs = e.RowData["groupstatus"];
string cgt = GroupType_ddl.Items.FindByValue(cg).Text;
//string vgt = GroupType_ddl.Items.FindByValue(vg).Text;
StringBuilder sb = new StringBuilder();
sb.Append("insert into t_rulelogs(rulename,timelog,alarmdis,cemstype,confirmedgroup,validatedgroup,groupstatus,confirmeduser,validateduser,edittime,confirmedtime,validatedtime) values('");
sb.Append(rn);
sb.Append("','");
sb.Append(tl);
sb.Append("','");
sb.Append(ad);
sb.Append("','");
sb.Append(ct);
sb.Append("','");
sb.Append(cgt);
sb.Append("','");
sb.Append(cgt);
sb.Append("',");
sb.Append(gs);
sb.Append(",'单元长','专工','");
sb.Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
sb.Append("','");
sb.Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
sb.Append("','");
sb.Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
sb.Append("')");
Database db = DatabaseFactory.CreateDatabase("dbconn");
System.Data.Common.DbCommand dbc = db.GetSqlStringCommand(sb.ToString());
db.ExecuteNonQuery(dbc);
}
catch (Exception ex)
{
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Jqgrid1_DataRequesting(object sender, Trirand.Web.UI.WebControls.JQGridDataRequestEventArgs e)
{
string ssd = (string)Session["sd_GroupRuleLogInfo_1"];
string sed = (string)Session["ed_GroupRuleLogInfo_1"];
string machineid = (string)Session["machineid_GroupRuleLogInfo_1"];
if ((ssd == null) || (sed == null) || (machineid == null))
{
ssd = sd.Text;
sed = ed.Text;
machineid = machine.SelectedItem.Value;
}
if ((ssd != null) && (sed != null) && (ssd != "") && (sed != ""))
{
DataSet ds;
try
{
StringBuilder sb = new StringBuilder();
sb.Append("select t.id,iif(s.description is null,t.rulename,s.description) as rulename,t.alarmlog,t.timelog,t.timelogend,t.alarmdis,t.cemstype,iif(t.confirmedgroup is null, t.alarmlog,t.confirmedgroup) as confirmedgroup,iif(t.validatedgroup is null,iif(t.confirmedgroup is null, t.alarmlog,t.confirmedgroup),t.validatedgroup) as validatedgroup ,iif(k.statusname is null,'未确认',k.statusname) as groupstatus,s.machineid from t_RulelogS t left join Point_Machine_Map s on t.RuleName = s.pointname left join grouprulestatus k on t.groupstatus=k.id where ");
sb.Append("t.timelog <= '" + sed + "' and ");
sb.Append("t.timelog >= '" + ssd + "' and (s.machineid=1 or s.machineid=2) and s.machineid="+machineid+" and t.cemstype='SCR' order by t.timelog");
Database db = DatabaseFactory.CreateDatabase("dbconn");
System.Data.Common.DbCommand dbc = db.GetSqlStringCommand(sb.ToString());
ds = db.ExecuteDataSet(dbc);
}
catch (Exception ex)
{
ds = null;
}
#region
//if (!CheckBox_validvalue.Checked)
//{
// Jqgrid1.Columns[5].Width = 0;
//}
//if (!CheckBox_load.Checked)
//{
// Jqgrid1.Columns[6].Visible = false;
//}
#endregion
Jqgrid1.DataSource = ds.Tables[0];
Jqgrid1.DataBind();
//Session["gridFilterPageState_exceptioninfo"] = Jqgrid1.GetState();
}
}
/// <summary>
/// cell binding
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Jqgrid1_CellBinding(object sender, Trirand.Web.UI.WebControls.JQGridCellBindEventArgs e)
{
string editLink = "<a onclick='javascript:jQuery(\"#{0}\").editRow(\"{1}\")' href=\"#\"><span class=\"str\">编辑</span></a>";
string saveLink = "<a onclick='javascript:jQuery(\"#{0}\").saveRow(\"{1}\")' href=\"#\"><span class=\"str\">保存</span></a>";
string cancelLink = "<a onclick='javascript:jQuery(\"#{0}\").restoreRow(\"{1}\")' href=\"#\"><span class=\"str\">取消</span></a>";
if (e.RowValues[9].ToString() != "已审核")
{
if (e.ColumnIndex == 11) // edit
{
e.CellHtml = String.Format(editLink, Jqgrid1.ClientID, e.RowKey);
}
if (e.ColumnIndex == 12) // save
{
e.CellHtml = String.Format(saveLink, Jqgrid1.ClientID, e.RowKey);
}
if (e.ColumnIndex == 13) // cancel
{
e.CellHtml = String.Format(cancelLink, Jqgrid1.ClientID, e.RowKey);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Jqgrid1_DataRequesting(object sender, Trirand.Web.UI.WebControls.JQGridDataRequestEventArgs e)
{
string ssd = (string)Session["sd_PiDasComparisions"];
string sed = (string)Session["ed_PiDasComparisions"];
string sit = (string)Session["item_PiDasComparisions"];
string machineid = (string)Session["machine_PiDasComparisions"];
if ((ssd == null) || (sed == null) || (sit == null) || (machineid == null))
{
ssd = sd.Text;
sed = ed.Text;
sit = ItemType.SelectedItem.Text;
machineid = machine.SelectedItem.Value;
}
if ((ssd != null) && (sed != null) && (ssd != "") && (sed != ""))
{
DataSet ds = null;
try
{
if (sit == "NOX")
{
StringBuilder sb = new StringBuilder();
//iif(2<1,iif(0=0,'0',iif(1=1,1,2)),iif(0=0,'0',iif(1=1,3,4)))
sb.Append("select convert(varchar,timestamps,112)+substring(convert(varchar,timestamps,108),1,2)+'NOX'+convert(varchar,pointid) as id, t.timestamps,'NOX' as item,vnox as vpi,vnox_pi as vdas,pointid,iif(vnox>=vnox_pi,iif(vnox_pi=0,'',iif(abs((vnox-vnox_pi)/vnox_pi)>=0.2,'偏差过大','')),iif(vnox_pi=0,'',iif(abs((vnox-vnox_pi)/vnox_pi)>=0.1,'偏差过大',''))) as diffstatus from V_DAS_PI_HourAverage_Combined3 t where ds='PI' and ");
sb.Append("t.timestamps <= '" + sed + "' and ");
sb.Append("t.timestamps >= '" + ssd + "' and t.pointid=" + machineid + " order by t.timestamps desc,t.pointid asc");
Database db = DatabaseFactory.CreateDatabase("dbconn");
System.Data.Common.DbCommand dbc = db.GetSqlStringCommand(sb.ToString());
//dbc.CommandTimeout = 100000;
ds = db.ExecuteDataSet(dbc);
}
else if (sit == "SO2")
{
StringBuilder sb = new StringBuilder();
sb.Append("select convert(varchar,timestamps,112)+substring(convert(varchar,timestamps,108),1,2)+'SO2'+convert(varchar,pointid) as id,t.timestamps,'SO2' as item,vso2 as vpi,vso2_pi as vdas,pointid,iif(vso2>=vso2_pi,iif(vso2_pi=0,'',iif(abs((vso2-vso2_pi)/vso2_pi)>=0.2,'偏差过大','')),iif(vso2_pi=0,'',iif(abs((vso2-vso2_pi)/vso2_pi)>=0.1,'偏差过大',''))) as diffstatus from V_DAS_PI_HourAverage_Combined3 t where ds='PI' and ");
sb.Append("t.timestamps <= '" + sed + "' and ");
sb.Append("t.timestamps >= '" + ssd + "' and t.pointid=" + machineid + " order by t.timestamps desc,t.pointid asc");
Database db = DatabaseFactory.CreateDatabase("dbconn");
System.Data.Common.DbCommand dbc = db.GetSqlStringCommand(sb.ToString());
//dbc.CommandTimeout = 100000;
ds = db.ExecuteDataSet(dbc);
}
else if (sit == "DUST")
{
StringBuilder sb = new StringBuilder();
sb.Append("select convert(varchar,timestamps,112)+substring(convert(varchar,timestamps,108),1,2)+'DUST'+convert(varchar,pointid) as id, t.timestamps,'DUST' as item,vdust as vpi,vdust_pi as vdas,pointid,iif(vdust>=vdust_pi,iif(vdust_pi=0,'',iif(abs((vdust-vdust_pi)/vdust_pi)>=0.2,'偏差过大','')),iif(vdust_pi=0,'',iif(abs((vdust-vdust_pi)/vdust_pi)>=0.1,'偏差过大',''))) as diffstatus from V_DAS_PI_HourAverage_Combined3 t where ds='PI' and ");
sb.Append("t.timestamps <= '" + sed + "' and ");
sb.Append("t.timestamps >= '" + ssd + "' and t.pointid=" + machineid + " order by t.timestamps desc,t.pointid asc");
Database db = DatabaseFactory.CreateDatabase("dbconn");
System.Data.Common.DbCommand dbc = db.GetSqlStringCommand(sb.ToString());
//dbc.CommandTimeout = 100000;
ds = db.ExecuteDataSet(dbc);
}
}
catch (Exception ex)
{
ds = null;
}
#region
//if (!CheckBox_validvalue.Checked)
//{
// Jqgrid1.Columns[5].Width = 0;
//}
//if (!CheckBox_load.Checked)
//{
// Jqgrid1.Columns[6].Visible = false;
//}
#endregion
Jqgrid1.DataSource = ds.Tables[0];
Jqgrid1.DataBind();
//Session["gridFilterPageState_exceptioninfo"] = Jqgrid1.GetState();
}
}
