/// <summary> /// 添加合同 /// </summary> /// <param name="cInfo"></param> /// <returns></returns> public int AddContractmanagement(Contractmanagement cInfo) { string sql = @"INSERT INTO [dbo].[Contractmanagement] ([Contractnumber] ,[Contractname] ,[Contracttype] ,[Personincharge] ,[Effectivedate] ,[Expirationdate] ,[Status] ,[CreateTime] ,[UpdateTime] ,[CreaterId] ,[UpdaterId]) VALUES @Contractnumber ,@Contractname ,@Contracttype ,@Personincharge ,@Effectivedate ,@Expirationdate ,1 ,GETDATE() ,GETDATE() ,1 ,1"; return(DapperHelper <Contractmanagement> .Execute(sql, cInfo)); }
/// <summary> /// 修改合同 /// </summary> /// <returns></returns> public int UpdateContractmanagement(Contractmanagement cInfo) { string sql = @"UPDATE [dbo].[Contractmanagement] SET [Contractnumber] = @Contractnumber ,[Contractname] =@Contractname ,[Contracttype] = @Contracttype ,[Personincharge] =@Personincharge ,[Effectivedate] = @Effectivedate ,[Expirationdate] =@Expirationdate ,[Status] =1 ,[CreateTime] =GetDate() ,[UpdateTime] =GetDate() ,[CreaterId] =1 ,[UpdaterId] =1 WHERE Id=@Id "; return(DapperHelper <Contractmanagement> .Execute(sql, cInfo)); }