/// <summary>
/// 更新标段信息
/// </summary>
/// <param name="ProjectInfo"></param>
/// <returns></returns>
public Boolean UpdatePrjsctInfo(Prjsct PrjstInfo)
{
Boolean Result = false;
try
{
//工程结构树
StringBuilder Sql_Select = new StringBuilder();
// 增加查询条件 Scdel=0 2013-10-17
Sql_Select.Append("select Id,Description,PegFrom,PegTo,Price,Scts_1 from sys_engs_SectionInfo where Scdel=0 and ID ='");
Sql_Select.Append(PrjstInfo.Index);
Sql_Select.Append("'");
DataTable Data = GetDataTable(Sql_Select.ToString());
if (Data != null && Data.Rows.Count > 0)
{
DataRow Row = Data.Rows[0];
Row["Description"] = PrjstInfo.PrjsctName;
Row["PegFrom"] = PrjstInfo.PegFrom;
Row["PegTo"] = PrjstInfo.PegTo;
Row["Scts_1"] = DateTime.Now.ToString();
}
object r = Update(Data);
Result = (Convert.ToInt32(r) == 1);
ProjectManager project = new ProjectManager();
project.SyncSysTree(PrjstInfo.PrjsctCode, PrjstInfo.PrjsctName, "@tenders", PrjstInfo.OrderID, false);
}
catch
{ }
return(Result);
}
public Prjsct QueryQueryPrjsct(String PrjsctCode)
{
Prjsct PrjstInfo = new Prjsct();
StringBuilder Sql_Select = new StringBuilder();
//增加查询条件 Scdel=0 2013-10-17
Sql_Select.Append("Select ID,Description,PegFrom,PegTo,Price from sys_engs_SectionInfo where Id in (Select RalationID from sys_engs_Tree where Scdel=0 and NodeCode ='");
Sql_Select.Append(PrjsctCode);
Sql_Select.Append("')");
DataTable Data = GetDataTable(Sql_Select.ToString());
if (Data != null && Data.Rows.Count > 0)
{
DataRow Row = Data.Rows[0];
PrjstInfo.Index = Row["ID"].ToString();
PrjstInfo.PrjsctName = Row["Description"].ToString();
PrjstInfo.PegFrom = Row["PegFrom"].ToString();
PrjstInfo.PegTo = Row["PegTo"].ToString();
PrjstInfo.PrjsctCode = PrjsctCode;
DataTable dtTree = GetDataTable("SELECT * FROM dbo.Sys_Tree where nodecode='" + PrjsctCode + "'");
if (dtTree != null && dtTree.Rows.Count > 0)
{
PrjstInfo.OrderID = dtTree.Rows[0]["OrderID"].ToString();
}
}
return(PrjstInfo);
}
public List <Prjsct> QueryPrjscts(String PrjCode)
{
List <Prjsct> PrjstLists = new List <Prjsct>();
StringBuilder Sql_Select = new StringBuilder();
//增加查询条件 Scdel=0 2013-10-17
Sql_Select.Append("select b.ID,a.NodeCode,b.Description,b.PegFrom,b.PegTo,b.Price from sys_engs_Tree as a inner join sys_engs_SectionInfo as b on a.RalationID = b.ID and a.Scdel=0 and a.NodeCode like '");
Sql_Select.Append(PrjCode);
Sql_Select.Append("%' LEFT JOIN dbo.Sys_Tree c ON a.NodeCode=c.NodeCode order by c.OrderID ");
DataTable Data = GetDataTable(Sql_Select.ToString());
//权限控制
String TreeID = "6ED9D9CB-117E-4d8c-A63B-0157BD1F9DFD";
IAuthPolicy AuthPolicy = AuthManager.GetTreeAuth(TreeID);//获取树权限
DataTable NewData = null;
if (Data != null)
{
if (!ApplicationContext.Current.IsAdministrator)
{
NewData = Data.Clone();
foreach (DataRow Row in Data.Rows)
{
String Code = Row["NodeCode"].ToString();
if (AuthPolicy.HasAuth(Code))
{
NewData.ImportRow(Row);
}
}
}
else
{
NewData = Data;
}
}
if (NewData != null && NewData.Rows.Count > 0)
{
foreach (DataRow Row in NewData.Rows)
{
Prjsct PrjstInfo = new Prjsct();
PrjstInfo.Index = Row["ID"].ToString();
PrjstInfo.PrjsctCode = Row["NodeCode"].ToString();
PrjstInfo.PrjsctName = Row["Description"].ToString();
PrjstInfo.PegFrom = Row["PegFrom"].ToString();
PrjstInfo.PegTo = Row["PegTo"].ToString();
PrjstLists.Add(PrjstInfo);
}
}
return(PrjstLists);
}
public ModifyDevice(Prjsct section, Orginfo unit, PrjFolder room)
{
InitializeComponent();
SectionSource = section;
UnitSource = unit;
RoomSource = room;
SetTreeValues(section, unit, room);
GenerateMachineCode_LinkClicked(null, null);
}
private void ComboBox_Segments_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBox_Company.Items.Clear();
ComboBox_Company.Items.Add("全部单位");
if (ComboBox_Segments.SelectedItem is Prjsct)
{
Prjsct prjsct = ComboBox_Segments.SelectedItem as Prjsct;
List <Orginfo> OrgInfos = DepositoryOrganInfo.QueryOrgans(prjsct.PrjsctCode, "");
ComboBox_Company.Items.AddRange(OrgInfos.ToArray());
}
if (ComboBox_Company.Items.Count > 0)
{
ComboBox_Company.SelectedIndex = 0;
}
}
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);
}
/// <summary>
/// 更新标段信息
/// </summary>
/// <param name="ProjectInfo"></param>
/// <returns></returns>
public static Boolean Update(Prjsct PrjstInfo)
{
Boolean Result = Convert.ToBoolean(Agent.CallService("Yqun.BO.BusinessManager.dll", "UpdatePrjsctInfo", new object[] { PrjstInfo }));
return(Result);
}
public static Prjsct Query(String PrjsctCode)
{
Prjsct PrjstInfo = Agent.CallService("Yqun.BO.BusinessManager.dll", "QueryQueryPrjsct", new object[] { PrjsctCode }) as Prjsct;
return(PrjstInfo);
}
/// <summary>
/// 新建标段信息
/// </summary>
/// <param name="PrjstInfo"></param>
/// <returns></returns>
public Boolean NewPrjstInfo(Prjsct PrjstInfo)
{
Boolean Result = false;
IDbConnection DbConnection = GetConntion();
Transaction Transaction = new Transaction(DbConnection);
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(PrjstInfo.Index);
Sql_Select.Append("'");
DataTable Data = GetDataTable(Sql_Select.ToString());
if (Data != null && Data.Rows.Count == 0)
{
DataRow Row = Data.NewRow();
Row["ID"] = Guid.NewGuid().ToString();
Row["NodeCode"] = PrjstInfo.PrjsctCode;
Row["NodeType"] = "@tenders";
Row["RalationID"] = PrjstInfo.Index;
Data.Rows.Add(Row);
}
object r = Update(Data, Transaction);
Result = (Convert.ToInt32(r) == 1);
//处理标段表
Sql_Select = new StringBuilder();
// 增加查询条件 Scdel=0 2013-10-17
Sql_Select.Append("select ID,Description,PegFrom,PegTo,Price from sys_engs_SectionInfo where Scdel=0 and ID ='");
Sql_Select.Append(PrjstInfo.Index);
Sql_Select.Append("'");
Data = GetDataTable(Sql_Select.ToString());
if (Data != null && Data.Rows.Count == 0)
{
DataRow Row = Data.NewRow();
Row["ID"] = PrjstInfo.Index;
Row["Description"] = PrjstInfo.PrjsctName;
Row["PegFrom"] = PrjstInfo.PegFrom;
Row["PegTo"] = PrjstInfo.PegTo;
Data.Rows.Add(Row);
}
r = Update(Data, Transaction);
Result = Result & (Convert.ToInt32(r) == 1);
if (Result)
{
Transaction.Commit();
}
else
{
Transaction.Rollback();
}
}
catch
{
Transaction.Rollback();
}
PrjstInfo.OrderID = PrjstInfo.PrjsctCode;
ProjectManager project = new ProjectManager();
project.SyncSysTree(PrjstInfo.PrjsctCode, PrjstInfo.PrjsctName, "@tenders", PrjstInfo.OrderID, false);
return(Result);
}
