/// <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));
}
