public Boolean SelectPrjFolder(PrjFolder FolderInfo)
{
Boolean Result = false;
try
{
//工程结构树
StringBuilder Sql_Select = new StringBuilder();
//增加查询条件 Scdel=0 2013-10-17
Sql_Select.Append("Select Id,NodeCode,NodeType,RalationID From sys_engs_Tree Where Scdel=0 and RalationID='");
Sql_Select.Append(FolderInfo.Index);
Sql_Select.Append("'");
DataTable Data = GetDataTable(Sql_Select.ToString());
if (Data != null)
{
DataRow Row = Data.NewRow();
Row["ID"] = Guid.NewGuid().ToString();
Row["NodeCode"] = FolderInfo.FolderCode;
Row["NodeType"] = FolderInfo.FolderType;
Row["RalationID"] = FolderInfo.Index;
Data.Rows.Add(Row);
}
object r = Update(Data);
Result = (Convert.ToInt32(r) == 1);
}
catch
{ }
return(Result);
}
/// <summary>
/// 获得某个文件夹
/// </summary>
/// <param name="MachineCode"></param>
/// <returns></returns>
public PrjFolder QueryPrjFolder(String FolderCode)
{
PrjFolder FolderInfo = new PrjFolder();
StringBuilder Sql_Select = new StringBuilder();
//增加查询条件 Scdel=0 2013-10-17
Sql_Select.Append("select b.ID,a.NodeCode,b.Description,b.ItemType from sys_engs_Tree as a inner join sys_engs_ItemInfo as b on a.RalationID = b.ID and a.Scdel=0 and a.NodeCode = '");
Sql_Select.Append(FolderCode);
Sql_Select.Append("' ");
DataTable Data = GetDataTable(Sql_Select.ToString());
if (Data != null && Data.Rows.Count > 0)
{
DataRow Row = Data.Rows[0];
FolderInfo.Index = Row["ID"].ToString();
FolderInfo.FolderCode = Row["NodeCode"].ToString();
FolderInfo.FolderName = Row["Description"].ToString();
FolderInfo.FolderType = Row["ItemType"].ToString();
logger.Error("QueryPrjFolder FolderCode:" + FolderCode);
DataTable dtTree = GetDataTable("SELECT * FROM dbo.Sys_Tree where nodecode='" + FolderCode + "'");
if (dtTree != null && dtTree.Rows.Count > 0)
{
FolderInfo.OrderID = dtTree.Rows[0]["OrderID"].ToString();
}
logger.Error("QueryPrjFolder FolderInfo.OrderID:" + FolderInfo.OrderID);
}
return(FolderInfo);
}
public ModifyDevice(Prjsct section, Orginfo unit, PrjFolder room)
{
InitializeComponent();
SectionSource = section;
UnitSource = unit;
RoomSource = room;
SetTreeValues(section, unit, room);
GenerateMachineCode_LinkClicked(null, null);
}
/// <summary>
/// 查找单位下某种文件夹
/// </summary>
/// <param name="DepCode"></param>
/// <param name="MachineType"></param>
/// <returns></returns>
public List <PrjFolder> QueryPrjFolders(String OrgInfoCode, String FolderType)
{
List <PrjFolder> FolderList = new List <PrjFolder>();
StringBuilder Sql_Select = new StringBuilder();
if (FolderType == "")
{
//增加查询条件 a.Scdel=0 2013-10-17
Sql_Select.Append("select b.ID,a.NodeCode,b.Description,b.ItemType from sys_engs_Tree as a inner join sys_engs_ItemInfo as b on a.RalationID = b.ID and a.NodeType = b.ItemType and a.Scdel=0 and a.NodeCode like '");
Sql_Select.Append(OrgInfoCode);
Sql_Select.Append("%' LEFT JOIN dbo.Sys_Tree c ON a.NodeCode=c.NodeCode order by c.OrderID");
}
else
{
//增加查询条件 Scdel=0 2013-10-17
Sql_Select.Append("select b.ID,a.NodeCode,b.Description,b.ItemType from sys_engs_Tree as a inner join sys_engs_ItemInfo as b on a.RalationID = b.ID and a.NodeType = b.ItemType and a.Scdel=0 and a.NodeCode like '");
Sql_Select.Append(OrgInfoCode);
Sql_Select.Append("%' and a.NodeType ='");
Sql_Select.Append(FolderType);
Sql_Select.Append("' LEFT JOIN dbo.Sys_Tree c ON a.NodeCode=c.NodeCode order by c.OrderID");
}
//logger.Error(Sql_Select.ToString());
DataTable Data = GetDataTable(Sql_Select.ToString());
if (Data != null && Data.Rows.Count > 0)
{
foreach (DataRow Row in Data.Rows)
{
PrjFolder FolderInfo = new PrjFolder();
FolderInfo.Index = Row["ID"].ToString();
FolderInfo.FolderCode = Row["NodeCode"].ToString();
FolderInfo.FolderName = Row["Description"].ToString();
FolderInfo.FolderType = Row["ItemType"].ToString();
FolderList.Add(FolderInfo);
}
}
return(FolderList);
}
private void SetTreeValues(Prjsct section, Orginfo unit, PrjFolder room)
{
Section.SelectedIndexChanged -= new EventHandler(Section_SelectedIndexChanged);
Unit.SelectedIndexChanged -= new EventHandler(Unit_SelectedIndexChanged);
TestRoom.SelectedIndexChanged -= new EventHandler(TestRoom_SelectedIndexChanged);
Section.DataSource = DepositoryPrjsctInfo.QueryPrjscts(Yqun.Common.ContextCache.ApplicationContext.Current.InProject.Code);
Section.Text = section.PrjsctName;
Unit.DataSource = DepositoryOrganInfo.QueryOrgans(section.PrjsctCode, "");
Unit.Text = unit.DepName;
TestRoom.DataSource = DepositoryFolderInfo.QueryPrjFolders(unit.DepCode, "");
TestRoom.SelectedItem = room;
TestRoom.SelectedValue = room.FolderCode;
TestRoom.SelectedText = room.FolderName;
TestRoom.Text = room.FolderName;
Section.SelectedIndexChanged += new EventHandler(Section_SelectedIndexChanged);
Unit.SelectedIndexChanged += new EventHandler(Unit_SelectedIndexChanged);
TestRoom.SelectedIndexChanged += new EventHandler(TestRoom_SelectedIndexChanged);
}
public Boolean UpdatePrjFolder(PrjFolder FolderInfo)
{
Boolean Result = false;
try
{
//工程结构树
StringBuilder Sql_Select = new StringBuilder();
//增加查询条件 Scdel=0 2013-10-17
Sql_Select.Append("Select Id,Description,ItemType,Scts_1 From sys_engs_ItemInfo Where Scdel=0 and Id='");
Sql_Select.Append(FolderInfo.Index);
Sql_Select.Append("'");
DataTable Data = GetDataTable(Sql_Select.ToString());
if (Data != null && Data.Rows.Count > 0)
{
DataRow Row = Data.Rows[0];
Row["Description"] = FolderInfo.FolderName;
Row["ItemType"] = FolderInfo.FolderType;
//增加条件 Scts_1=Getdate() 2013-10-17
Row["Scts_1"] = DateTime.Now.ToString();
}
object r = Update(Data);
Result = (Convert.ToInt32(r) == 1);
ProjectManager project = new ProjectManager();
project.SyncSysTree(FolderInfo.FolderCode, FolderInfo.FolderName, "@folder", FolderInfo.OrderID, false);
}
catch (Exception ex)
{
logger.Error("UpdatePrjFolder异常:" + ex.Message);
}
return(Result);
}
public static Boolean Select(PrjFolder FolderInfo)
{
Boolean Result = Convert.ToBoolean(Agent.CallService("Yqun.BO.BusinessManager.dll", "SelectPrjFolder", new object[] { FolderInfo }));
return(Result);
}
public static PrjFolder Query(String FolderCode)
{
PrjFolder FolderInfo = Agent.CallService("Yqun.BO.BusinessManager.dll", "QueryPrjFolder", new object[] { FolderCode }) as PrjFolder;
return(FolderInfo);
}
public Boolean NewPrjFolder(PrjFolder FolderInfo)
{
Boolean Result = false;
IDbConnection Connection = GetConntion();
Transaction Transaction = new Transaction(Connection);
Boolean flag = false;
try
{
//工程结构树
StringBuilder Sql_Nodes = new StringBuilder();
//增加查询条件 Scdel=0 2013-10-17
Sql_Nodes.Append("Select Id,NodeCode,NodeType,RalationID From sys_engs_Tree Where Scdel=0 and RalationID='");
Sql_Nodes.Append(FolderInfo.Index);
Sql_Nodes.Append("'");
StringBuilder Sql_Items = new StringBuilder();
//增加查询条件 Scdel=0 2013-10-17
Sql_Items.Append("Select Id,Description,ItemType From sys_engs_ItemInfo Where Scdel=0 and Id='");
Sql_Items.Append(FolderInfo.Index);
Sql_Items.Append("'");
List <string> sql_Commands = new List <string>();
sql_Commands.Add(Sql_Nodes.ToString());
sql_Commands.Add(Sql_Items.ToString());
DataSet dataset = GetDataSet(sql_Commands.ToArray());
if (dataset != null)
{
DataTable TableNodes = dataset.Tables["sys_engs_Tree"];
DataTable TableItems = dataset.Tables["sys_engs_ItemInfo"];
if (TableNodes != null && TableNodes.Rows.Count == 0)
{
DataRow Row = TableNodes.NewRow();
Row["ID"] = Guid.NewGuid().ToString();
Row["NodeCode"] = FolderInfo.FolderCode;
Row["NodeType"] = "@folder";
Row["RalationID"] = FolderInfo.Index;
TableNodes.Rows.Add(Row);
}
if (TableItems != null && TableItems.Rows.Count == 0)
{
DataRow Row = TableItems.NewRow();
Row["ID"] = FolderInfo.Index;
Row["Description"] = FolderInfo.FolderName;
Row["ItemType"] = "@folder";
TableItems.Rows.Add(Row);
}
object r = Update(dataset, Transaction);
Result = (Convert.ToInt32(r) == 1);
if (Result)
{
Transaction.Commit();
flag = true;
}
else
{
Transaction.Rollback();
}
}
}
catch
{
Transaction.Rollback();
}
if (flag)
{
try
{
//PXJZDataManager pxjz = new PXJZDataManager();
//pxjz.NewByTestRoom(FolderInfo.FolderCode, FolderInfo.Index);
FolderInfo.OrderID = FolderInfo.FolderCode;
ProjectManager project = new ProjectManager();
project.SyncSysTree(FolderInfo.FolderCode, FolderInfo.FolderName, "@folder", FolderInfo.OrderID, false);
}
catch
{
}
}
return(Result);
}
