/// <summary>
/// ��������Project�б�
/// </summary>
/// <returns></returns>
public static DataSet FindUnitDataset()
{
OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
// Database db = DatabaseFactory.CreateDatabase("ifsConnection");
string sql = "SELECT UNIT_CODE from IFSAPP.ISO_UNIT";
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteDataSet(cmd);
}
/// <summary>
/// ��������Project�б�
/// </summary>
/// <returns></returns>
public static DataSet FindStnPartDataset(string ProjectId,string Site)
{
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
//Database db = DatabaseFactory.CreateDatabase("ifsConnection");
string sql = "SELECT typeid, STA_PART_NO, PART_NAME FROM plm.MM_STA_PART_TAB a where PROJECTID=:proId and SITE=:site ";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "proId", DbType.String, ProjectId);
db.AddInParameter(cmd, "site", DbType.String, Site);
return db.ExecuteDataSet(cmd);
}
/// <summary>
/// �鿴��PROJECT_System_TAB������û�� ѡ�����Ŀ
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public static DataSet TreeByPid(string id, string keyword, string newFlag)
{
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
string sql = "SELECT * FROM PLM.PROJECT_System_TAB WHERE project_id=:id and NEWFLAG ='" + newFlag + "'";
if (keyword != string.Empty) sql += " AND DESCRIPTION LIKE '%" + keyword + "%'";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "id", DbType.String, id);
return db.ExecuteDataSet((cmd));
}
/// <summary>
/// ������������Ŀ�µ�����Ŀ�б�
/// </summary>
/// <returns></returns>
public static DataSet FindSub2ProjectsDs(string id, string subId)
{
OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
// Database db = DatabaseFactory.CreateDatabase("ifsConnection");
string sql = " SELECT * FROM IFSAPP.SUB_PROJECT T WHERE T.PROJECT_ID = :id AND T.PARENT_SUB_PROJECT_ID =:subId ORDER BY t.sub_project_id";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "id", DbType.String, id);
db.AddInParameter(cmd, "subId", DbType.String, subId);
return db.ExecuteDataSet(cmd);
}
/// <summary>
/// ��������Site�б�
/// </summary>
/// <returns></returns>
public static DataSet FindSiteDataset()
{
OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
// Database db = DatabaseFactory.CreateDatabase("ifsConnection");
string sql = "SELECT * FROM IFSAPP.site_tab";
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteDataSet(cmd);
}
public static DataSet FindERPPartDataset(string partno, string site,string ProId,string ActSeq)
{
// Database db = DatabaseFactory.CreateDatabase("ifsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
string sql = "SELECT ERP_PART_NO,PART_NAME,site FROM plm.MM_IFS_STA_PART_TAB where STA_PART_NO=:staPartno and PROJECTID=:proId and ACTIVITYSEQ=:actSeq and SITE=:site";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "staPartno", DbType.String, partno);
db.AddInParameter(cmd, "proId", DbType.String, ProId);
db.AddInParameter(cmd, "actSeq", DbType.Int32, ActSeq);
db.AddInParameter(cmd, "site", DbType.String, site);
return db.ExecuteDataSet(cmd);
}
public static DataSet PartTypeDs()
{
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
//Database db = DatabaseFactory.CreateDatabase("ifsConnection");
string sql = "SELECT TYPEID, TYPE_DESC FROM plm.MM_PART_TYPE_TAB";
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteDataSet(cmd);
}
/// <summary>
/// ȡ�����No�б�
/// </summary>
/// <param name="pid"></param>
/// <param name="contract"></param>
/// <returns></returns>
public static DataSet PartNoData(string pid, string contract)
{
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
//Database db = DatabaseFactory.CreateDatabase("ifsConnection");
string sql = "SELECT part_no FROM plm.MM_PART_TAB where parentid=" + pid + " and contract='" + contract + "'";
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteDataSet(cmd);
}
public static DataSet FindInvPartFamilyDataset()
{
//Database db = DatabaseFactory.CreateDatabase("ifsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
string sql = " select PART_PRODUCT_FAMILY, IFSAPP.INVENTORY_PRODUCT_FAMILY_API.Get_Description(PART_PRODUCT_FAMILY) familyname from (SELECT distinct PART_PRODUCT_FAMILY FROM IFSAPP.inventory_part)";
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteDataSet(cmd);
}
public static DataSet FindInvPartDimDataset()
{
// Database db = DatabaseFactory.CreateDatabase("ifsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
string sql = "SELECT distinct dim_quality FROM IFSAPP.inventory_part";
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteDataSet(cmd);
}
/// <summary>
/// Executes the data set.
/// </summary>
/// <param name="commandType">Type of the command.</param>
/// <param name="commandText">The command text.</param>
/// <returns></returns>
public static DataSet ExecuteDataSet(CommandType commandType, string commandText)
{
OracleDatabase database = new OracleDatabase(ConnectionString);
return database.ExecuteDataSet(commandType, commandText);
}
/// <summary>
/// Executes the data set.
/// </summary>
/// <param name="transactionManager">The transaction manager.</param>
/// <param name="storedProcedureName">Name of the stored procedure.</param>
/// <param name="parameterValues">The parameter values.</param>
/// <returns></returns>
//public DataSet ExecuteDataSet(TransactionManager transactionManager, string storedProcedureName, params object[] parameterValues)
//{
// Database database = transactionManager.Database;
// return database.ExecuteDataSet(transactionManager.TransactionObject, storedProcedureName, parameterValues);
//}
/// <summary>
/// Executes the data set.
/// </summary>
/// <param name="command">The command wrapper.</param>
/// <returns></returns>
public static DataSet ExecuteDataSet(DbCommand command)
{
OracleDatabase database = new OracleDatabase(ConnectionString);
return database.ExecuteDataSet(command);
}
/// <summary>
/// Executes the data set.
/// </summary>
/// <param name="storedProcedureName">Name of the stored procedure.</param>
/// <param name="parameterValues">The parameter values.</param>
/// <returns></returns>
public static DataSet ExecuteDataSet(string storedProcedureName, params object[] parameterValues)
{
OracleDatabase database = new OracleDatabase(ConnectionString);
return database.ExecuteDataSet(storedProcedureName, parameterValues);
}
/// <summary>
/// ������������Ŀ�б�
/// </summary>
/// <returns></returns>
public static DataSet FindActivityDs(string id)
{
// Database db = DatabaseFactory.CreateDatabase("ifsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
string sql = "SELECT activity_seq,description,sub_project_id,activity_no FROM IFSAPP.ACTIVITY T WHERE T.PROJECT_ID =:id ORDER BY t.activity_seq";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "id", DbType.String, id);
return db.ExecuteDataSet(cmd);
}
/// <summary>
/// 返回数据集
/// </summary>
/// <param name="sr"></param>
/// <param name="dat"></param>
public static DataSet getds(string sr)
{
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
string sql = sr;
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteDataSet(cmd);
}
public static DataSet FindInvPartInfByPartNameDataset(string partname,string site)
{
// Database db = DatabaseFactory.CreateDatabase("ifsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
string sql = "SELECT PART_NO,DESCRIPTION FROM IFSAPP.inventory_part where DESCRIPTION like '%" + partname + "%' and CONTRACT='" + site + "'";
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteDataSet(cmd);
}
/// <summary>
/// ��øýڵ����е��ӽڵ�
/// </summary>
/// <param name="nodeid"></param>
/// <returns></returns>
public static DataSet GetSubNodes(int nodeid)
{
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
//OracleDatabase db = new OracleDatabase(UserSecurity.ConnectionString);
string sql = "SELECT PARENT_INDEX,TEXT FROM PLM.TREENODES_TAB WHERE PARENT_ID=" + nodeid + " ORDER BY PARENT_INDEX";
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteDataSet(cmd);
}
/// <summary>
/// �������NOȡ�����Spec�б�
/// </summary>
/// <param name="pid"></param>
/// <param name="contract"></param>
/// <returns></returns>
public static DataSet PartSpecDs(string pno, string contract)
{
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
//Database db = DatabaseFactory.CreateDatabase("ifsConnection");
string sql = "SELECT part_no,part_spec FROM plm.MM_PART_TAB where part_no like '%" + pno + "%' and contract='" + contract + "'";
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteDataSet(cmd);
}
public static DataSet FindSelectResultDS(string sql)
{
//Database db = DatabaseFactory.CreateDatabase("ifsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteDataSet(cmd);
}
/// <summary>
/// ����������������б�
/// </summary>
/// <returns></returns>
public static DataSet QueryPartPara(string sql)
{
// Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteDataSet(cmd);
}
public static DataSet ReasonCodeDs(string Pid, string ACT_SEQ)
{
OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
//Database db = DatabaseFactory.CreateDatabase("ifsConnection");
string sql = "SELECT distinct REASON_CODE, IFSAPP.YRS_REQUISITION_REASON_API.GET_DESCRIPTION(REASON_CODE) REASON_DESC FROM IFSAPP.PROJECT_MISC_PROCUREMENT WHERE PROJECT_ID =:PROID AND (ACTIVITY_SEQ =:ACT_SEQ)";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "PROID", DbType.String, Pid);
db.AddInParameter(cmd, "ACT_SEQ", DbType.String, ACT_SEQ);
return db.ExecuteDataSet(cmd);
}
/// <summary>
/// ��������Project�б�
/// </summary>
/// <returns></returns>
public static DataSet FindProDataset()
{
OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
//Database db = DatabaseFactory.CreateDatabase("ifsConnection");
string sql = "SELECT * FROM IFSAPP.PROJECT where project_id in ('YRO-06-194','YRO-06-209','YRO-197-C', 'YRO-06-201','YRO-07-218','YRO-07-233','YRO-07-211', 'YRO-06-206','YRO-11-266','YCRO11-256','YRO-11MA20','YRO-06-195','YRO-07-212','YRO-11-267', 'YRO-06-196','YRO-11-264','YRO-11-265') order by project_id";
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteDataSet(cmd);
}
/// <summary>
/// ��ȡERP���������ص�MEO�ŵļ���
/// </summary>
/// <param name="Pid"></param>
/// <param name="PartNo"></param>
/// <returns></returns>
public static DataSet RequisionNoDs(string Pid, string PartNo)
{
OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
// Database db = DatabaseFactory.CreateDatabase("ifsConnection");
string sql = "SELECT distinct P_REQUISITION_NO FROM IFSAPP.PROJECT_MISC_PROCUREMENT WHERE PROJECT_ID =:PROID AND (PART_NO =:partno)";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "PROID", DbType.String, Pid);
db.AddInParameter(cmd, "partno", DbType.String, PartNo);
return db.ExecuteDataSet(cmd);
}
/// <summary>
/// ��������Project�б�
/// </summary>
/// <returns></returns>
public static DataSet FindReasonDataset()
{
OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
//Database db = DatabaseFactory.CreateDatabase("ifsConnection");
string sql = "SELECT * FROM IFSAPP.YRS_REQUISITION_REASON_TAB";
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteDataSet(cmd);
}
public static DataSet UnitDs(string Pid, string ACT_SEQ)
{
OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
// Database db = DatabaseFactory.CreateDatabase("ifsConnection");
string sql = "SELECT distinct IFSAPP.INVENTORY_PART_API.GET_UNIT_MEAS(SITE, PART_NO) UNIT FROM IFSAPP.PROJECT_MISC_PROCUREMENT WHERE PROJECT_ID =:PROID AND (ACTIVITY_SEQ =:ACT_SEQ)";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "PROID", DbType.String, Pid);
db.AddInParameter(cmd, "ACT_SEQ", DbType.String, ACT_SEQ);
return db.ExecuteDataSet(cmd);
}
/// <summary>
/// ������������Ŀ�б�
/// </summary>
/// <returns></returns>
public static DataSet FindAllSubPro(string id)
{
OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
//Database db = DatabaseFactory.CreateDatabase("ifsConnection");
string sql = "SELECT t.project_id, t.sub_project_id,nvl(parent_sub_project_id,'0') parent_sub_project_id,t.description FROM IFSAPP.SUB_PROJECT T WHERE T.PROJECT_ID =:id ORDER BY t.sub_project_id";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "id", DbType.String, id);
return db.ExecuteDataSet(cmd);
}
private void ModifyNode_Load(object sender, EventArgs e)
{
#region ��ʼ����չ��������ؼ�
//checkedListBox1.SelectionMode= SelectionMode.MultiSimple;
comboBox1.ImageList = imageList1;
comboBox2.ImageList = imageList1;
for (int i = 0; i < imageList1.Images.Count; i++)
{
comboBox1.Items.Add(new ComboBoxExItem(i.ToString(), i));
comboBox2.Items.Add(new ComboBoxExItem(i.ToString(), i));
}
#endregion
textBox2.Text = currentnode.Text;
textBox3.Text = currentnode.Name;
comboBox1.Text = currentnode.ImageIndex.ToString();
comboBox2.Text = currentnode.SelectedImageIndex.ToString();
flag = DetailInfo.Categery.TreeNodes.GetNodeFlag(Convert.ToInt32(currentnode.Tag));
if (flag == "N")
{
radioBtn.Checked = true;
radioButton1.Checked = false;
checkedListBox1.Visible = false;
}
else
{
radioButton1.Checked = true;
radioBtn.Checked = false;
checkedListBox1.Visible = true;
}
string sql = "select t.privilege_id,t.privilege_flag from privilege_tab t where t.privilege_cata='Pipe' order by privilege_id";
DataBind(sql);
List<int> privilegeids = PrivilegeNode.GetPrivilegeIds(Convert.ToInt32(currentnode.Tag));
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DataSet ds=db.ExecuteDataSet (CommandType.Text, sql );
//string aa = checkedListBox1.GetItemText(checkedListBox1.Items[1]);
for (int j = 0; j < checkedListBox1.Items.Count; j++)
{
for (int i = 0; i < privilegeids.Count; i++)
{
if (ds.Tables[0].Rows[j]["privilege_id"].ToString ()== privilegeids[i].ToString())
checkedListBox1.SetItemChecked(j, true);
}
}
}
