/// <summary> /// 更新工作站事务方法 /// </summary> /// <param name="dt">dataTable</param> /// <returns></returns> public bool UpDateOrgWorStaTran(DataTable dt, string orgId) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OrgOrganize set "); strSql.Append("OrgName=@OrgName,"); strSql.Append("OrgAddress=@OrgAddress,"); strSql.Append("OrgPhone=@OrgPhone,"); strSql.Append("OrgFax=@OrgFax,"); strSql.Append("OrgType=@OrgType,"); strSql.Append("OrgParentId=@OrgParentId "); strSql.Append(" where OrgId=@OrgId "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "OrgId", DbType.Int64, dt.Rows[0]["OrgId"]); db.AddInParameter(dbCommand, "OrgName", DbType.String, dt.Rows[0]["OrgName"]); db.AddInParameter(dbCommand, "OrgAddress", DbType.String, dt.Rows[0]["OrgAddress"]); db.AddInParameter(dbCommand, "OrgPhone", DbType.AnsiString, dt.Rows[0]["OrgPhone"]); db.AddInParameter(dbCommand, "OrgFax", DbType.AnsiString, dt.Rows[0]["OrgFax"]); db.AddInParameter(dbCommand, "OrgType", DbType.Byte, dt.Rows[0]["OrgType"]); db.AddInParameter(dbCommand, "OrgParentId", DbType.Int64, dt.Rows[0]["OrgParentId"]); bool result = false; using (DbConnection conn = db.CreateConnection()) { conn.Open(); DbTransaction trans = conn.BeginTransaction(); try { db.ExecuteNonQuery(dbCommand, trans); StringBuilder strSql2 = new StringBuilder(); strSql2.Append("update OrgWorkStation set "); strSql2.Append("Size=@Size,"); strSql2.Append("Area=@Area,"); strSql2.Append("Manager=@Manager,"); strSql2.Append("ManagerPhone=@ManagerPhone"); strSql2.Append(" where OrgId=@OrgId "); DbCommand dbCommand2 = db.GetSqlStringCommand(strSql2.ToString()); db.AddInParameter(dbCommand2, "OrgId", DbType.Int64, dt.Rows[0]["OrgId"]); db.AddInParameter(dbCommand2, "Size", DbType.String, dt.Rows[0]["Size"]); db.AddInParameter(dbCommand2, "Area", DbType.String, dt.Rows[0]["Area"]); db.AddInParameter(dbCommand2, "Manager", DbType.String, dt.Rows[0]["Manager"]); db.AddInParameter(dbCommand2, "ManagerPhone", DbType.AnsiString, dt.Rows[0]["ManagerPhone"]); db.ExecuteNonQuery(dbCommand2, trans); ECommerce.Admin.DAL.SWCompany swcDal = new SWCompany(); ECommerce.Admin.Model.SWCompany swcInfo = swcDal.GetModelBySWOrgId(dt.Rows[0]["OrgId"].ToString()); StringBuilder strSql3 = new StringBuilder(); if (swcInfo != null) { strSql3.Append("Update SWCompany set COrgId=@COrgId where SWOrgId=@SWOrgId"); DbCommand dbCommand3 = db.GetSqlStringCommand(strSql3.ToString()); db.AddInParameter(dbCommand3, "SWOrgId", DbType.Int32, dt.Rows[0]["OrgId"]); db.AddInParameter(dbCommand3, "COrgId", DbType.Int32, orgId); db.ExecuteScalar(dbCommand3, trans); } else { strSql3.Append("insert into SWCompany("); strSql3.Append("SWOrgId,COrgId)"); strSql3.Append(" values ("); strSql3.Append("@SWOrgId,@COrgId)"); DbCommand dbCommand3 = db.GetSqlStringCommand(strSql3.ToString()); db.AddInParameter(dbCommand3, "SWOrgId", DbType.Int32, dt.Rows[0]["OrgId"]); db.AddInParameter(dbCommand3, "COrgId", DbType.Int32, orgId); db.ExecuteScalar(dbCommand3, trans); } trans.Commit(); result = true; } catch { trans.Rollback(); } conn.Close(); return result; } }
/// <summary> /// 更新工作站事务方法 /// </summary> /// <param name="dt">dataTable</param> /// <returns></returns> public bool UpDateOrgWorStaTran(DataTable dt, string orgId) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OrgOrganize set "); strSql.Append("OrgName=@OrgName,"); strSql.Append("OrgAddress=@OrgAddress,"); strSql.Append("OrgPhone=@OrgPhone,"); strSql.Append("OrgFax=@OrgFax,"); strSql.Append("OrgType=@OrgType,"); strSql.Append("OrgParentId=@OrgParentId "); strSql.Append(" where OrgId=@OrgId "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "OrgId", DbType.Int64, dt.Rows[0]["OrgId"]); db.AddInParameter(dbCommand, "OrgName", DbType.String, dt.Rows[0]["OrgName"]); db.AddInParameter(dbCommand, "OrgAddress", DbType.String, dt.Rows[0]["OrgAddress"]); db.AddInParameter(dbCommand, "OrgPhone", DbType.AnsiString, dt.Rows[0]["OrgPhone"]); db.AddInParameter(dbCommand, "OrgFax", DbType.AnsiString, dt.Rows[0]["OrgFax"]); db.AddInParameter(dbCommand, "OrgType", DbType.Byte, dt.Rows[0]["OrgType"]); db.AddInParameter(dbCommand, "OrgParentId", DbType.Int64, dt.Rows[0]["OrgParentId"]); bool result = false; using (DbConnection conn = db.CreateConnection()) { conn.Open(); DbTransaction trans = conn.BeginTransaction(); try { db.ExecuteNonQuery(dbCommand, trans); StringBuilder strSql2 = new StringBuilder(); strSql2.Append("update OrgWorkStation set "); strSql2.Append("Size=@Size,"); strSql2.Append("Area=@Area,"); strSql2.Append("Manager=@Manager,"); strSql2.Append("ManagerPhone=@ManagerPhone"); strSql2.Append(" where OrgId=@OrgId "); DbCommand dbCommand2 = db.GetSqlStringCommand(strSql2.ToString()); db.AddInParameter(dbCommand2, "OrgId", DbType.Int64, dt.Rows[0]["OrgId"]); db.AddInParameter(dbCommand2, "Size", DbType.String, dt.Rows[0]["Size"]); db.AddInParameter(dbCommand2, "Area", DbType.String, dt.Rows[0]["Area"]); db.AddInParameter(dbCommand2, "Manager", DbType.String, dt.Rows[0]["Manager"]); db.AddInParameter(dbCommand2, "ManagerPhone", DbType.AnsiString, dt.Rows[0]["ManagerPhone"]); db.ExecuteNonQuery(dbCommand2, trans); ECommerce.Admin.DAL.SWCompany swcDal = new SWCompany(); ECommerce.Admin.Model.SWCompany swcInfo = swcDal.GetModelBySWOrgId(dt.Rows[0]["OrgId"].ToString()); StringBuilder strSql3 = new StringBuilder(); if (swcInfo != null) { strSql3.Append("Update SWCompany set COrgId=@COrgId where SWOrgId=@SWOrgId"); DbCommand dbCommand3 = db.GetSqlStringCommand(strSql3.ToString()); db.AddInParameter(dbCommand3, "SWOrgId", DbType.Int32, dt.Rows[0]["OrgId"]); db.AddInParameter(dbCommand3, "COrgId", DbType.Int32, orgId); db.ExecuteScalar(dbCommand3, trans); } else { strSql3.Append("insert into SWCompany("); strSql3.Append("SWOrgId,COrgId)"); strSql3.Append(" values ("); strSql3.Append("@SWOrgId,@COrgId)"); DbCommand dbCommand3 = db.GetSqlStringCommand(strSql3.ToString()); db.AddInParameter(dbCommand3, "SWOrgId", DbType.Int32, dt.Rows[0]["OrgId"]); db.AddInParameter(dbCommand3, "COrgId", DbType.Int32, orgId); db.ExecuteScalar(dbCommand3, trans); } trans.Commit(); result = true; } catch { trans.Rollback(); } conn.Close(); return(result); } }