public bool Exists(Int32 userid)
{
String stmtId = "T_Users.Exists";
bool result = MyISqlMap.QueryForObject <bool>(stmtId, userid);
return(result);
}
public T_Item Find(String itemID)
{
String stmtId = "T_Item.Find";
T_Item result = MyISqlMap.QueryForObject <T_Item>(stmtId, itemID);
return(result);
}
public T_Users Find(Int32 userid)
{
String stmtId = "T_Users.Find";
T_Users result = MyISqlMap.QueryForObject <T_Users>(stmtId, userid);
return(result);
}
public bool ExistsName(String projectName)
{
String stmtId = "T_Projects.ExistsName";
bool result = MyISqlMap.QueryForObject <bool>(stmtId, projectName);
return(result);
}
public void CopyFileList(string _projectNO, string _projectCategory)
{
BLL.T_FileList_BLL B1 = new T_FileList_BLL();
IList <MDL.T_FileList> fileList = (new BLL.T_FileList_BLL()).FindByProjectNO(_projectNO);
if (fileList.Count <= 0)
{
T_FileList file = new T_FileList();
T_GdList gd = new T_GdList();
gd.ProjectNo = _projectNO;
gd.ProjectCategory = _projectCategory;
file.ProjectNO = _projectNO;
file.ProjectCategory = _projectCategory;
String stmtId = "T_FileList.CopyFileList";
MyISqlMap.QueryForObject <int>(stmtId, file);
stmtId = "T_CellAndEFile.CopyCellFileList";
MyISqlMap.QueryForObject <int>(stmtId, _projectNO);
stmtId = "T_GdList.CopyGdList";
MyISqlMap.QueryForObject <int>(stmtId, gd);
}
}
public int GetCount()
{
String stmtId = "T_Dict.GetCount";
int result = MyISqlMap.QueryForObject <int>(stmtId, null);
return(result);
}
public T_FileListTemplate FindByProjectCategory(String projectCategory)
{
String stmtId = "T_FileListTemplate.FindByProjectCategory";
T_FileListTemplate result = MyISqlMap.QueryForObject <T_FileListTemplate>(stmtId, projectCategory);
return(result);
}
public bool Exists1(T_Units obj)
{
String stmtId = "T_Units.Exists1";
bool result = MyISqlMap.QueryForObject <bool>(stmtId, obj);
return(result);
}
public T_Settings Find(String iD)
{
String stmtId = "T_Settings.Find";
T_Settings result = MyISqlMap.QueryForObject <T_Settings>(stmtId, iD);
return(result);
}
public bool Exists(String archiveID)
{
String stmtId = "T_Archive.Exists";
bool result = MyISqlMap.QueryForObject <bool>(stmtId, archiveID);
return(result);
}
public T_Dict Find(Int32 iD)
{
String stmtId = "T_Dict.Find";
T_Dict result = MyISqlMap.QueryForObject <T_Dict>(stmtId, iD);
return(result);
}
public T_Archive Find(String archiveID)
{
String stmtId = "T_Archive.Find";
T_Archive result = MyISqlMap.QueryForObject <T_Archive>(stmtId, archiveID);
return(result);
}
/// <summary>
/// 根据项目ID获取相应市政桥梁工程明细
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public T_Project_Brige QueryBrige_ByProjID(string ID)
{
String stmtId = "T_Project_Brige.QueryBrige_ByProjID";
T_Project_Brige result = MyISqlMap.QueryForObject <T_Project_Brige>(stmtId, ID);
return(result);
}
/// <summary>
/// 根据项目ID获取相应市政路灯工程明细
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public T_Project_RoadLamp QueryRoadLamp_ByProjID(string ID)
{
String stmtId = "T_Project_RoadLamp.QueryRoadLamp_ByProjID";
T_Project_RoadLamp result = MyISqlMap.QueryForObject <T_Project_RoadLamp>(stmtId, ID);
return(result);
}
public bool Exists(Int32 iD)
{
String stmtId = "T_Dict.Exists";
bool result = MyISqlMap.QueryForObject <bool>(stmtId, iD);
return(result);
}
public bool Exists(String iD)
{
String stmtId = "T_Settings.Exists";
bool result = MyISqlMap.QueryForObject <bool>(stmtId, iD);
return(result);
}
/// <summary>
/// 根据项目ID获取相应市政交通工程明细
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public T_Traffic QueryTraffic_ByProjID(string ID)
{
String stmtId = "T_Traffic.QueryTraffic_ByProjID";
T_Traffic result = MyISqlMap.QueryForObject <T_Traffic>(stmtId, ID);
return(result);
}
public T_Units Find(String unitID)
{
String stmtId = "T_Units.Find";
T_Units result = MyISqlMap.QueryForObject <T_Units>(stmtId, unitID);
return(result);
}
public bool Exists(String cellID)
{
String stmtId = "T_CellFile.Exists";
bool result = MyISqlMap.QueryForObject <bool>(stmtId, cellID);
return(result);
}
public T_CellFile Find(String cellID)
{
String stmtId = "T_CellFile.Find";
T_CellFile result = MyISqlMap.QueryForObject <T_CellFile>(stmtId, cellID);
return(result);
}
public MDL.T_GdList FindID(String ID)
{
String stmtId = "T_GdList.FindID";
MDL.T_GdList temp_MDL = new MDL.T_GdList();
temp_MDL.ID = ID;
MDL.T_GdList result = MyISqlMap.QueryForObject <MDL.T_GdList>(stmtId, temp_MDL);
return(result);
}
public bool Exists(String fileID, String projectNO)
{
MDL.T_FileListTemplate obj = new T_FileListTemplate();
obj.FileID = fileID;
String stmtId = "T_FileListTemplate.Exists";
bool result = MyISqlMap.QueryForObject <bool>(stmtId, obj);
return(result);
}
public MDL.T_GdListTemplate FindID(String ID)
{
String stmtId = "T_GdListTemplate.FindID";
MDL.T_GdListTemplate temp_MDL = new MDL.T_GdListTemplate();
temp_MDL.ID = ID;
MDL.T_GdListTemplate result = MyISqlMap.QueryForObject <MDL.T_GdListTemplate>(stmtId, temp_MDL);
return(result);
}
public T_Projects Find(String projectNO)
{
String stmtId = "T_Projects.Find";
MDL.T_Projects obj = new T_Projects();
obj.ProjectNO = projectNO;
T_Projects result = MyISqlMap.QueryForObject <T_Projects>(stmtId, obj);
return(result);
}
public MDL.T_GdList FindIDAndProjectNo(String ID, string ProjectNo)
{
String stmtId = "T_GdList.FindIDAndProjectNo";
MDL.T_GdList temp_MDL = new MDL.T_GdList();
temp_MDL.ID = ID;
temp_MDL.ProjectNo = ProjectNo;
MDL.T_GdList result = MyISqlMap.QueryForObject <MDL.T_GdList>(stmtId, temp_MDL);
return(result);
}
public T_FileList Find(String fileID, String projectNO)
{
MDL.T_FileList obj = new T_FileList();
obj.FileID = fileID;
obj.ProjectNO = projectNO;
String stmtId = "T_FileList.Find";
T_FileList result = MyISqlMap.QueryForObject <T_FileList>(stmtId, obj);
return(result);
}
public T_CellAndEFile Find(String cellID, String projectNO)
{
String stmtId = "T_CellAndEFile.Find";
MDL.T_CellAndEFile obj = new T_CellAndEFile();
obj.CellID = cellID;
obj.ProjectNO = projectNO;
T_CellAndEFile result = MyISqlMap.QueryForObject <T_CellAndEFile>(stmtId, obj);
return(result);
}
public int GetArchiveOrderIndex(string archiveID, string ProjectNO)
{
MDL.T_FileListTemplate obj = new T_FileListTemplate();
String stmtId = "T_FileListTemplate.GetMaxArchiveOrderIndex";
object result = MyISqlMap.QueryForObject(stmtId, obj);
if (result == null)
{
result = "0";
}
return(int.Parse(result.ToString()));
}
public bool Exists(String cellID, String projectNO)
{
String stmtId = "T_CellAndEFile.Exists";
MDL.T_CellAndEFile obj = new T_CellAndEFile();
obj.CellID = cellID;
obj.ProjectNO = projectNO;
bool result = MyISqlMap.QueryForObject <bool>(stmtId, obj);
return(result);
}
public int GetMaxTemplateOrderIndex()
{
MDL.T_FileList obj = new T_FileList();
String stmtId = "T_FileList.GetMaxTemplateOrderIndex";
object result = MyISqlMap.QueryForObject(stmtId, obj);
if (result == null)
{
result = "0";
}
return(int.Parse(result.ToString()));
}