public override dynamic GetSpecialModelFromCurrentID <T>(T ID)
{
Td_zydh obj = base.GetSpecialModelFromCurrentID(ID);
if ((obj != null) && (obj.ID != 0))
{
Td_zydh nowObj = GetOneRecordbyID <Td_zydh, T>(ID);
obj.GxName = nowObj.Gx.Name;
}
return(obj);
}
public override ActionResult WindowCommonShow(string PanelID, string ParentVariable, string ParentKey)
{
setParentVariable("UserControl", "WinZydhSimpleMore", "WinZydhSimpleMore_SelectKldmChange", null, "kldmTable");
SetHiddenValue(PanelID + "_cmbKldm_ParentVariable", ParentVar.DefaultVal);
setParentVariable("UserControl", "WinZydhSimpleMore", "WinZydhSimpleMore_SelectZylbdmChange", null, "zylbdmTable");
SetHiddenValue(PanelID + "_cmbZylbdm_ParentVariable", ParentVar.DefaultVal);
setParentVariable("UserControl", "WinZydhSimpleMore", "WinZydhSimpleMore_SelectXzdmChange", null, "xzdmTable");
SetHiddenValue(PanelID + "_cmbXzdm_ParentVariable", ParentVar.DefaultVal);
GetParentVariable(ParentVariable);
zydhTableDataListManage man = new zydhTableDataListManage();
man.InitSelection(ParentVar.transValue);
Td_zydh model = man.GetSpecialModelFromCurrentID(man.sRowNowID);
SetComboValue(PanelID + "_cmbKldm", model.Kldm.ToString(), true);
SetComboValue(PanelID + "_cmbZylbdm", model.Zylbdm.ToString(), true);
SetComboValue(PanelID + "_cmbXzdm", model.Xzdm.ToString(), true);
var form = this.GetCmp <FormPanel>(PanelID + "_Form");
form.SetValues(model);
return(this.Direct());
}
public List <ListCompareTable> InportOriginData(DataTable dt, int nNowYear, long lProvinceID, long lParentDepartmentID, long GxID)
{
List <ListCompareTable> listReturn = new List <ListCompareTable>();
if (dt != null)
{
List <Td_zydh_Origin> OriginModels = InportSomeRowsOriginTable <Td_zydh_Origin>(dt, nNowYear, lProvinceID);
TableStatusManage statusManage = new TableStatusManage();
for (int i = 0; i < dt.Rows.Count; i++)
{
//先导入原始表
long lNowRelationID = Convert.ToInt64(OriginModels[i].RelationID);
if (lNowRelationID != 0) //原始表中已经存在，直接取用
{
ListCompareTable oneTable = new ListCompareTable();
oneTable.sOldID = dt.Rows[i]["ZYDH"].ToString();
oneTable.lNewID = OriginModels[i].RelationID;
oneTable.lOriginID = OriginModels[i].ID;
listReturn.Add(oneTable);
}
else
{
long lNewID = 0;
Td_zydh obj = getOneMainRecord(lParentDepartmentID, OriginModels[i]);
if (obj == null) //目前主表中不存在
{
while (!statusManage.BeginUpdate <Td_zydh>())
{
Random ra = new Random();
Thread.Sleep(ra.Next(100, 1000));
}
obj = getOneMainRecord(lParentDepartmentID, OriginModels[i]);
if (obj == null) //还是不存在
{
Td_zydh model = new Td_zydh();
model.Name = GetOneStrValue(dt.Rows[i], "ZYMC");
model.Code = GetOneStrValue(dt.Rows[i], "ZYDH");
model.Remark = GetOneStrValue(dt.Rows[i], "BZ");
ListCompareTable oneCompare = GetCompareList(CCDM_list, GetOneStrValue(dt.Rows[i], "CCDM", CosDataBase.LONGINT_TYPE));
if (oneCompare != null)
{
model.CcdmOrigin = oneCompare.lOriginID;
model.Ccdm = oneCompare.lNewID;
}
oneCompare = GetCompareList(KLDM_list, GetOneStrValue(dt.Rows[i], "KLDM", CosDataBase.LONGINT_TYPE));
if (oneCompare != null)
{
model.KldmOrigin = oneCompare.lOriginID;
model.Kldm = oneCompare.lNewID;
}
string sXzdm = GetXzdm(dt.Rows[i]);
oneCompare = GetCompareList(XZDM_list, sXzdm);
if (oneCompare != null)
{
model.XzdmOrigin = oneCompare.lOriginID;
model.Xzdm = oneCompare.lNewID;
}
oneCompare = GetCompareList(ZYLBDM_list, GetOneStrValue(dt.Rows[i], "ZYLBDM", CosDataBase.LONGINT_TYPE));
if (oneCompare != null)
{
model.ZylbdmOrigin = oneCompare.lOriginID;
model.Zylbdm = oneCompare.lNewID;
}
model.Zkfx = GetOneStrValue(dt.Rows[i], "ZKFX");
model.Tjsxbz = GetOneStrValue(dt.Rows[i], "TJSXBZ");
model.Sfks = Convert.ToBoolean(GetOneStrValue(dt.Rows[i], "SFKZ", CosDataBase.BOOLEAN_TYPE));
model.Sfbz = Convert.ToInt32(GetOneStrValue(dt.Rows[i], "Sfbz", CosDataBase.INT_TYPE));
model.Bxdd = GetOneStrValue(dt.Rows[i], "BXDD");
model.Wyyz = GetOneStrValue(dt.Rows[i], "WYYZ");
model.ParentDepartmentID = lParentDepartmentID;
model.GxID = GxID;
model.JoinNames = model.Name;
string[] EditColumns = { "Name", "Code", "Remark", "CcdmOrigin", "Ccdm", "KldmOrigin", "Kldm",
"XzdmOrigin", "Xzdm", "ZylbdmOrigin", "Zylbdm", "Zkfx", "Tjsxbz", "Sfks","Sfbz","Bxdd", "Wyyz", "ParentDepartmentID", "GxID", "JoinNames" };
lNewID = SaveOneSimpleRecord(model, "zydhTable", EditColumns);
statusManage.EndUpdate <Td_zydh>();
ListCompareTable oneTable = new ListCompareTable();
oneTable.sOldID = dt.Rows[i]["ZYDH"].ToString();
oneTable.lNewID = lNewID;
oneTable.lOriginID = OriginModels[i].ID;
listReturn.Add(oneTable);
}
else //目前主表中存在
{
if (obj.DelFlag)
{
lNewID = obj.JoinID;
}
else
{
lNewID = obj.ID;
}
ListCompareTable oneTable = new ListCompareTable();
oneTable.sOldID = dt.Rows[i]["ZYDH"].ToString();
oneTable.lNewID = lNewID;
oneTable.lOriginID = OriginModels[i].ID;
listReturn.Add(oneTable);
}
}
else //目前主表中存在
{
if (obj.DelFlag)
{
lNewID = obj.JoinID;
}
else
{
lNewID = obj.ID;
}
ListCompareTable oneTable = new ListCompareTable();
oneTable.sOldID = dt.Rows[i]["ZYDH"].ToString();
oneTable.lNewID = lNewID;
oneTable.lOriginID = OriginModels[i].ID;
listReturn.Add(oneTable);
}
////不管存在与否，都需修改原始表中相应的RelationID
string[] EditColumn = { "RelationID" };
OriginModels[i].RelationID = lNewID;
SaveOneRecord(OriginModels[i], EditColumn);
}
}
}
return(listReturn);
}
//protected virtual int _DFSSetLine(int nItemPos, int nRowNumX, int nRowNumY, Worksheet ws, ArrayList ItemKeys, ArrayList arrItems, ArrayList arrNames, ArrayList arrValues, ArrayList arrSigns, object tempMan)
//{
// return nRowNumX;
//}
protected virtual int DFSSetLine(int nItemPos, int nRowNumX, int nRowNumY, Worksheet ws, ArrayList ItemKeys, ArrayList arrItems, ArrayList arrNames, ArrayList arrValues, ArrayList arrSigns, long ReportTypeID)
{
dqdmTableManage dqMan = new dqdmTableManage();
OriginTableManage tableMan = new OriginTableManage();
for (int i = 0; i < ((ArrayList)arrItems[nItemPos]).Count; i++)
{
if (ItemKeys[nItemPos].ToString() == "pcdmTable")
{
continue;
}
ArrayList arrNowNames = new ArrayList(); ArrayList arrNowValues = new ArrayList(); ArrayList arrNowSigns = new ArrayList();
for (int j = 0; j < arrNames.Count; j++)
{
arrNowNames.Add(arrNames[j]);
arrNowValues.Add(arrValues[j]);
arrNowSigns.Add(arrSigns[j]);
}
long lNowID = Convert.ToInt64(((ArrayList)arrItems[nItemPos])[i]);
int nRowNowNumY = nRowNumY;
string sColumnValue = "";
switch (ItemKeys[nItemPos].ToString())
{
case "Department":
zydhTableManage zyMan = new zydhTableManage();
tblDepartmentInfo depart = GetOneRecordbyID <tblDepartmentInfo, long>(lNowID);
if (depart.ZYIDs != null && depart.ZYIDs != "" && depart.ZYIDs != " ")
{
long[] ZyIDs = Array.ConvertAll(depart.ZYIDs.Split(CosValue.SPLITOPERATOR2), long.Parse);
if (ZyIDs.Length > 0)
{
clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumY, depart.Name);
nRowNowNumY++;
int nRowNumXX = nRowNumX;
switch (ReportTypeID)
{
case 1: //计划库
arrNowNames.Add("Zydh"); arrNowValues.Add(0); arrNowSigns.Add(SIGN.Equal); break;
case 3: //批次，第一志愿
case 4:
arrNowNames.Add("jhk.Zydh"); arrNowValues.Add(0); arrNowSigns.Add(SIGN.Equal); break;
default:
arrNowNames.Add("Lqzy"); arrNowValues.Add(0); arrNowSigns.Add(SIGN.Equal); break;
}
for (int j = 0; j < ZyIDs.Length; j++)
{
arrNowValues[arrNowValues.Count - 1] = ZyIDs[j];
Td_zydh zymodel = GetOneRecordbyID <Td_zydh, long>(ZyIDs[j]);
int nRowNowNumYY = nRowNowNumY;
if (zymodel != null)
{
clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumYY, zymodel.Name); nRowNowNumYY++;
//clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumYY, zymodel.Code); nRowNowNumYY++;
nRowNumX = _SetLineCore(nItemPos, nRowNumX, ws, ItemKeys, arrItems, arrNowNames, arrNowValues, arrNowSigns, nRowNowNumYY, ReportTypeID);
}
}
clsExcelApp.UniteCells(ws, nRowNumXX, nRowNowNumY - 1, nRowNumX - 1, nRowNowNumY - 1);
}
}
break;
case "Province":
if (ReportTypeID == 1) //因为jhk里直接有ProvinceID字段,否则前面要加bmk来找
{
arrNowNames.Add("ProvinceID");
}
else
{
arrNowNames.Add("bmk.ProvinceID");
}
arrNowValues.Add(lNowID); arrNowSigns.Add(SIGN.Equal);
string sProvinceName = dqMan.GetNowNamefromID(lNowID);
clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumY, sProvinceName); //省份
nRowNowNumY++;
nRowNumX = _SetLineCore(nItemPos, nRowNumX, ws, ItemKeys, arrItems, arrNowNames, arrNowValues, arrNowSigns, nRowNowNumY, ReportTypeID);
break;
default:
string sNowTableName = ItemKeys[nItemPos].ToString().Replace("Table", "");
sNowTableName = "bmk." + sNowTableName.Substring(0, 1).ToUpper() + sNowTableName.Substring(1, sNowTableName.Length - 1);
arrNowNames.Add(sNowTableName); arrNowValues.Add(lNowID); arrNowSigns.Add(SIGN.Equal);
sColumnValue = tableMan.GetNowNamefromID(lNowID, ItemKeys[nItemPos].ToString());
clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumY, sColumnValue);
nRowNowNumY++;
nRowNumX = _SetLineCore(nItemPos, nRowNumX, ws, ItemKeys, arrItems, arrNowNames, arrNowValues, arrNowSigns, nRowNowNumY, ReportTypeID);
break;
}
}
return(nRowNumX);
}
