protected void btnGetFields_Click(object sender, EventArgs e)
{
try
{
int id;
int.TryParse(Request["Iden"], out id);
var dt = QueryHelper.GetScheduleQueryHdr(id);
if (dt != null && dt.Rows.Count > 0)
{
var sql = dt.Rows[0]["sSql"].ToString();
var result = QueryHelper.ExecutePageQuery(sql, new QueryParam() { PageIndex = 1, PageSize = 1 });
if (result.IsSucess && result.Data != null && result.Data.Columns.Count > 0)
{
var table = result.Data;
List<ScheduleQueryFieldInfo> fields = new List<ScheduleQueryFieldInfo>();
foreach (DataColumn item in table.Columns)
{
if (item.ColumnName != "ROWSTAT")
{
var field = new ScheduleQueryFieldInfo();
field.iIden = QueryHelper.NewIden("smScheduleQueryField");
field.iQueryHdrId = id;
field.sFieldName = item.ColumnName;
field.sCaption = item.ColumnName;
field.bShow = true;
field.iWidth = 0;
field.bAllowWarp = true;
field.sHorizontalAlignment = "center";
field.sVerticalAlignment = "middle";
field.iSortIndex = table.Columns.IndexOf(item);
fields.Add(field);
}
}
QueryHelper.AddScheduleQueryField(fields);
GridViewBind();
}
else
{
throw new Exception(result.Message);
}
}
else
{
throw new Exception("未配置子查询!");
}
}
catch (Exception ex)
{
this.hasError = true;
this.errorMsg = ex.Message;
}
}
public static void ModifyScheduleQueryField(ScheduleQueryFieldInfo scheduleQueryFieldInfo)
{
var sql = @"
update smScheduleQueryField
set
sCaption=@sCaption,
bShow=@bShow,
iWidth=@iWidth,
bAllowWarp=@bAllowWarp,
sHorizontalAlignment=@sHorizontalAlignment,
sVerticalAlignment=@sVerticalAlignment,
iSortIndex=@iSortIndex
where iIden=@iIden";
var connectionString = WebConfig.GetConnectionString();
var param = new SqlParameter[8];
param[0] = new SqlParameter("@iIden", scheduleQueryFieldInfo.iIden);
param[1] = new SqlParameter("@sCaption", scheduleQueryFieldInfo.sCaption);
param[2] = new SqlParameter("@bShow", scheduleQueryFieldInfo.bShow) { SqlDbType = SqlDbType.Bit };
param[3] = new SqlParameter("@iWidth", scheduleQueryFieldInfo.iWidth);
param[4] = new SqlParameter("@bAllowWarp", scheduleQueryFieldInfo.bAllowWarp) { SqlDbType = SqlDbType.Bit };
param[5] = new SqlParameter("@sHorizontalAlignment", scheduleQueryFieldInfo.sHorizontalAlignment);
param[6] = new SqlParameter("@sVerticalAlignment", scheduleQueryFieldInfo.sVerticalAlignment);
param[7] = new SqlParameter("@iSortIndex", scheduleQueryFieldInfo.iSortIndex);
SqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, sql, param);
}
protected void GridViewField_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
var obj = new ScheduleQueryFieldInfo();
GridViewRow row = this.GridViewField.Rows[e.RowIndex];
obj.iIden = Convert.ToInt32(this.GridViewField.DataKeys[e.RowIndex].Values[0].ToString());
obj.sCaption = ((TextBox)row.FindControl("txtCaption")).Text.Trim();
obj.bShow = ((CheckBox)row.FindControl("chkShow")).Checked;
obj.iWidth = Convert.ToInt32(((TextBox)row.FindControl("txtWidth")).Text);
obj.bAllowWarp = ((CheckBox)row.FindControl("chkAllowWarp")).Checked;
obj.sHorizontalAlignment = ((DropDownList)row.FindControl("ddlHorizontalAlignment")).SelectedValue;
obj.sVerticalAlignment = ((DropDownList)row.FindControl("ddlVerticalAlignment")).SelectedValue;
obj.iSortIndex = Convert.ToInt32(((TextBox)row.FindControl("txtSortIndex")).Text);
QueryHelper.ModifyScheduleQueryField(obj);
GridViewField.EditIndex = -1;
GridViewBind();
}
catch (Exception ex)
{
this.hasError = true;
this.errorMsg = ex.Message;
}
}