/// <summary>
/// ��ӽ�ɫ��Ȩ��
/// </summary>
/// <param name="roleName">��ɫ����</param>
/// <param name="privilegeId">Ȩ��ID</param>
/// <param name="projectIDs">��ĿID����</param>
/// <returns></returns>
public static int AddPrivilege(string roleName, int privilegeId, string projectIDs)
{
string sql = "INSERT INTO PLM.ROLEINPRIVILEGE_TAB (ROLENAME, PRIVILEGE_ID, PROJECT_ID) VALUES (:rolename, :privilegeid, :projectids)";
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "rolename", DbType.String, roleName);
db.AddInParameter(cmd, "privilegeid", DbType.Int32, privilegeId);
db.AddInParameter(cmd, "projectids", DbType.String, projectIDs);
return db.ExecuteNonQuery(cmd);
}
/// <summary>
/// ��ӽ�ɫ�̳�
/// </summary>
/// <param name="roleName"></param>
/// <param name="inheritRoleName"></param>
/// <returns></returns>
public static void AddInherit(string roleName, string[] inheritRoleName)
{
string sql = "INSERT INTO PLM.ROLEINHERIT_TAB (ROLENAME, INHERITNAME) VALUES (:rolename, :inheritname)";
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "rolename", DbType.String, roleName);
foreach (string inheritName in inheritRoleName)
{
if (inheritName == string.Empty) continue;
if (cmd.Parameters.Contains("inheritname")) cmd.Parameters.RemoveAt("inheritname");
db.AddInParameter(cmd, "inheritname", DbType.String, inheritName);
db.ExecuteNonQuery(cmd);
}
}
/// <summary>
/// Executes the non query.
/// </summary>
/// <param name="commandType">Type of the command.</param>
/// <param name="commandText">The command text.</param>
/// <returns></returns>
public static int ExecuteNonQuery(CommandType commandType, string commandText)
{
OracleDatabase database = new OracleDatabase(ConnectionString);
return database.ExecuteNonQuery(commandType, commandText);
}
/// <summary>
/// ���Ľ�ɫ��״̬
/// </summary>
/// <returns></returns>
public static int UpdateState(string roleName, RoleState us)
{
//OracleDatabase db = new OracleDatabase(UserSecurity.ConnectionString);
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
string sql = "UPDATE PLM.ROLE_TAB SET STATE=:state WHERE LOWER(ROLENAME)=:rolename";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "state", DbType.String, us.ToString());
db.AddInParameter(cmd, "rolename", DbType.String, roleName.ToLower());
return db.ExecuteNonQuery(cmd);
}
public int Add()
{
// Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand("INSERT INTO plm.MM_IFS_STA_PART_TAB(ERP_PART_NO,STA_PART_NO,PART_NAME,PROJECTID,ACTIVITYSEQ,SITE,STA_IF,CREATOR) VALUES (:erppartno,:staPartno,:partname,:projectid,:actSeq,:site,:staIf,:creator)");
db.AddInParameter(cmd, "erppartno", DbType.String,ERP_PART_NO);
db.AddInParameter(cmd, "staPartno", DbType.String, STA_PART_NO);
db.AddInParameter(cmd, "partname", DbType.String, PART_NAME);
db.AddInParameter(cmd, "projectid", DbType.String, PROJECTID);
db.AddInParameter(cmd, "actSeq", DbType.Int32, ACTIVITYSEQ);
db.AddInParameter(cmd, "site", DbType.String, SITE);
db.AddInParameter(cmd, "staIf", DbType.String, STA_IF);
db.AddInParameter(cmd, "creator", DbType.String, CREATOR);
return db.ExecuteNonQuery(cmd);
}
public int Add()
{
// Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand("INSERT INTO PLM.MM_PART_PARAMETER_TAB(description,blockid,systemid,ecprojectid,last_flag,PART_NO,CONTRACT,WEIGHT_SINGLE,PREDICTION_QTY,PREDICTION_ALERT,COEFFICIENT_ERP,PROJECTID,PREDICT_CREATOR,PROJECT_ZONE,DISCIPLINE,FIRSTBATCH_QTY,FIRSTBATCH_DATE,SECONDBATCH_QTY,SECONDBATCH_DATE,PART_TYPE,FINAL_PREDICTION_QTY,OPERATOR,MODIFY_REASON,PREDICT_DATE,UNIT) VALUES (:description,:blockid,:systemid,:ecprojectid,:lastflag,:partno,:site,:weightSingle,:preQty,:pre_alert,:coeficient,:PROJECTID,:creator,:predictzone,:discipline,:firstpreQty,:firstpreDate,:secondpreQty,:secondpreDate,:part_type,:finalpreQty,:operator,:modreason,:predictdate,:unitmeas)");
db.AddInParameter(cmd, "description", DbType.String, DESCRIPTION);
db.AddInParameter(cmd, "blockid", DbType.String, BLOCKID);
db.AddInParameter(cmd, "systemid", DbType.Int32, SYSTEMID);
db.AddInParameter(cmd, "ecprojectid", DbType.Int32, ECPROJECTID);
db.AddInParameter(cmd, "lastflag", DbType.Int32, LAST_FLAG );
db.AddInParameter(cmd, "partno", DbType.String, PART_NO);
db.AddInParameter(cmd, "site", DbType.String, CONTRACT);
db.AddInParameter(cmd, "weightSingle", DbType.Decimal, WEIGHT_SINGLE);
db.AddInParameter(cmd, "preQty", DbType.Decimal, PREDICTION_QTY);
db.AddInParameter(cmd, "pre_alert", DbType.Decimal, PREDICTION_ALERT);
db.AddInParameter(cmd, "coeficient", DbType.Decimal, COEFFICIENT_ERP);
db.AddInParameter(cmd, "PROJECTID", DbType.String, PROJECTID);
db.AddInParameter(cmd, "creator", DbType.String, PREDICT_CREATOR);
db.AddInParameter(cmd, "predictzone", DbType.String, PROJECT_ZONE);
db.AddInParameter(cmd, "discipline", DbType.String, DISCIPLINE);
db.AddInParameter(cmd, "firstpreQty", DbType.Decimal, FIRSTBATCH_QTY);
db.AddInParameter(cmd, "firstpreDate", DbType.DateTime, FIRSTBATCH_DATE);
db.AddInParameter(cmd, "secondpreQty", DbType.Decimal, SECONDBATCH_QTY);
db.AddInParameter(cmd, "secondpreDate", DbType.DateTime, SECONDBATCH_DATE);
db.AddInParameter(cmd, "part_type", DbType.String, PART_TYPE);
db.AddInParameter(cmd, "finalpreQty", DbType.Decimal, FINAL_PREDICTION_QTY);
db.AddInParameter(cmd, "predictdate", DbType.DateTime, PREDICT_DATE);
db.AddInParameter(cmd, "operator", DbType.String, OPERATOR);
db.AddInParameter(cmd, "modreason", DbType.String, MODIFY_REASON);
db.AddInParameter(cmd, "unitmeas", DbType.String, UNIT);
return db.ExecuteNonQuery(cmd);
}
/// <summary>
/// ɾ��Ԥ��
/// </summary>
/// <param name="contractno">��</param>
/// <param name="pid">��ĿID</param>
/// <param name="dpline">��Ŀרҵ</param>
/// <returns></returns>
public static void DeleteEstimate(string contractno,string pid,string dpline)
{
// Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand("update PLM.MM_PART_PARAMETER_TAB t set t.last_flag=0 where CONTRACT =:mSite and projectid=:pid and DISCIPLINE =:dpid");
db.AddInParameter(cmd, "mSite", DbType.String, contractno);
db.AddInParameter(cmd, "pid", DbType.String, pid);
db.AddInParameter(cmd, "dpid", DbType.String, dpline);
db.ExecuteNonQuery(cmd);
}
public int Update()
{
// Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand("update plm.MM_PART_RATION_TAB set DISCIPLINE=:dpname,PART_NO=:partno,CONTRACT=:contract,P_REQUISITION_NO=:reqNo,ISSUED_QTY=:issqty,ISSUED_DATE=:issDate,IF_INVENTORY=:isInv,PURPOSE=:purpose,BLOCK_ID=:BLOCK_ID,REASON_CODE=:reasoncode,DESIGN_CODE=:designcode,REMARK=:information,UPDATE_DATE=sysdate,PROJECT_ID=:projectId,PART_ZONE=:partzone,part_discipline=:partdp,PART_FX= :actId,PART_TYPE=:parttype,unit=:unit,PART_NAME=:partname where RATION_ID=:rationId");
db.AddInParameter(cmd, "partno", DbType.String, PART_NO);
db.AddInParameter(cmd, "partname", DbType.String, PART_NAME);
db.AddInParameter(cmd, "contract", DbType.String, CONTRACT);
db.AddInParameter(cmd, "reqNo", DbType.String, P_REQUISITION_NO);
db.AddInParameter(cmd, "issqty", DbType.Single, ISSUED_QTY);
db.AddInParameter(cmd, "issDate", DbType.Date, ISSUED_DATE);
db.AddInParameter(cmd, "isInv", DbType.String, IF_INVENTORY);
db.AddInParameter(cmd, "purpose", DbType.String, PURPOSE);
db.AddInParameter(cmd, "BLOCK_ID", DbType.String, BLOCK_ID);
db.AddInParameter(cmd, "reasoncode", DbType.String, REASON_CODE);
db.AddInParameter(cmd, "designcode", DbType.String, DESIGN_CODE);
db.AddInParameter(cmd, "information", DbType.String, REMARK);
db.AddInParameter(cmd, "projectId", DbType.String, PROJECT_ID);
db.AddInParameter(cmd, "partzone", DbType.String, PART_ZONE);
db.AddInParameter(cmd, "partdp", DbType.String, PART_DISCIPLINE);
db.AddInParameter(cmd, "unit", DbType.String, UNIT);
db.AddInParameter(cmd, "actId", DbType.String, PART_FX);
db.AddInParameter(cmd, "parttype", DbType.String, PART_TYPE);
db.AddInParameter(cmd, "rationId", DbType.Int32, RATION_ID);
return db.ExecuteNonQuery(cmd);
}
/// <summary>
/// ����MEOMSS��������ERP ID
/// </summary>
/// <param name="MEOMSSid"></param><param name="ERPid"></param>
/// <returns></returns>
public static int UPERPID(int MEOMSSid, int ERPid)
{
string sql = "update project_drawing_tab t set t.related_drawing=:ERPid where t.drawing_id=:MEOMSSid";
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "MEOMSSid", DbType.Int32, MEOMSSid);
db.AddInParameter(cmd, "ERPid", DbType.Int32, ERPid);
return db.ExecuteNonQuery(cmd);
}
/// <summary>
/// parentIndex���μ�1
/// </summary>
/// <param name="nodeid"></param>
/// <param name="beforenode"></param>
/// <returns></returns>
public static int UpdateParentIndexDel(int nodeid, int beforenode, int dropindex)
{
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
string sql = "UPDATE (SELECT PARENT_INDEX FROM PLM.TREENODES_TAB S WHERE S.PARENT_ID=" + nodeid + ")T SET T.PARENT_INDEX=T.PARENT_INDEX-1 WHERE T.PARENT_INDEX<" + dropindex + " AND T.PARENT_INDEX>=" + beforenode;
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteNonQuery(cmd);
}
/// <summary>
/// ����parentIndexֵ
/// </summary>
/// <param name="nodeid"></param>
/// <param name="num"></param>
/// <returns></returns>
public static int UpdateParentIndex(int nodeid,int num)
{
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
string sql = "UPDATE PLM.TREENODES_TAB SET PARENT_INDEX=" + num + " WHERE ID=" + nodeid;
DbCommand cmd = db.GetSqlStringCommand(sql);
return db.ExecuteNonQuery(cmd);
}
/// <summary>
/// Executes the non query.
/// </summary>
/// <param name="command">The command wrapper.</param>
public static void ExecuteNonQuery(DbCommand command)
{
OracleDatabase database = new OracleDatabase(ConnectionString);
database.ExecuteNonQuery(command);
}
/// <summary>
/// Executes the non query.
/// </summary>
/// <param name="storedProcedureName">Name of the stored procedure.</param>
/// <param name="parameterValues">The parameter values.</param>
/// <returns></returns>
public static int ExecuteNonQuery(string storedProcedureName, params object[] parameterValues)
{
OracleDatabase database = new OracleDatabase(ConnectionString);
return database.ExecuteNonQuery(storedProcedureName, parameterValues);
}
/// <summary>
/// Executes the non query.
/// </summary>
/// <param name="transactionManager">The transaction manager.</param>
/// <param name="command">The command wrapper.</param>
public void ExecuteNonQuery(TransactionManager transactionManager, DbCommand command)
{
OracleDatabase database = new OracleDatabase(ConnectionString);
database.ExecuteNonQuery(command, transactionManager.TransactionObject);
}
/// <summary>
/// Executes the non query.
/// </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 int ExecuteNonQuery(TransactionManager transactionManager, string storedProcedureName, params object[] parameterValues)
{
OracleDatabase database = new OracleDatabase(ConnectionString);
return database.ExecuteNonQuery(transactionManager.TransactionObject, storedProcedureName, parameterValues);
}
/// <summary>
/// ����ϵͳ�ڵĶ����״̬
/// </summary>
/// <param name="id"></param>
public static int UpdateMSSState(string id,int strstate)
{
// Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
string sql = "UPDATE plm.MM_PART_RATION_TAB set state='" + strstate + "' WHERE RATION_ID=:id";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "id", DbType.String, id);
return db.ExecuteNonQuery(cmd);
}
public int Add()
{
// Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand("INSERT INTO plm.MM_PART_RATION_TAB(PART_NO,CONTRACT,P_REQUISITION_NO,ISSUED_QTY,ISSUED_DATE,IF_INVENTORY,PURPOSE,BLOCK_ID,REASON_CODE,DESIGN_CODE,REMARK,CREATE_DATE,CREATER,PROJECT_ID,part_zone,part_discipline,part_fx,part_type,unit,PART_NAME) VALUES (:partno,:contract,:requisionNo,:requireqty,:requirDate,:isInventory,:purpose,:blockID,:reasoncode,:designcode,:information,sysdate,:creater,:projectId,:parentProId,:subProId,:actId,:parttype,:unit,:partname)");
db.AddInParameter(cmd, "partno", DbType.String, PART_NO);
db.AddInParameter(cmd, "contract", DbType.String, CONTRACT);
db.AddInParameter(cmd, "requisionNo", DbType.String, P_REQUISITION_NO);
db.AddInParameter(cmd, "requireqty", DbType.Single, ISSUED_QTY);
db.AddInParameter(cmd, "requirDate", DbType.Date, ISSUED_DATE);
db.AddInParameter(cmd, "isInventory", DbType.String, IF_INVENTORY);
db.AddInParameter(cmd, "purpose", DbType.String, PURPOSE);
db.AddInParameter(cmd, "blockID", DbType.String, BLOCK_ID);
db.AddInParameter(cmd, "reasoncode", DbType.String, REASON_CODE);
db.AddInParameter(cmd, "designcode", DbType.String, DESIGN_CODE);
db.AddInParameter(cmd, "information", DbType.String, INFORMATION);
db.AddInParameter(cmd, "creater", DbType.String, CREATER);
db.AddInParameter(cmd, "projectId", DbType.String, PROJECT_ID);
db.AddInParameter(cmd, "parentProId", DbType.String, PART_ZONE);
db.AddInParameter(cmd, "subProId", DbType.String, PART_DISCIPLINE);
db.AddInParameter(cmd, "actId", DbType.String, PART_FX);
db.AddInParameter(cmd, "parttype", DbType.String, PART_TYPE);
db.AddInParameter(cmd, "unit", DbType.String, UNIT);
db.AddInParameter(cmd, "partname", DbType.String, PART_NAME);
;
return db.ExecuteNonQuery(cmd);
}
/// <summary>
/// ������Ŀ��רҵ����MEOMSS�ĵ�ǰ��ˮ��
/// </summary>
/// <param name="dpid"></param>
/// <returns></returns>
public static int UPManualNo(int dpid, int pid)
{
string sql = "update project_discipline_oid t set t.o_id=t.o_id+1 where t.P_ID=:pid and t.D_ID=:dpid";
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "dpid", DbType.Int32, dpid);
db.AddInParameter(cmd, "pid", DbType.Int32, pid);
return db.ExecuteNonQuery(cmd);
}
/// <summary>
/// ɾ��Ԥ��
/// </summary>
/// <param name="seqNo"></param>
/// <returns></returns>
public static int Delete(int seqNo)
{
// Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand("delete PLM.MM_PART_PARAMETER_TAB t where SEQUENCE_ID=:seqNo");
db.AddInParameter(cmd, "seqNo", DbType.Int32, seqNo);
return db.ExecuteNonQuery(cmd);
}
/// <summary>
/// ��˷����MEO����
/// </summary>
/// <param name="id"></param>
/// <param name="flag"></param>
/// <returns></returns>
public static int ApproveMEO(int id,string flag)
{
// Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
string sql = "UPDATE plm.MM_PART_REQUIRE_TAB SET STATE='"+flag+"' WHERE require_ID=:id";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "id", DbType.Int32, id);
return db.ExecuteNonQuery(cmd);
}
/// <summary>
/// ȷ��Ԥ��
/// </summary>
/// <param name="mainid"></param>
public static void DeleteEstimate(string seqidList)
{
// Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand("update PLM.MM_PART_PARAMETER_TAB t set t.confirmed='Y' where sequence_id in (" + seqidList + ")");
string stringlist = "update PLM.MM_PART_PARAMETER_TAB t set t.confirmed='Y' where sequence_id in (" + seqidList + ")";
//db.AddInParameter(cmd, "dpid", DbType.String, seqidList);
db.ExecuteNonQuery(cmd);
}
/// <summary>
/// ɾ��MEO�ӱ��еļ�¼
/// </summary>
/// <param name="seqNo"></param>
/// <returns></returns>
public int MEODelete(int seqNo)
{
// Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand("update PLM.MM_PART_REQUIRELINE_TAB t set t.deleteflag='Y' where REQUIRE_ID=:seqNo");
db.AddInParameter(cmd, "seqNo", DbType.Int32, seqNo);
return db.ExecuteNonQuery(cmd);
}
public int Update()
{
//Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand("update PLM.MM_PART_PARAMETER_TAB t set t.createdate=sysdate,t.updatedate=sysdate, t.blockid=:blockid,t.systemid=:systemid,ecprojectid=:ecprojectid, t.unit=:unit,t.WEIGHT_SINGLE=:weightSingle,t.PREDICTION_QTY=:preQty,t.PREDICTION_ALERT=:pre_alert,t.COEFFICIENT_ERP=:coeficient, CREATOR=:creator where systemid=:systemid and PROJECTID=:projectid and last_flag=1 and t.PART_NO=:partno and CONTRACT=:site and t.creator=:creator");
db.AddInParameter(cmd, "projectid", DbType.String, PROJECTID);
db.AddInParameter(cmd, "partno", DbType.String, PART_NO);
db.AddInParameter(cmd, "site", DbType.String, CONTRACT);
db.AddInParameter(cmd, "weightSingle", DbType.Single, WEIGHT_SINGLE);
db.AddInParameter(cmd, "preQty", DbType.Decimal, PREDICTION_QTY);
db.AddInParameter(cmd, "pre_alert", DbType.Decimal, PREDICTION_ALERT);
db.AddInParameter(cmd, "coeficient", DbType.Decimal, COEFFICIENT_ERP);
db.AddInParameter(cmd, "creator", DbType.String, PREDICT_CREATOR);
db.AddInParameter(cmd, "unit", DbType.String, UNIT);
db.AddInParameter(cmd, "systemid", DbType.Int32, SYSTEMID);
db.AddInParameter(cmd, "ecprojectid", DbType.Int32, ECPROJECTID);
db.AddInParameter(cmd, "blockid", DbType.String, BLOCKID);
db.AddInParameter(cmd, "systemid", DbType.Int32, SYSTEMID);
return db.ExecuteNonQuery(cmd);
}
/// <summary>
/// ����MEO�ӱ�
/// </summary>
/// <returns></returns>
public int REQUIRE_Add()
{
// Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand("INSERT INTO plm.MM_PART_REQUIRE_TAB(DISCIPLINEID,ECPROJECTID,REQUIRE_NO,CONTRACT,INFORMATION,IS_INVENTORY,CREATE_DATE,CREATER,PROJECT_ID,SYSTEM_ID,PARTTYPE_ID,REMARK,ERP_PARTTYPE,ERP_DISCIPLINE,state) VALUES (:discpid,:ECprojectid,:requireno,:contract,:information,:isinventory,sysdate,:creater,:projectId,:sysId,:parttypeid,:remark,:ERPtypeid,:ERPDiscip,1)");
db.AddInParameter(cmd, "requireno", DbType.String, REQUIRE_NO);
db.AddInParameter(cmd, "contract", DbType.String, CONTRACT);
db.AddInParameter(cmd, "information", DbType.String, INFORMATION);
db.AddInParameter(cmd, "isinventory", DbType.String, IS_INVENTORY);
db.AddInParameter(cmd, "creater", DbType.String, CREATER);
//db.AddInParameter(cmd, "createrole", DbType.String, "MaterialApp");
db.AddInParameter(cmd, "projectId", DbType.String, PROJECT_ID);
db.AddInParameter(cmd, "sysId", DbType.String, SYSTEM_ID);
db.AddInParameter(cmd, "remark", DbType.String, REMARK);
db.AddInParameter(cmd, "parttypeid", DbType.String, PARTTYPE_ID);
db.AddInParameter(cmd, "ECprojectid", DbType.String, ECPROJECTID);
db.AddInParameter(cmd, "discpid", DbType.String, DISCIPLINEID);
db.AddInParameter(cmd, "ERPtypeid", DbType.String, ERP_PARTTYPE);
db.AddInParameter(cmd, "ERPDiscip", DbType.String, ERP_DISCIPLINE);
int requireId = 0;
int rowsAffected = db.ExecuteNonQuery(cmd);
if (rowsAffected > 0)
{
DbCommand cmdSeq = db.GetSqlStringCommand("SELECT PLM.MM_REQUIRE_SEQ.CURRVAL FROM DUAL");
requireId = Convert.ToInt32(db.ExecuteScalar(cmdSeq));
}
return requireId;
}
public int Delete()
{
// Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand("delete plm.MM_IFS_STA_PART_TAB where ERP_PART_NO=:erpPartno and PROJECTID=:proId and ACTIVITYSEQ=:actSeq and SITE=:site");
db.AddInParameter(cmd, "erpPartno", DbType.String, ERP_PART_NO);
db.AddInParameter(cmd, "proId", DbType.String, PROJECTID);
db.AddInParameter(cmd, "actSeq", DbType.Int32, ACTIVITYSEQ);
db.AddInParameter(cmd, "site", DbType.String, SITE);
return db.ExecuteNonQuery(cmd);
}
/// <summary>
/// ����MEO����
/// </summary>
/// <returns></returns>
public int REQUIRE_Update()
{
// Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand("UPDATE plm.MM_PART_REQUIRE_TAB set DISCIPLINEID=:discpid,CONTRACT=:contract,INFORMATION=:information,UPDATE_DATE=:updatedate,UPDATER=:updater,REMARK=:remark where require_id=:requireid");
db.AddInParameter(cmd, "requireid", DbType.Int32, REQUIRE_ID);
db.AddInParameter(cmd, "contract", DbType.String, CONTRACT);
db.AddInParameter(cmd, "information", DbType.String, INFORMATION);
db.AddInParameter(cmd, "updater", DbType.String, CREATER);
db.AddInParameter(cmd, "updatedate", DbType.Date, UPDATE_DATE);
db.AddInParameter(cmd, "remark", DbType.String, REMARK);
db.AddInParameter(cmd, "discpid", DbType.String, DISCIPLINEID);
int requireId = db.ExecuteNonQuery(cmd);
return requireId;
}
/// <summary>
/// �Խ�ɫ�Ƴ�Ȩ��
/// </summary>
/// <param name="roleName"></param>
/// <returns></returns>
public static int RemovePrivilege(string roleName)
{
string sql = "DELETE FROM PLM.ROLEINPRIVILEGE_TAB WHERE ROLENAME=:rolename";
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "rolename", DbType.String, roleName);
return db.ExecuteNonQuery(cmd);
}
/// <summary>
/// ɾ������
/// </summary>
/// <param name="id"></param>
public static int Del(int id)
{
// Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
string sql = "DELETE FROM plm.MM_PART_RATION_TAB WHERE RATION_ID=:id";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "id", DbType.Int32, id);
return db.ExecuteNonQuery(cmd);
}
/// <summary>
/// ����ERP�Ķ�����ˮ��
/// </summary>
/// <param name="id"></param>
public static int UpdateERPMSSNO(int id,string mssno)
{
// Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
string sql = "UPDATE plm.MM_PART_RATION_TAB set ERP_QUEUENO='"+mssno+"'WHERE RATION_ID=:id";
DbCommand cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "id", DbType.Int32, id);
return db.ExecuteNonQuery(cmd);
}
public int Update()
{
//Database db = DatabaseFactory.CreateDatabase("oidsConnection");
OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
DbCommand cmd = db.GetSqlStringCommand("update plm.MM_PART_REQUIRE_TAB set PART_NO=:partno,CONTRACT=:contract,REQUIRE_QTY=:requireqty,REQUIRE_DATE=:requirDate,REASON_CODE=:reasoncode,DESIGN_CODE=:designcode,INFORMATION=:information,IS_INVENTORY=:isinventory,UPDATE_DATE=sysdate,PROJECT_ID=:projectId,PARENT_SUB_PROJECT_ID=:parentProId,SUB_PROJECT_ID=:subProId,ACTIVITY_SEQ= :actId,REMARK=:remark,PART_NAME=:partname where REQUIRE_ID=:requireId");
db.AddInParameter(cmd, "partno", DbType.String, PART_NO);
db.AddInParameter(cmd, "requireId", DbType.Int32, REQUIRE_ID);
return db.ExecuteNonQuery(cmd);
}
