110,536
社区成员
发帖
与我相关
我的任务
分享
PLT.BLL.SYS_PUBLIC bpub = new PLT.BLL.SYS_PUBLIC();
SqlConnection Conn = bpub.SqlConn();
SqlTransaction trans = Conn.BeginTransaction();
try
{
gFunc.SaveGridTrans(ref Conn, ref trans, ref id_Grid2, "BI_CONTACT Where C_TYPE = '1'");
gFunc.SaveGridTrans(ref Conn, ref trans, ref id_Grid3, "BI_CONTACT Where C_TYPE = '2'");
gFunc.SaveGridTrans(ref Conn, ref trans, ref id_Grid4, "BI_CARGO");
gFunc.SaveGridTrans(ref Conn, ref trans, ref id_Grid5, "BI_QUOTE");
trans.Commit();
MessageBox.Show("保存成功!");
}
catch (Exception ex)
{
trans.Rollback();
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
Conn.Dispose();
}
}
}
public static void SaveGridTrans(ref SqlConnection SendConn, ref SqlTransaction SendTran, ref DataSet SendDs, string Sendtbname)
{
SqlCommand sqlcmd = new SqlCommand();
SqlDataAdapter sqlada = new SqlDataAdapter();
sqlcmd.Connection = SendConn;
sqlcmd.Transaction = SendTran;
sqlcmd.CommandText = "Select * From " + Sendtbname;
sqlada.SelectCommand = sqlcmd;
SqlCommandBuilder Sqlcb = new SqlCommandBuilder(sqlada);
sqlada.Update(SendDs.Tables[0]);
SendDs.Tables[0].AcceptChanges();
}