operate_accept.java

电信的网厅的整站代码

package com.doone.fj1w.info_manage;
import com.doone.data.*;
public class operate_accept {
  DacClient _dac=null;
  Integer id=null;
  DataTable _dt=null;
  DataTable tdt=null;
  DataRow dr=null;
  public operate_accept() {
  _dac=new DacClient();
  }
  public DataTable getInfo()
  {
    String sql="select * from Td_Product where ProductId=?";
    Object[] _object=new Object[1];
    _object[0]=id;
    try {
      _dt = _dac.executeQuery(sql,_object);
      dr=_dt.getRow(0);
    }
    catch (Exception ex) {
    }
    return _dt;
  }
  public DataTable getInfo1()
{
  String sql="select * from Td_Product ";

  try {
    _dt = _dac.executeQuery(sql);
    dr=_dt.getRow(0);
  }
  catch (Exception ex) {
  }
  return _dt;
}

  public DataRow DatanewRow()
  {
    DataRow sdr=getInfo().newRow();
    return sdr;
  }
  public void deleteInfo(String t)
  {String sql="delete from Td_Product where ProductId=?";
    Object[] _object=new Object[1];
    _object[0]=Integer.valueOf(t);
    try {
      _dac.executeUpdate(sql, 1000, _object);
    }
    catch (Exception ex) {
    }
  }
  public void updateInfo(DataRow sdr,boolean t)
  {  if(t==true)
      {
        Long id=new Long(_dac.getSequence("SEQ_PRODUCTID"));
      sdr.setValue("ProductId",id);}
      try {
    _dac.updateDataRow(sdr);
  }
  catch (Exception ex) {
  }
  }
  public String getphotocal()
  {
    return dr.getString("ArticleId");
  }
  public String getCity()
  {
    String sql="select CityName from TD_City where CityCode="+dr.getString("CityCode");
    DataTable dt = null;
    try {
      dt = _dac.executeQuery(sql);
    }
    catch (Exception ex) {
    }
    DataRow _dr=dt.getRow(0);
     return  _dr.getString(0);
  }
  public void setId(String id) {
    this.id = Integer.valueOf(id);
  }
  public DataTable getprodFun()
  {
    String sql="select * from Td_ProdFun where ProductId=?";
    Object[] _object=new Object[1];
    _object[0]=id;
    DataTable dt=null;
    try {
      dt = _dac.executeQuery(sql, _object);
    }
    catch (Exception ex) {
    }
    return dt;
  }
  public String getProductCode()
  {return dr.getString("ProductCode");
  }
  public String getProductName()
  {
    return dr.getString("ProductName");
  }
  public String getUpProductId()
  { return dr.getString("UpProductId");
  }
  public void modify_product(String t,String pid,String PWDLEVEL,String CALLERTYPE,String OUTPUT)
  {
    String sql="update td_prodcortrol set State=?,PWDLEVEL=?,CALLERTYPE=?,OUTPUT=? where ProductId=?";
    Object[] _object=new Object[5];
    _object[0]=t;
    _object[1]=PWDLEVEL;
    _object[2]=CALLERTYPE;
    _object[3]=OUTPUT;
    _object[4]=pid;
    try {
      _dac.executeQuery(sql, _object);
    }
    catch (Exception ex) {
    }
  }
  public void modify_Td_ProdFun(String Output,String PwdLevel,String CallerType,String FunAuto,String ProdFunId)
  {
    String sql="update Td_ProdFun set Output=?,PwdLevel=?,CallerType=?,FunAuto=? where ProdFunId=?";
    Object[] _object=new Object[5];
    _object[0]=Output;
    _object[1]=PwdLevel;
    _object[2]=CallerType;
    _object[3]=FunAuto;
    _object[4]=ProdFunId;
    try {
      _dac.executeUpdate(sql, 10000, _object);
    }
    catch (Exception ex) {
    }
  }
  public String getdownlist(String column,String key)
  {
    String out="";
    if(tdt==null)
    {
      return out="";
    }
     for(int i=0;i<tdt.getRows().getCount();i++)
      { DataRow sdr=tdt.getRow(i);
        if (sdr.getString("PARANAME").equals(column)) {
          if (sdr.getString(0).equals(key)) {
            out = out + "<option value='" + sdr.getString(0) +
                "' selected='selected'>" + sdr.getString(1) +
                "</option>";
          }
          else {
            out = out + "<option value='" + sdr.getString(0) + "' >" +
                sdr.getString(1) +
                "</option>";
          }
        }
        }
    return out;
  }
  public void getfunTable()
  {  String sql="select  PARAVALUE,PARADESC,PARANAME from TS_ConfigSub ";
    try
    {
      tdt= _dac.executeQuery(sql);
    }
 catch (Exception ex) {
 }

  }
  public DataRow getprodcontrol()
  {
    String sql="select * from td_prodcortrol where PRODUCTID="+id;
    try {
      DataTable data=_dac.executeQuery(sql);
      DataRow sdr=data.getRow(0);
      return sdr;
    }
    catch (Exception ex) {
    }
    return null;
  }
}