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);
}
