不知道lh.AddLaborTable中是自己处理数据连接还是由调用它的程序控制。


如果是自身处理的话，你检查一下开闭数据库的次数。
  回复  引用  查看    

public void AddLaborTable(string username, string realname, string part, string amount, string remarks, string account)
{
SqlParameter[] parameters = {
new SqlParameter("@username", SqlDbType.NVarChar,256),
new SqlParameter("@realname", SqlDbType.VarChar,250),
new SqlParameter("@part", SqlDbType.VarChar,50),
new SqlParameter("@amount", SqlDbType.VarChar,50),
new SqlParameter("@remarks", SqlDbType.VarChar,250),
new SqlParameter("@account", SqlDbType.VarChar,250)
};
parameters[0].Value = username;
parameters[1].Value = realname;
parameters[2].Value = part;
parameters[3].Value = amount;
parameters[4].Value = remarks;
parameters[5].Value = account;



sdh.ExecuteSql("INSERT INTO [TFM].[dbo].[Labor] ([UserName] ,[RealName] ,[Part] ,[Amount] ,[Remarks] ,[account]) VALUES (@username,@realname,@part,@amount,@remarks,@account)", parameters);
}




public int ExecuteSql(string SQLString, params SqlParameter[] cmdParms)
{
using (SqlConnection connection = new SqlConnection(strConn))
{
using (SqlCommand cmd = new SqlCommand())
{
try
{
PrepareCommand(cmd, connection, null, SQLString, cmdParms);
int rows = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return rows;
}
catch (System.Data.SqlClient.SqlException E)
{
throw new Exception(E.Message);
}
}
}
}
  回复  引用  查看    

@品味寂寞
应该是插一条开一次数据库
  回复  引用  查看