public static int CardGS(Card_GSInfo info)
{
int re = -1;
try
{
string constr = SqlHelper.GetConnStr();
SqlConnection con = new SqlConnection(constr);
//打开数据库连接
con.Open();
//定义SQL语句或存储过程执行对象
SqlCommand myCommand = new SqlCommand();
//指定执行对象的数据库连接
myCommand.Connection = con;
//定义一个事务类
SqlTransaction myTrans;
//获取数据库连接上启动的事务
myTrans = con.BeginTransaction();
//指定SQL语句执行对象的事务
myCommand.Transaction = myTrans;
try
{
StringBuilder sql = new StringBuilder();
sql.Append("update Card set \r\n");
sql.Append("GSBZ='0',\r\n");
sql.Append("GSRQ='" + info.RQ + "' \r\n");
sql.Append("where CardID='" + info.CardID + "'");
myCommand.CommandText = sql.ToString();
myCommand.ExecuteNonQuery();
sql.Clear();
sql.Append("insert into Card_GS (RYID,CardNo,CardID,RQ,CZRY) \r\n");
sql.Append("values (\r\n");
sql.Append(info.RYID + ",\r\n");
sql.Append("'" + info.CardNo + "',\r\n");
sql.Append("'" + info.CardID + "',\r\n");
sql.Append("'" + info.RQ + "',\r\n");
sql.Append(info.CZRY + " \r\n");
sql.Append(")\r\n");
sql.Append(";select @@IDENTITY");
myCommand.CommandText = sql.ToString();
re = Convert.ToInt32(myCommand.ExecuteScalar());
//提交事务
myTrans.Commit();
}
catch
{
//事务回滚
myTrans.Rollback();
re = -1;
}
finally
{
//关闭数据库连接
con.Close();
}
}
catch
{
re = -1;
}
return re;
}