public override dynamic GetSpecialModelFromCurrentID <T>(T ID) { T_jhk obj = base.GetSpecialModelFromCurrentID(ID); if ((obj != null) && (obj.ID != 0)) { T_jhk nowObj = GetOneRecordbyID <T_jhk, T>(ID); obj.GxName = nowObj.ParentDepartment.Name; if (nowObj.tddw.Jhxzdm != 0) { obj.JhxzName = nowObj.tddw.jhxz.Name; } if (nowObj.tddw.Jhlbdm != 0) { obj.JhlbName = nowObj.tddw.jhlb.Name; } if (nowObj.tddw.Pcdm != 0) { obj.PcName = nowObj.tddw.pc.Name; } if (nowObj.tddw.Kldm != 0) { obj.KlName = nowObj.tddw.kl.Name; } Td_dqdm dq = GetOneRecordbyID <Td_dqdm, long>(obj.ProvinceID); if (dq != null) { obj.ProvinceName = dq.Name; } } return(obj); }
public override void InitPage() { SetSearchPanelHeight(110); setParentVariable(null, null, "JHKSearch_SelectPcdmChange", null, "pcdmTable"); SetHiddenValue(sPageKeyWord + "_cmbPcdm_ParentVariable", ParentVar.DefaultVal); SetComboValue(sPageKeyWord + "_cmbPcdm", "0", true); setParentVariable(null, null, "JHKSearch_SelectKldmChange", null, "kldmTable"); SetHiddenValue(sPageKeyWord + "_cmbKldm_ParentVariable", ParentVar.DefaultVal); SetComboValue(sPageKeyWord + "_cmbKldm", "0", true); setParentVariable(null, null, "JHKSearch_SelectJhxzdmChange", null, "jhxzdmTable"); SetHiddenValue(sPageKeyWord + "_cmbJhxzdm_ParentVariable", ParentVar.DefaultVal); SetComboValue(sPageKeyWord + "_cmbJhxzdm", "0", true); setParentVariable(null, null, "JHKSearch_SelectJhlbdmChange", null, "jhlbdmTable"); SetHiddenValue(sPageKeyWord + "_cmbJhlbdm_ParentVariable", ParentVar.DefaultVal); SetComboValue(sPageKeyWord + "_cmbJhlbdm", "0", true); setParentVariable(null, null, "JHKSearch_SelectDqdmChange", null, "dqdmTable"); SetHiddenValue(sPageKeyWord + "_cmbDqdm_ParentVariable", ParentVar.DefaultVal); SetHiddenValue(sPageKeyWord + "_cmbDqdm_NowNames", "ParentIndex"); SetHiddenValue(sPageKeyWord + "_cmbDqdm_NowValues", "-1"); SetHiddenValue(sPageKeyWord + "_cmbDqdm_NowSigns", SIGN.Equal.ToString()); SetComboValue(sPageKeyWord + "_cmbDqdm", "0", true); setParentVariable(null, null, "JHKSearch_SelectXzdmChange", null, "xzdmTable"); SetHiddenValue(sPageKeyWord + "_cmbXzdm_ParentVariable", ParentVar.DefaultVal); SetComboValue(sPageKeyWord + "_cmbXzdm", "0", true); T_jhk model = new T_jhk(); var form = this.GetCmp <FormPanel>(sMainFormName); form.SetValues(model); SetInitDataAuthor(); base.InitPage(); }
public override ActionResult WindowCommonShow(string PanelID, string ParentVariable, string ParentKey) { setParentVariable("UserControl", "WinJHKMore", "WinJHKMore_SelectTddwdmChange", null, "tddwTable"); SetHiddenValue(PanelID + "_cmbTddwdm_ParentVariable", ParentVar.DefaultVal); setParentVariable("UserControl", "WinJHKMore", "WinJHKMore_SelectZydhChange", null, "zydhTable"); SetHiddenValue(PanelID + "_cmbZydh_ParentVariable", ParentVar.DefaultVal); GetParentVariable(ParentVariable); jhkTableDataListManage man = new jhkTableDataListManage(); man.InitSelection(ParentVar.transValue); T_jhk model = man.GetSpecialModelFromCurrentID(man.sRowNowID); var form = this.GetCmp <FormPanel>(PanelID + "_Form"); form.SetValues(model); if (model.Tddwdm == 0) { SetComboValue(PanelID + "_cmbTddwdm", "0", true); } else { SetComboValue(PanelID + "_cmbTddwdm", model.Tddwdm.ToString(), true); } if (model.Zydh == 0) { SetComboValue(PanelID + "_cmbZydh", "0", true); } else { SetComboValue(PanelID + "_cmbZydh", model.Zydh.ToString(), true); } return(this.Direct()); }
protected override bool SetSearchWhere(string sData) { T_jhk model = JSON.Deserialize <T_jhk>(sData); List <string> names = new List <string>(); List <string> values = new List <string>(); List <string> signs = new List <string>(); if ((model.GxName != "") && (model.GxName != null)) { names.Add("ParentDepartment.Name"); values.Add(model.GxName); signs.Add(SIGN.Equal.ToString()); } if ((model.SearchZydh != "") && (model.SearchZydh != null)) { names.Add("zydh.Code"); values.Add(model.SearchZydh); signs.Add(SIGN.Like.ToString()); } if ((model.SearchZydm != "") && (model.SearchZydm != null)) { names.Add("zydh.zylb.Code"); values.Add(model.SearchZydm); signs.Add(SIGN.Like.ToString()); } if ((model.SearchZymc != "") && (model.SearchZymc != null)) { names.Add("zydh.zylb.Name"); values.Add(model.SearchZymc); signs.Add(SIGN.Like.ToString()); } if (model.SearchPcdm != 0) { names.Add("tddw.Pcdm"); values.Add(model.SearchPcdm.ToString()); signs.Add(SIGN.Equal.ToString()); } if (model.SearchKldm != 0) { names.Add("tddw.Kldm"); values.Add(model.SearchKldm.ToString()); signs.Add(SIGN.Equal.ToString()); } if (model.SearchJhxzdm != 0) { names.Add("tddw.Jhxzdm"); values.Add(model.SearchJhxzdm.ToString()); signs.Add(SIGN.Equal.ToString()); } if (model.SearchJhlbdm != 0) { names.Add("tddw.Jhlbdm"); values.Add(model.SearchJhlbdm.ToString()); signs.Add(SIGN.Equal.ToString()); } if (model.ProvinceID != 0) { names.Add("ProvinceID"); values.Add(model.ProvinceID.ToString()); signs.Add(SIGN.Equal.ToString()); } if (model.SearchXzdm != 0) { names.Add("zydh.Xzdm"); values.Add(model.SearchXzdm.ToString()); signs.Add(SIGN.Equal.ToString()); } if ((model.SearchStartYear != 0) && (model.SearchStartYear != null)) { names.Add("YearCode"); values.Add(model.SearchStartYear.ToString()); signs.Add(SIGN.GreaterThanOrEqual.ToString()); } if ((model.SearchEndYear != 0) && (model.SearchEndYear != null)) { names.Add("YearCode"); values.Add(model.SearchEndYear.ToString()); signs.Add(SIGN.LessThanOrEqual.ToString()); } if ((model.SearchStartJhrs != 0) && (model.SearchStartJhrs != null)) { names.Add("Jhrs"); values.Add(model.SearchStartJhrs.ToString()); signs.Add(SIGN.GreaterThanOrEqual.ToString()); } if ((model.SearchEndJhrs != 0) && (model.SearchEndJhrs != null)) { names.Add("Jhrs"); values.Add(model.SearchEndJhrs.ToString()); signs.Add(SIGN.LessThanOrEqual.ToString()); } if ((model.SearchStartJhzxs != 0) && (model.SearchStartJhzxs != null)) { names.Add("Jhzxs"); values.Add(model.SearchStartJhzxs.ToString()); signs.Add(SIGN.GreaterThanOrEqual.ToString()); } if ((model.SearchEndJhzxs != 0) && (model.SearchEndJhzxs != null)) { names.Add("Jhzxs"); values.Add(model.SearchEndJhzxs.ToString()); signs.Add(SIGN.LessThanOrEqual.ToString()); } SetHiddenValue(sDataListName + "_NowNames", string.Join(CosValue.SPLITOPERATOR1.ToString(), names.ToArray())); SetHiddenValue(sDataListName + "_NowValues", string.Join(CosValue.SPLITOPERATOR1.ToString(), values.ToArray())); SetHiddenValue(sDataListName + "_NowSigns", string.Join(CosValue.SPLITOPERATOR1.ToString(), signs.ToArray())); return(true); }
public List <T_jhk> InportOriginData(DataTable dt, int nNowYear, long lProvinceID, long lParentDepartmentID, long lGxID, out List <ListCompareTable> old12ZYDH_list) { BuildZYDH(dt, nNowYear, lProvinceID, lParentDepartmentID, lGxID, out old12ZYDH_list); if (dt.Columns.Contains("JHXZ")) { dt.Columns["JHXZ"].ColumnName = "JHXZDM"; //和17表保持一致,改名 } if (dt.Columns.Contains("TDDW")) { dt.Columns["TDDW"].ColumnName = "TDDWDM"; //和17表保持一致,改名 } ArrayList names = new ArrayList(); ArrayList values = new ArrayList(); names.Add("DelFlag"); values.Add(false); names.Add("ProvinceID"); values.Add(lProvinceID); names.Add("YearCode"); values.Add(nNowYear); //names.Add("ParentDepartmentID"); values.Add(lParentDepartmentID); names.Add("GxID"); values.Add(lGxID); Expression <Func <T_jhk, bool> > where = GetAndLambdaExpression <T_jhk>(names, values); List <T_jhk> list = GetRecord(where); //取出主表中相关所有字段 List <T_jhk> listAdd = new List <T_jhk>(); foreach (DataRow dr in dt.Rows) { if (!ExistJH(dr, list)) //如果是不存在的计划 { T_jhk model = new T_jhk(); model.ProvinceID = lProvinceID; model.YearCode = nNowYear; model.ParentDepartmentID = lParentDepartmentID; model.GxID = lGxID; model.PcdmOrigin = GetOriginListID(PCDM_list, GetOneStrValue(dr, "PCDM", CosDataBase.LONGINT_TYPE)); //model.Pcdm = GetMainListID(PCDM_list, GetOneStrValue(dr, "PCDM", CosDataBase.LONGINT_TYPE)); model.KldmOrigin = GetOriginListID(KLDM_list, GetOneStrValue(dr, "KLDM", CosDataBase.LONGINT_TYPE)); //model.Jhxzdm = GetMainListID(JHXZDM_list, GetOneStrValue(dr, "JHXZDM", CosDataBase.LONGINT_TYPE)); model.JhxzdmOrigin = GetOriginListID(JHXZDM_list, GetOneStrValue(dr, "JHXZDM", CosDataBase.LONGINT_TYPE)); //model.Jhlbdm = GetMainListID(JHLBDM_list, GetOneStrValue(dr, "JHLBDM", CosDataBase.LONGINT_TYPE)); model.JhlbdmOrigin = GetOriginListID(JHLBDM_list, GetOneStrValue(dr, "JHLBDM", CosDataBase.LONGINT_TYPE)); model.TddwdmOrigin = GetOriginTddw(dr); model.Tddwdm = GetTddw(dr); ListCompareTable oneCompare = GetCompareList(ZKLXDM_list, GetOneStrValue(dr, "ZKLX", CosDataBase.LONGINT_TYPE)); if (oneCompare != null) { model.ZklxdmOrigin = oneCompare.lOriginID; model.Zklxdm = oneCompare.lNewID; } oneCompare = GetCompareList(ZYDH_list, GetOneStrValue(dr, "ZYDH")); if (oneCompare != null) { model.ZydhOrigin = oneCompare.lOriginID; model.Zydh = oneCompare.lNewID; } model.Jhrs = Convert.ToInt32(GetOneStrValue(dr, "JHRS", CosDataBase.INT_TYPE)); model.Jhzxs = Convert.ToInt32(GetOneStrValue(dr, "JHZXS", CosDataBase.INT_TYPE)); model.Sfsf = Convert.ToBoolean(GetOneStrValue(dr, "SFSF", CosDataBase.BOOLEAN_TYPE)); model.Ytces = Convert.ToInt32(GetOneStrValue(dr, "YTCES", CosDataBase.INT_TYPE)); model.Yxxh = Convert.ToInt32(GetOneStrValue(dr, "YXXH", CosDataBase.INT_TYPE)); model.Bz = GetOneStrValue(dr, "BZ"); listAdd.Add(model); //AddOneRecord(model); } } AddRecords(listAdd); list.AddRange(listAdd); return(list); }