public ActionResult WriteBackResult(WriteBackResultQueryForm form, EasyUIGridSetting gridSetting)
{
FCWebserviceBll bll = new FCWebserviceBll();
EasyUIGridModel result = bll.GetWriteBackResult(form, gridSetting);
return(Content(result.ToJson(), "application/json"));
}
public EasyUIGridModel GetWBInfoResult(WBQueryForm form)
{
//string cfwbService = ConfigurationManager.AppSettings["FWCFAddress"].ToString();
BDCSrvSoap soap = new BDCSrvSoapClient();
DataSet ds = soap.SPF_WFZMCX(form.QLRXM, form.ZJHM, form.Address);
IList <WBInfo> wbinfos = new List <WBInfo>();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
WBInfo w = new WBInfo();
w.HouseID = ds.Tables[0].Rows[i]["HouseID"].ToString();
w.BuildingID = ds.Tables[0].Rows[i]["BuildingID"].ToString();
w.ZL = ds.Tables[0].Rows[i]["ZL"].ToString();
w.QLRMC = ds.Tables[0].Rows[i]["QLRMC"].ToString();
w.ZJHM = ds.Tables[0].Rows[i]["ZJHM"].ToString();
w.JZMJ = Convert.ToDouble(ds.Tables[0].Rows[i]["JZMJ"]);
w.ContractNO = ds.Tables[0].Rows[i]["ContractNO"].ToString();
w.SignDate = Convert.ToDateTime(ds.Tables[0].Rows[i]["SignDate"]);
wbinfos.Add(w);
}
}
EasyUIGridModel ret = new EasyUIGridModel(0, wbinfos.Count, wbinfos);
return(ret);
}
public virtual LJsonResult EasyUIAjaxGetPage(int?page, int?rows)
{
/*
* 1、easyui-datagrid 分页接收参数
* page 接受客户端的页码，对应的就是用户选择或输入的pageNumber（按照上图的例子，用户点了下一页，传到服务器端就是2）
* rows 接受客户端的每页记录数，对应的就是pageSize （用户在下拉列表选择每页显示30条记录，传到服务器就是30）
*/
if (!page.HasValue)
{
page = 1;
}
if (!rows.HasValue)
{
rows = 10;
}
int pageNumber = page.Value;
int pageSize = rows.Value;
var modelList = this.Repository <TAggregateRoot>().FindAll(p => p.ID, SortOrder.Descending, pageNumber, pageSize);
var gridModel = new EasyUIGridModel <TAggregateRoot>();
if (modelList != null)
{
gridModel.total = modelList.Count;
gridModel.rows = modelList.Data.ToList <TAggregateRoot>();
}
var json = new LJsonResult();
json.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
json.Data = gridModel;
return(json);
}
/// <summary>
/// 根据
/// </summary>
/// <param name="HouseIds"></param>
/// <returns></returns>
public EasyUIGridModel GetWBInfoByHouseIds(IList <string> HouseIds)
{
if (HouseIds.Count > 0)
{
BDCSrvSoap soap = new BDCSrvSoapClient();
IList <WBInfoForAHouse> wbinfos = new List <WBInfoForAHouse>();
foreach (string hid in HouseIds)
{
string paramstring = "HouseID=" + hid;
DataSet ds = soap.SPF_FC_FWQK(paramstring);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
WBInfoForAHouse w = new WBInfoForAHouse();
w.HID = ds.Tables[0].Rows[0]["HID"].ToString();
w.XMMC = ds.Tables[0].Rows[0]["XMMC"].ToString();
w.LPMC = ds.Tables[0].Rows[0]["LPMC"].ToString();
w.DYH = ds.Tables[0].Rows[0]["DYH"].ToString();
w.FJH = ds.Tables[0].Rows[0]["FJH"].ToString();
w.JZMJ = ds.Tables[0].Rows[0]["JZMJ"].ToString();
w.FWZT = ds.Tables[0].Rows[0]["FWZT"].ToString();
w.CFZT = ds.Tables[0].Rows[0]["CFZT"].ToString();
w.DYZT = ds.Tables[0].Rows[0]["DYZT"].ToString();
w.ZXZT = ds.Tables[0].Rows[0]["ZXZT"].ToString();
if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
{
w.MCList = new List <string>();
w.ZJLXList = new List <string>();
w.ZJHMList = new List <string>();
w.LXDHList = new List <string>();
w.LXDZList = new List <string>();
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
w.MCList.Add(ds.Tables[1].Rows[i]["MC"].ToString());
w.ZJLXList.Add(ds.Tables[1].Rows[i]["ZJLX"].ToString());
w.ZJHMList.Add(ds.Tables[1].Rows[i]["ZJHM"].ToString());
w.LXDZList.Add(ds.Tables[1].Rows[i]["LXDZ"].ToString());
}
}
wbinfos.Add(w);
}
else
{
wbinfos.Add(new WBInfoForAHouse {
XMMC = "网备中无此房屋"
});
}
}
EasyUIGridModel ret = new EasyUIGridModel(0, wbinfos.Count, wbinfos);
return(ret);
}
else
{
return(null);
}
}
public ActionResult GetAttachLst(FileUploadQueryForm form, EasyUIGridSetting gridSetting)
{
if (form == null || string.IsNullOrEmpty(form.Slbh))
{
return(Content("[]", "application/json"));
}
BDCExtendBLL bll = new BDCExtendBLL();
EasyUIGridModel result = bll.GetAttachLst(form, gridSetting);
return(Content(result.ToJson(), "application/json"));
}
public EasyUIGridModel GetAttachLst(FileUploadQueryForm form, EasyUIGridSetting gridSetting)
{
string sql = string.Format(@"SELECT CID,PNODE as SLBH,CNAME,to_char(CREATEDATE,'yy-mm-dd hh24:mi:ss') CREATEDATE
FROM (Select ROWNUM AS ROWNO, T.*
from (select CID,PNODE,CNAME,CREATEDATE from WFM_ATTACHLST where {0}) T
WHERE ROWNUM <= {1}) TABLE_ALIAS
WHERE TABLE_ALIAS.ROWNO > {2}", form.GetWhere(), gridSetting.PageIndex * gridSetting.PageSize, (gridSetting.PageIndex - 1) * gridSetting.PageSize);
string connectStr = ConfigurationManager.ConnectionStrings["bdcggkConnection"].ToString();
DataSet ds = DBHelper.GetDataSet(connectStr, sql);
TBToList <AttachModel> list = new TBToList <AttachModel>();
IList <AttachModel> tags = list.ConvertToModel(ds.Tables[0]);
string countSql = string.Format("Select count(1) from WFM_ATTACHLST where {0}", form.GetWhere());
int count = DBHelper.GetScalar(connectStr, countSql);
EasyUIGridModel ret = new EasyUIGridModel(gridSetting.PageIndex, count, tags);
return(ret);
}
/// <summary>
/// 待我处理的工作
/// </summary>
private void MyTaskList()
{
var gridModel = new EasyUIGridModel<MyTaskListViewModel>();
Result = new Result(true);
try
{
var data = DbFactory.DBA.QueryDataTable(@"select t.ID as TaskID,t1.Name as TaskName,t2.Name as BillName,t3.Name as RoutName,t.State as TaskState,t2.State as ItemState,t2.AddDate from WFTaskList t
inner join WFActor t1 on t.Actor_ID=t1.ID
inner join WFItem t2 on t.Item_ID=t2.ID
inner join WFRout t3 on t1.Rout_ID=t3.ID");
gridModel.rows = data.ToArray<MyTaskListViewModel>().ToList();
gridModel.total = gridModel.rows.Count;
}
catch (Exception)
{
Result = new Result(false);
}
Result.DataObject = gridModel;
}
/// <summary>
/// 待我处理的工作
/// </summary>
private void MyTaskList()
{
var gridModel = new EasyUIGridModel <MyTaskListViewModel>();
Result = new Result(true);
try
{
var data = DbFactory.DBA.QueryDataTable(@"select t.ID as TaskID,t1.Name as TaskName,t2.Name as BillName,t3.Name as RoutName,t.State as TaskState,t2.State as ItemState,t2.AddDate from WFTaskList t
inner join WFActor t1 on t.Actor_ID=t1.ID
inner join WFItem t2 on t.Item_ID=t2.ID
inner join WFRout t3 on t1.Rout_ID=t3.ID");
gridModel.rows = data.ToArray <MyTaskListViewModel>().ToList();
gridModel.total = gridModel.rows.Count;
}
catch (Exception)
{
Result = new Result(false);
}
Result.DataObject = gridModel;
}
public EasyUIGridModel GetWriteBackResult(WriteBackResultQueryForm form, EasyUIGridSetting gridSetting)
{
string sql = string.Format(@"SELECT SLBH,DJLX,SFTS,PUSHDATA,PUSHDATE,PUSHRESULT,WBERRINFO,CGERRINFO,PID,ADDRESSTYPE
FROM (Select ROWNUM AS ROWNO, T.*
from (select * from FC_SPFHX_TAG where {0} order by pushdate desc) T
WHERE ROWNUM <= {1}) TABLE_ALIAS
WHERE TABLE_ALIAS.ROWNO > {2} ", form.GetWhere(), gridSetting.PageIndex * gridSetting.PageSize, (gridSetting.PageIndex - 1) * gridSetting.PageSize, gridSetting.SortBy.PropertyName, gridSetting.SortBy.SortType);
if (gridSetting.SortBy.PropertyName != "")
{
sql += " order by " + gridSetting.SortBy.PropertyName + " " + gridSetting.SortBy.SortType;
}
DataSet ds = DBHelper.GetDataSet(sql);
TBToList <SPFHX_TAG> list = new TBToList <SPFHX_TAG>();
IList <SPFHX_TAG> tags = list.ConvertToModel(ds.Tables[0]);
string countSql = string.Format("Select count(1) from FC_SPFHX_TAG where {0}", form.GetWhere());
int count = DBHelper.GetScalar(countSql);
EasyUIGridModel ret = new EasyUIGridModel(gridSetting.PageIndex, count, tags);
return(ret);
}
public EasyUIGridModel GetWBCLFInfoByHouseIds(string slbh)
{
IList <WBCLFInfo> wbinfos = new List <WBCLFInfo>();
FCWebServiceDal dal = new FCWebServiceDal();
IList <XGZHAndQLR> xgzhAndQlrs = dal.GetFDJBInfo(slbh);
foreach (XGZHAndQLR xgzhAndQlr in xgzhAndQlrs)
{
IList <string> qlrs = xgzhAndQlr.QLRS;
if (qlrs.Count > 0)
{
foreach (string qlr in qlrs)
{
IDictionary <string, string> paramss = new Dictionary <string, string>();
paramss["CQZH"] = xgzhAndQlr.XGZH;
paramss["SYQR"] = qlr;
FC_CLMMHT_WSData ht_Data = new FC_CLMMHT_WSData(CLMMHT_Webservice_Address, "2000");
string backDatas = ht_Data.GetWebServiceData(paramss, null);
var bdc = ht_Data.XMLParsing(backDatas);
if (bdc.data != null && bdc.data.dt != null && bdc.data.dt.Rows.Count > 0)
{
string htid = bdc.data.dt.Rows[0]["HTID"].ToString().Trim();
string htbah = bdc.data.dt.Rows[0]["CLHTBAH"].ToString();
var qlrBdc = GetQLR(htbah);
string yrwmc = "";
string ywrno = "";
if (qlrBdc.data != null && qlrBdc.data.dt != null && qlrBdc.data.dt.Rows.Count > 0)
{
foreach (DataRow row in qlrBdc.data.dt.Rows)
{
if (row["XGRLX"].ToString() == "1")
{
if (yrwmc == "")
{
yrwmc = row["XGRMC"].ToString();
ywrno = row["ZJHM"].ToString();
}
else
{
yrwmc += "," + row["XGRMC"].ToString();
ywrno += "," + row["ZJHM"].ToString();
}
}
}
}
WBCLFInfo wci = (from wi in wbinfos where wi.HTID == htid select wi).FirstOrDefault();
if (null != wci)
{
wci.SYQR += "," + bdc.data.dt.Rows[0]["SYQR"].ToString();
wci.BARPASSNO += "," + bdc.data.dt.Rows[0]["BARPASSNO"].ToString();
}
else
{
wci = new WBCLFInfo();
wci.BARPASSNO = bdc.data.dt.Rows[0]["BARPASSNO"].ToString();
wci.SYQR = bdc.data.dt.Rows[0]["SYQR"].ToString();
wci.HTID = htid.Trim();
wci.CQZH = bdc.data.dt.Rows[0]["CQZH"].ToString();
wci.HID = bdc.data.dt.Rows[0]["HID"].ToString();
wci.ZID = bdc.data.dt.Rows[0]["ZID"].ToString();
wci.CLHTBAH = bdc.data.dt.Rows[0]["CLHTBAH"].ToString();
wci.HTBASJ = bdc.data.dt.Rows[0]["HTBASJ"] == null ? null : Convert.ToDateTime(bdc.data.dt.Rows[0]["HTBASJ"]).ToString();
wci.FWZL = bdc.data.dt.Rows[0]["FWZL"].ToString();
wci.FWLX = bdc.data.dt.Rows[0]["FWLX"].ToString();
wci.FWJG = bdc.data.dt.Rows[0]["FWJG"].ToString();
wci.HX = bdc.data.dt.Rows[0]["HX"].ToString();
wci.JZMJ = bdc.data.dt.Rows[0]["JZMJ"].ToString();
wci.TNJZMJ = bdc.data.dt.Rows[0]["TNJZMJ"].ToString();
wci.FTJZMJ = bdc.data.dt.Rows[0]["FTJZMJ"].ToString();
wci.JYJG = bdc.data.dt.Rows[0]["JYJG"].ToString();
wci.FKLX = bdc.data.dt.Rows[0]["FKLX"].ToString();
wci.DKFS = bdc.data.dt.Rows[0]["DKFS"].ToString();
wci.FKSJ = bdc.data.dt.Rows[0]["FKSJ"].ToString();
wci.QDSJ = bdc.data.dt.Rows[0]["QDSJ"].ToString();
wci.QRSJ = bdc.data.dt.Rows[0]["QRSJ"].ToString();
wci.QRQZSJ = bdc.data.dt.Rows[0]["QRQZSJ"].ToString();
wci.ZHBGTGSJ = bdc.data.dt.Rows[0]["ZHBGTGSJ"].ToString();
wci.JSSJ = bdc.data.dt.Rows[0]["JSSJ"].ToString();
wci.SFYX = bdc.data.dt.Rows[0]["SFYX"].ToString();
wci.YWR = yrwmc;
wci.YWRNO = ywrno;
wbinfos.Add(wci);
}
}
}
}
}
if (wbinfos.Count == 0)
{
wbinfos.Add(new WBCLFInfo {
HTID = "网备中无此房屋合同信息"
});
}
EasyUIGridModel ret = new EasyUIGridModel(0, wbinfos.Count, wbinfos);
return(ret);
}
