protected DPManager.Code.dpDBRequest objRequest = new DPManager.Code.dpDBRequest() ;
objRequest对象的类的代码: using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using System.Text.RegularExpressions; using System.IO; using System.Web.Mail; using System.Text; using System.Xml; using Microsoft.Web.UI.WebControls;namespace DPManager.Code { /// <summary> /// dpDBRequest 的摘要说明。 /// </summary> public class dpDBRequest { protected tree.config connConfig;
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Text.RegularExpressions;
using System.IO;
using System.Web.Mail;
using System.Text;
using System.Xml;
using Microsoft.Web.UI.WebControls;namespace DPManager.Code
{
/// <summary>
/// dpDBRequest 的摘要说明。
/// </summary>
public class dpDBRequest
{
protected tree.config connConfig;
public dpDBRequest()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
// ''''''''''''''''''''''''''DB class''''''''''''''''''''''''''''''''''''''''''
// ''添加记录类
public void AddRequest(string strREQUEST_CODE,string strREQUEST_BY,string strREQUEST_FROM,int intSTATUS,int intREQUEST_TYPE,string strDESCRIPTION,string strSYSTEM_NAME,string strPROJECT_NAME,string strATTACH_FILE,string strNOTE,string strCREATED_BY,string currentTime)
{ string str_Sql1="INSERT INTO CUST_REQUEST ";
str_Sql1=str_Sql1+" (REQUEST_CODE,REQUEST_BY,REQUEST_FROM,STATUS,REQUEST_TYPE,DESCRIPTION,SYSTEM_NAME,PROJECT_NAME,ATTACH_FILE,NOTE,CREATED_BY,CREATED_DATE,ACTIVE) ";
str_Sql1=str_Sql1+" VALUES ('"+strREQUEST_CODE+"','"+strREQUEST_BY+"','"+strREQUEST_FROM+"',"+intSTATUS+","+intREQUEST_TYPE+",'"+strDESCRIPTION+"','"+strSYSTEM_NAME+"','"+strPROJECT_NAME+"','"+strATTACH_FILE+"','"+strNOTE+"','"+strCREATED_BY+"','"+currentTime+"','1')";
connConfig.ExeSql(str_Sql1);
} //-----------------------------------------------
}
}