/// <summary>更新往来账核对信息
/// </summary>
/// <param name="reckoningCheckInfo"> </param>
public void UpdateReckoningCheck(ReckoningCheckInfo reckoningCheckInfo)
{
var parm = new[]
{
new SqlParameter(PARM_RECKONING_ID, SqlDbType.UniqueIdentifier)
{
Value = reckoningCheckInfo.ReckoningId
},
new SqlParameter(PARM_MEMO, SqlDbType.VarChar)
{
Value = reckoningCheckInfo.Memo
},
new SqlParameter(PARM_DATE_CREATED, SqlDbType.DateTime)
{
Value = reckoningCheckInfo.DateCreated
}
};
try
{
SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, SQL_UPDATE_RECKONINGCHECK_BY_RECKONINGID, parm);
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message);
}
}
/// <summary>插入一条往来账核对信息
/// </summary>
/// <param name="reckoningCheckInfo"></param>
public void InsertReckoningCheck(ReckoningCheckInfo reckoningCheckInfo)
{
const string SQL_INSERT_RECKONINGCHECK = @"
IF EXISTS(SELECT ReckoningId FROM [ReckoningCheck] WHERE ReckoningId=@ReckoningId)
UPDATE dbo.ReckoningCheck SET [Memo]=[Memo]+@Memo WHERE ReckoningId=@ReckoningId
ELSE
INSERT INTO ReckoningCheck([ReckoningId],[Memo],DateCreated) VALUES (@ReckoningId,@Memo,@DateCreated);" ;
var parms = new[]
{
new SqlParameter(PARM_RECKONING_ID, SqlDbType.UniqueIdentifier)
{
Value = reckoningCheckInfo.ReckoningId
},
new SqlParameter(PARM_MEMO, SqlDbType.VarChar)
{
Value = reckoningCheckInfo.Memo
},
new SqlParameter(PARM_DATE_CREATED, SqlDbType.DateTime)
{
Value = reckoningCheckInfo.DateCreated
}
};
try
{
SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, SQL_INSERT_RECKONINGCHECK, parms);
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message);
}
}
