调用数据库范例

/*
函数名称：ExecProc(s_connstr,m_savesql,m_sqlnum, isequal, codeSql,scodeSql, bz)
参数说明：
s_connstr:连接对象
m_savesql:sql语句数组
m_sqlnum:sql语句条数
isequal:default 0(此参数暂时没用)
code:一条sql语句返回的值
scode:一条sql语句返回的值
bz:(0:不取code和scode值; 1:相反)

此语句可执行N条语句
*/

[WebMethod]
#region 增加日记分类
public string AddDiaryCls(string[] arr)
{
string codesql="select @code=max(sDiyCode)+1 from X5_DiaryCls with(tablockx,holdlock)";
int m_sqlnum=0;
string[] m_savesql=new string[200];
string m_sql="";
m_sql="insert into X5_DiaryCls(sPersoncode,sDiyCode,sDiyName,sDiyMemo,lopen,bDiyEnd,lDiyGrade) values(";
m_sql+="'001','"+@code+"','"StrHelp.HtmlEncode(arry[0])+"','"+StrHelp.HtmlEncode(arry[1])+"',"+Convert.ToInt16(arry[2])+",'1','1')";
m_savesql[m_sqlnum]=m_sql;
m_sqlnum+=1;
string[] m_myarr=s_server.ExecProc(s_connstr,m_savesql,m_sqlnum, 0,codesql,"", 1);
if (m_myarr[0]!="0")
return false;
else
return true;
}
#endregion 增加日记分类