public void exportExcel()
{
try
{
string record = this.Request["record"];
pshctvalBll bll = new pshctvalBll();
tpshctcfg cfg = bll.GetSelectedObject <tpshctcfg>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "hccd", ColumnValue = record
}
});
tstdefcfg xdef = bll.GetSelectedObject <tstdefcfg>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "dfnm", ColumnValue = cfg.xdef
}
});
tstdefcfg ydef = bll.GetSelectedObject <tstdefcfg>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "dfnm", ColumnValue = cfg.ydef
}
});
ValueInfoBll dd = new ValueInfoBll();
List <ValueInfo> lstX = typeof(ValueInfoBll).GetMethod(xdef.dasc).Invoke(dd, new object[] { }) as List <ValueInfo>;
List <ValueInfo> lstY = typeof(ValueInfoBll).GetMethod(ydef.dasc).Invoke(dd, new object[] { }) as List <ValueInfo>;
List <List <ColumnInfo> > lstResult = bll.GetHeadCountCfgValue(record, cfg, lstX, lstY);
if (lstResult != null)
{
UtilExcel.ExportToExcel(Response, this.GetType().Name, lstResult);
}
}
catch (Exception ex)
{
string message = "{status:'failure',msg:'" + ExceptionPaser.Parse(HRMSRes.Public_Message_QueryFail, ex, true) + "'}";
Response.Output.Write(message);
}
}
public void Delete()
{
string message = "{}";
try
{
string record = this.Request["record"];
pshctvalBll bll = new pshctvalBll();
bll.Delete(record);
message = "{status:'success',msg:'" + HRMSRes.Public_Message_DeleteWell + "'}";
}
catch (Exception ex)
{
message = "{status:'failure',msg:'" + ExceptionPaser.Parse(HRMSRes.Public_Message_DeleteBad, ex, true) + "'}";
}
Response.Write(message);
}
public void list()
{
string record = this.Request["record"];
pshctvalBll bll = new pshctvalBll();
tpshctcfg cfg = bll.GetSelectedObject <tpshctcfg>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "hccd", ColumnValue = record
}
});
tstdefcfg xdef = bll.GetSelectedObject <tstdefcfg>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "dfnm", ColumnValue = cfg.xdef
}
});
tstdefcfg ydef = bll.GetSelectedObject <tstdefcfg>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "dfnm", ColumnValue = cfg.ydef
}
});
ValueInfoBll dd = new ValueInfoBll();
List <ValueInfo> lstX = typeof(ValueInfoBll).GetMethod(xdef.dasc).Invoke(dd, new object[] { }) as List <ValueInfo>;
List <ValueInfo> lstY = typeof(ValueInfoBll).GetMethod(ydef.dasc).Invoke(dd, new object[] { }) as List <ValueInfo>;
List <List <ColumnInfo> > lstResult = bll.GetHeadCountCfgValue(record, cfg, lstX, lstY);
int total = lstResult.Count;
string json = ConvertToJson(lstResult);
Response.Write("{results:" + total + ",rows:" + json + "}");
//ViewData["hctconfig"] = responseJson(lstResult,lstX,lstY);
}
public void load()
{
string record = this.Request["record"];
pshctvalBll bll = new pshctvalBll();
tpshctcfg cfg = bll.GetSelectedObject <tpshctcfg>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "hccd", ColumnValue = record
}
});
tstdefcfg xdef = bll.GetSelectedObject <tstdefcfg>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "dfnm", ColumnValue = cfg.xdef
}
});
tstdefcfg ydef = bll.GetSelectedObject <tstdefcfg>(new List <ColumnInfo>()
{
new ColumnInfo()
{
ColumnName = "dfnm", ColumnValue = cfg.ydef
}
});
ValueInfoBll dd = new ValueInfoBll();
List <ValueInfo> lstX = typeof(ValueInfoBll).GetMethod(xdef.dasc).Invoke(dd, new object[] { }) as List <ValueInfo>;
List <ValueInfo> lstY = typeof(ValueInfoBll).GetMethod(ydef.dasc).Invoke(dd, new object[] { }) as List <ValueInfo>;
string message = "{status:'success',msg:'" + responseJson(record, lstX, lstY).Replace("'", "\\'") + "'}";
Response.Write(message);
}
public void Edit()
{
string message = "{}";
try
{
string record = this.Request["record"];
Hashtable ht = JavaScriptConvert.DeserializeObject <Hashtable>(record);
List <ColumnInfo> parameters = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(ht["keycolumns"].ToString());
List <CoordinateInfo> listDtl = JavaScriptConvert.DeserializeObject <List <CoordinateInfo> >(ht["dtlparams"].ToString());
pshctvalBll bll = new pshctvalBll();
bll.Update(parameters, listDtl);
message = "{status:'success',msg:'" + HRMSRes.Public_Message_EditWell + "'}";
}
catch (Exception ex)
{
message = "{status:'failure',msg:'" + ExceptionPaser.Parse(HRMSRes.Public_Message_EditBad, ex, true) + "'}";
}
Response.Write(message);
}
