SampleCase_
<Gen-it>
24-01-2001
{{Gen-it:BeginFile#.asmx#}}<%@ WebService Language="c#" Codebehind=".cs" Class="SampleCase."%>
{{Gen-it:EndFile}}
{{Gen-it:BeginFile#.cs#}}namespace SampleCase
{
using System;
using System.Collections;
using System.Configuration;
using System.ComponentModel;
using System.Data;
using System.Data.ADO;
using System.Diagnostics;
using System.Web;
using System.Web.Services;
///
/// Summary description for .
///
public class : System.Web.Services.WebService
{
private SQL objSQL;
private ADOConnection objConnection;
public ()
{
//CODEGEN: This call is required by the ASP+ Web Services Designer
InitializeComponent();
objSQL = new SQL();
objConnection = new ADOConnection ();
// Refactor-->
objConnection.ConnectionString = "Provider=SQLOLEDB.1;User ID=sa;Persist Security Info=False;Initial Catalog=UVNET;Data Source=C003W2K";
}
///
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///
private void InitializeComponent()
{
}
///
/// Clean up any resources being used.
///
public override void Dispose()
{
}
[WebMethod]
public DataSet Open()
{
return this.Select();
}
[WebMethod]
public void Save(DataSet ds)
{
// Update all new, deleted and modified rows in objData
foreach (DataRow objRow in ds.Tables[0].Rows)
{
switch (objRow.RowState)
{
case DataRowState.Modified:
this.Update(objRow);
break;
case DataRowState.Deleted:
this.Delete(objRow);
break;
case DataRowState.New:
this.Insert(objRow);
break;
default:
break;
}
}
return;
}
private DataSet Select()
{
ADODataSetCommand objDataSetCommand;
DataSet objDataSet;
String strSQL;
strSQL = objSQL.GetSelectSQL();
objDataSetCommand = objSQL.GetSelectCommand(strSQL, ref objConnection);
objDataSet = new DataSet();
objConnection.Open();
objDataSet.EnforceConstraints = false;
objDataSetCommand.FillDataSet(objDataSet);
objDataSet.EnforceConstraints = true;
objConnection.Close();
return objDataSet;
}
private void Insert (System.Data.DataRow objRow)
{
ADOCommand objCommand;
string strSQL;
strSQL = objSQL.GetInsertSQL();
objCommand = objSQL.GetInsertCommand(strSQL, ref objRow, ref objConnection);
objCommand.ActiveConnection.Open();
objCommand.ExecuteNonQuery();
objConnection.Close();
return;
}
private void Update (System.Data.DataRow objRow)
{
ADOCommand objCommand;
string strSQL;
strSQL = objSQL.GetUpdateSQL();
objCommand = objSQL.GetUpdateCommand(strSQL, ref objRow, ref objConnection);
objConnection.Open();
objCommand.ExecuteNonQuery();
objConnection.Close();
return;
}
private void Delete (System.Data.DataRow objRow)
{
ADOCommand objCommand;
string strSQL;
strSQL = objSQL.GetDeleteSQL();
objCommand = objSQL.GetDeleteCommand(strSQL, ref objRow, ref objConnection);
objCommand.ActiveConnection.Open();
objCommand.ExecuteNonQuery();
objConnection.Close();
return;
}
}
}
{{Gen-it:EndFile}}
{{Gen-it:BeginFile#SQL.cs#}}namespace SampleCase
{
using System;
using System.Data;
using System.Data.ADO;
///
/// Summary description for SQL.
///
public class SQL
{
public SQL()
{
//
// TODO: Add Constructor Logic here
//
}
public string GetInsertSQL()
{
string strSQL;
strSQL = "INSERT INTO ( ";
strSQL = strSQL + ", ";
strSQL = strSQL + ") VALUES( ";
strSQL = strSQL + "?, ";
strSQL = strSQL + ")";
return strSQL;
}
public ADOCommand GetInsertCommand(string strSQL, ref DataRow objRow, ref ADOConnection objConnection)
{
ADOCommand objCommand;
ADOParameter objParam;
objCommand = new ADOCommand(strSQL, objConnection);
objParam = New SQLParameter("", )
objParam.Value = objRow[""];
objCommand.Parameters.Add(objParam)
return objCommand;
}
public string GetUpdateSQL()
{
string strSQL;
strSQL = "UPDATE SET ";
strSQL = strSQL + " = ? , ";
strSQL = strSQL + "WHERE ( = ?) ";
return strSQL;
}
public ADOCommand GetUpdateCommand(string strSQL, ref DataRow objRow, ref ADOConnection objConnection)
{
ADOCommand objCommand;
objCommand = new ADOCommand(strSQL, objConnection);
objParam = New SQLParameter("", )
objParam.Value = objRow[""];
objCommand.Parameters.Add(objParam)
objParam = New SQLParameter("", )
objParam.Value = objRow[""];
objCommand.Parameters.Add(objParam)
return objCommand;
}
public string GetDeleteSQL()
{
string strSQL;
strSQL = "DELETE FROM WHERE ";
strSQL = strSQL + "( = ?) ";
return strSQL;
}
public ADOCommand GetDeleteCommand(string strSQL, ref DataRow objRow, ref ADOConnection objConnection)
{
ADOCommand objCommand;
objCommand = new ADOCommand(strSQL, objConnection);
objRow.RejectChanges();
objParam = New SQLParameter("", )
objParam.Value = objRow[""];
objCommand.Parameters.Add(objParam)
return objCommand;
}
public string GetSelectSQL(string strWhere, string strOrder)
{
string strSQL;
strSQL = "SELECT ";
strSQL = strSQL + ", ";
strSQL = strSQL + "FROM ";
strSQL = strSQL + strWhere + " ";
strSQL = strSQL + strOrder + " ";
return strSQL;
}
public string GetSelectSQL(string strWhere)
{
return GetSelectSQL(strWhere, "");
}
public string GetSelectSQL()
{
return GetSelectSQL("", "");
}
public ADODataSetCommand GetSelectCommand(string strSQL, ref ADOConnection objConnection)
{
ADODataSetCommand objDataSetCommand;
objDataSetCommand = new ADODataSetCommand(strSQL, objConnection);
objDataSetCommand.TableMappings.Add("Table","");
return objDataSetCommand;
}
}
}
{{Gen-it:EndFile}}
Integer
Long
String
Decimal
Double
Date
Single
Date
String
int
lng
str
dec
dbl
dat
dec
dat
str
ADODBType.Int
Numeric
VarChar
Decimal
Float
DateTime
Real
TimeStamp
Text
'
Function Upper(nodelist)
Upper = UCASE(nodelist.nextNode().text)
End Function
'
Function Lower(nodelist)
Lower = LCASE(nodelist.nextNode().text)
End Function
'
Function CapFirst(nodelist)
dim strText
dim strOutput
strText = nodelist.nextNode().text
strOutput = UCASE(Left( strText, 1))
strOutput = strOutput + LCASE((Right( strText, LEN(strText)-1)))
CapFirst = strOutput
End Function
'
Function FillSpace(nodelist, length)
dim strText
dim strOutput
strText = nodelist.nextNode().text
strOutput = strText + String( length - LEN(strText) , " ")
FillSpace = strOutput
End Function