/// <summary>
/// 使用session执行sql命令（update，insert）
/// 返回0则成功，其他为错误代码
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static string exeSql(AppSvrHMI.L3Adapter adapter, string strSql)
{
try
{
if (adapter.Session == null || !adapter.Session.Opened)
{
//MessageBox.Show("adapter连接没有打开，请重新登陆");
return(null);
}
AppSvrIF.Command cmd = null;
//创建sql命令
int result = adapter.Session.CreateCommand(14, strSql, "", ref cmd);
if (result == 0)
{
//使用session执行sql命令
return(adapter.Session.Execute(cmd).ToString());
}
else
{
return(result.ToString());
}
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public AppSvrHMI.L3DataSet ShowDialogExL(AppSvrHMI.L3Adapter adapter, int nPosition, string strSort, AppSvrHMI.L3DataSet dsData)
{
Adapter = adapter;
txtCopy.Text = "";
dsReturn = dsData;
bsDesStdMainten.DataSource = null;
bsDesStdMainten.DataSource = dsReturn;
bsDesStdMainten.DataMember = dsReturn.Tables[0].TableName;
((System.Data.DataRowView)(bsDesStdMainten.Current)).DataView.Sort = strSort;
bsDesStdMainten.Position = nPosition;
strSteelGradeIndex = dsData.Tables[0].Rows[nPosition]["SteelGradeIndex"].ToString();
ShowDialog();
return(dsReturn);
}
public DataTable GetData(AppSvrHMI.L3Adapter adapter, string strSql)
{
if (adapter.Session == null || !adapter.Session.Opened)
{
MessageBox.Show("adapter连接没有打开，请重新登陆");
return(null);
}
adapter.RefreshDataBindings();
AppSvrIF.Command cmdSQl = new AppSvrIF.Command();
int iRet = adapter.Session.CreateCommand((int)AppSvrIF.CommandType.QueryBySQL, strSql, "", ref cmdSQl);
if (iRet != 0)
{
MessageBox.Show("创建查询命令失败，请重新登陆");
return(null);
}
iRet = adapter.Session.Execute(cmdSQl);
if (iRet != 0)
{
MessageBox.Show("服务执行出现错误，请重新登陆");
return(null);
}
if (!(cmdSQl.Return is AppSvrIF.Recordset))
{
MessageBox.Show("返回结果错误，请重新登陆");
return(null);
}
AppSvrIF.Recordset rs = cmdSQl.Return as AppSvrIF.Recordset;
if (rs.Tables[0].Rows.Count < 1)
{
return(null);
}
else
{
return(rs.Tables[0]);
}
}
public static DataTable GetData(AppSvrHMI.L3Adapter adapter, string strSql)
{
if (adapter.Session == null || !adapter.Session.Opened)
{
MessageBox.Show("adapterÁ¬½ÓûÓдò¿ª£¬ÇëÖØеǽ");
return(null);
}
adapter.RefreshDataBindings();
AppSvrIF.Command cmdSQl = new AppSvrIF.Command();
int iRet = adapter.Session.CreateCommand((int)AppSvrIF.CommandType.QueryBySQL, strSql, "", ref cmdSQl);
if (iRet != 0)
{
MessageBox.Show("´´½¨²éѯÃüÁîʧ°Ü£¬ÇëÖØеǽ");
return(null);
}
iRet = adapter.Session.Execute(cmdSQl);
if (iRet != 0)
{
MessageBox.Show("·þÎñÖ´ÐгöÏÖ´íÎó£¬ÇëÖØеǽ");
return(null);
}
if (!(cmdSQl.Return is AppSvrIF.Recordset))
{
MessageBox.Show("·µ»Ø½á¹û´íÎó£¬ÇëÖØеǽ");
return(null);
}
AppSvrIF.Recordset rs = cmdSQl.Return as AppSvrIF.Recordset;
if (rs.Tables[0].Rows.Count < 1)
{
return(null);
}
else
{
return(rs.Tables[0]);
}
}