/// <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); } } }