public void InsertPTTBService(string id, string code)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_InsertPTTBService",
new object[] { id, code });
}
public void UpdateTempl(string text, string id, string loginName)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_UpdateTempl",
new object[] { text, id, loginName });
}
public void DeletePTTBPPLFromAllGroup(string code)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_DeletePTTBPPLFromAllGroup",
new object[] { code });
}
public void InsertPTTService(string id, string EmployeeID)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_InsertPTTService",
new object[] { id, EmployeeID });
}
public void UpdatePTTBPPL(string EmployeeID, string MOBILE, string logname)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_UpdatePTTBPPL",
new object[] { EmployeeID, MOBILE, logname });
}
public void DeletePTTBPPL(string group_id, string d, string code)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_DeletePTTBPPL",
new object[] { group_id, code });
}
public void InsertGCService(string id, string EmployeeID, string company_id)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_InsertGCService",
new object[] { id, EmployeeID, company_id });
}
public void updateCSPPL(string EmployeeID, string MOBILE)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_updateCSPPL",
new object[] { EmployeeID, MOBILE });;
}
public void DeleteAdmin(string person_id)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_DeleteAdmin",
new object[] { person_id });
}
public void insertTempl(string text, string loginName)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_INSERTTempl",
new object[] { text, loginName });
}
public void DeleteGTempl(string id)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_DeleteTempl",
new object[] { id });
}
public void UpdateLogMobile(string mobile, string logid)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_UpdateLogMobile",
new object[] { mobile, logid });
}
public void DeletePTTPPL(string group_id, string d, string person_id)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_DeletePTTPPL",
new object[] { group_id, d, person_id });
}
public void insertLog(string Employee_ID, string Department_ID, string TO_Original, string content, string loginName, int status, string DETAIL, string SMID, string groupid, string name, string unit)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_INSERTLOG",
new object[] { Employee_ID, Department_ID, TO_Original, content, loginName, status, DETAIL, SMID, groupid, name, unit });
}
public void UpdateLog(int sta, string DETAIL, string SMID, string logid)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_updatelog",
new object[] { sta, DETAIL, SMID, logid });
}
public void UpdateGroup(string grpid, string grpname, string logname)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_UpdateGroup",
new object[] { grpid, grpname, logname });
}
public void updateDisplayGroup(string st, string chk, int vsh, string logname)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_updateDisplayGroup",
new object[] { st, chk, vsh, logname });
}
public void InsertGCPPL(string EmployeeID, string Name, string company_id, string MOBILE, string posname, string logname)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_InsertGCPPL",
new object[] { EmployeeID, Name, company_id, MOBILE, posname, logname });
}
public void DeletePTTPPLFromAllGroup(string person_id)
{
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_DeletePTTPPLFromAllGroup",
new object[] { person_id });
}
public void DeleteGCPPL(string group_id, string d, string person_id, string company_id)
{
string group = group_id.Substring(0, 1);
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_DeleteGCPPL",
new object[] { group_id, person_id, company_id });
}
private void DeletePPL(string group_id)
{
string group = group_id.Substring(0, 1);
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_DeletePPL",
new object[] { group, group_id });
}
public void InsertNewGroup(string Group_id, string Group_name, int level, string master_Group_id, string logname)
{
Group_id = Group_id.Substring(3, Group_id.Length - 3);
master_Group_id = master_Group_id.Substring(3, master_Group_id.Length - 3);
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_InsertNewGroup",
new object[] { Group_id, Group_name, level, master_Group_id, logname });
}
public void DeleteGroup(string Group_id)
{
Group_id = Group_id.Substring(3, Group_id.Length - 3);
OracleQuery2 ora = new OracleQuery2();
ora.ExecuteProcedureNonquery("SMS_DeleteGroup",
new object[] { Group_id });
DeletePPL(Group_id);
}
