摘要：
CREATE PROCEDURE [dbo].[up_TransportationDetailEdit]@TransGuid uniqueidentifier,@RequestGuid uniqueidentifier,@TransFrom varchar(50),@TransTo varchar(50),@TransDate datetime,@TransNo varchar(50),@DepTime varchar(10),@ArrTime varchar(10),@CreatedAt datetimeASIF(EXISTS(SELECT 1 FROM T_TransportationDe 阅读全文
摘要：
CREATE PROCEDURE [dbo].[up_AccountItemSelectALL]ASSELECT a.AccountGuid, a.AccountCategory, a.AccountName, a.AccountFSCode, a.DICGuid, a.IsObsoleted, d.DepartmentName, d.DepartmentCode FROM dbo.T_AccountItem AS aLEFT OUTER JOIN dbo.T_Department AS dON a.DICGuid = d.DepartmentGuidORDER BY a.AccountCat 阅读全文
摘要：
create PROCEDURE [dbo].[up_AccountItemEdit]@AccountGuid uniqueidentifier,@AccountCategory varchar(50),@AccountName varchar(50),@AccountFSCode varchar(50),@DICGuid uniqueidentifier,@IsObsoleted bitASIF(EXISTS(SELECT 1 FROM T_AccountItem trm WHERE trm.AccountGuid=@AccountGuid))BEGIN UPDATE T_AccountIt 阅读全文
摘要：
/// ///事务 ///internal SqlTransaction Transaction { get; set; }public string EditEmployee(OrgEmployee employee, Guid departmentGuid, Guid companyGuid, bool isPIC){SqlPlus plus = new SqlPlus();string result = string.Empty;using (SqlConnection conn = plus.GetConnection()){conn.Open();this.Transaction = 阅读全文
摘要：
public static string DefaultConnString{get{return ConfigurationManager.AppSettings["Connection"];} }/// /// 构造事务 ///public SqlTransaction GetTransaction(){using (SqlConnection connection = new SqlConnection(this.SqlConnString)){connection.Open();SqlTransaction trans = connection.BeginTrans 阅读全文
摘要：
'> 阅读全文